Saravanan T
SSCrazy
Points: 2506
More actions
May 16, 2011 at 12:24 pm
#239744
Created date for master DB is 2003-04-08 09:13:36.390 in SQL 2008 and SQL 2005. Is there any reason behind this?
Regards, Saravanan
Sean Lange
SSC Guru
Points: 286562
May 16, 2011 at 12:53 pm
#1325397
Pure speculation but that is probably the date that the developer at MS created the database for 2005 and the installer just restores that DB during install. Since it didn't change for 2008 they didn't change the code or the database to restore.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/ Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/ Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/ Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply