|
 |
About Us | |
|
SSWUG Articles | |
 |
Articles | |
|
FAQ |
|
Administration | |
|
Backup/Restore | |
|
Connectivity | |
 |
Development | |
|
General | |
|
Installation | |
|
OLAP | |
|
Replication | |
|
Transfer/move | |
|
Trouble | |
|
SQL 6.5 |
|
Scripts | |
|
Tips | |
|
Test Exams | |
|
Advertise | |
|
Download | |
|
History | |
|
Search | |
|
Traffic | |
|
Related Links | |
|
||
|
|
||
 How do I get the date the object was created? Answer: To get the date the object was created, you can query the sysobjects system table to see the crdate column. This is the example to get the date the authors table was created: SELECT crdate FROM sysobjects WHERE name = 'authors' Read about the sysobjects system table in SQL Server Books Online. |