Need to find the date a table was created in SQL Server 2000

[ckOne1976]

Hi,

is there a TSQL function that will tell me the date a table was created? I have looked at all the SQL date functions and have not come accross anything suitable yet. I am using Microsoft SQL Server 2000.

Thanks

 

[ptheriault]

Check the crdate in the following query

select * from sysobjects
where xtype = 'U'

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[gmmastros]

Try this...

[COLOR=blue]Select[/color] 	[COLOR=blue]Name[/color], crdate 
[COLOR=blue]From[/color] 	sysobjects 
[COLOR=blue]Where[/color] 	xtype = [COLOR=red]'U'[/color]
		And ObjectProperty(id, [COLOR=red]'IsTable'[/color]) = 1
[COLOR=blue]Order[/color] [COLOR=blue]By[/color] [COLOR=blue]name[/color]

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[ckOne1976]

Thanks for that it worked. Would also like to be able to get the date when the table was last changed. Have not found anything suitable so far.

 

[ptheriault]

There is no alter date.

- Paul
- If at first you don't succeed, find out if the loser gets anything.