Viewing post 1 (of 1 total)
Vikas Rajput (7/29/2008)SELECT @crdate=crdate FROM sysdatabases WHERE NAME='tempdb'
I had to modify this part to look like this for it to work in MS SQL 2008:
SELECT @crdate=create_date FROM sys.databases WHERE NAME='tempdb'
September 28, 2011 at 3:23 am
#1387614