THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web
Sign in
|
|
in
Current Tags
(Entire Site)
Search
Home
Blogs
Downloads
Opml
Browse by Tags
All Tags
»
denali
»
DB_ID
»
integration ser...
»
system database...
»
breaking change...
»
SQL Server "Denali"
(RSS)
backward compatibility
database_id
deprecation
SSIS
SSISDB
SQL Server v.Next (Denali) : Breaking change to system databases / database_id / DB_ID()
Currently you may have code that makes decisions based on sys.databases.database_id or the built-in DB_ID() function. I have seen a lot of code out there that checks the database_id, and behaves differently based on the assumption that a value between 1 and 4 (as well as 32,767 - the resource database) means it is a system database, and anything ...
Posted to
Aaron Bertrand
(Weblog)
by
AaronBertrand
on
July 8, 2011
©2006-2012 SQLblog.com
TM
Brought to you by
Adam Machanic
&
Peter DeBetta
Privacy Statement