SQL 2000 to SQL 2005: Where Have All the Old Features Gone?


Time of Creation of Stored Procedures

For some reason the time part of the Create Date column in the Summary tab of SQL 2005 is depreciated. Why? I guess someone thought DBAs didn’t need it any longer (I’m rolling my eyes). The good news is you can still get this information by querying the sysobjects table:

Select crdate as DateCreated
From dbo.sysobjects where name = ‘your_proc_name’



Summary

I’ve showed you here how to get by with available SQL 2005 Tools until you upgrade your servers to SQL 2005 Server edition. People get used to their favorite ways to get the job done, and sometimes are “surprised” when their tools are taken away. All of sudden they have to hammer the nail with the handle of a screwdriver. I hope that the ways to attain old functionality will increase productivity, and that the tools will continue to improve.

Pages: 1 2




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |