Have you used xp_getfiledetails extend stored procedure in SQL Server 2000? This undocumented sp used to get details of a given external files.
For example,
EXEC master.dbo.xp_getfiledetails 'c:\pagefile.sys'
will give you following details
1. Size of the file in Bytes
2.Creation Date
3.Creation Time
4. Last Written Date
5. Last Written Time
6.Last Accessed Date
7.Last Accessed Time
8.Attributes
Problem is this NOT AVAILABLE in SQL SERVER 2005. This is the problem with using undocumented sps. This is why many gurus are advise not to use undocumented sps.
Check out this blog on the updated script for sp_help_revlogin which can be used in SQL 2005 to transfer logins between DB. Also the link to SQL 2000 sp_help_revlogin is there in the blog…
SQL Server 2005: a proposed update of sp_help_revlogin
I’m planning to do Microsoft Certifications for DBA and after analysis i have found that
1) MCDBA for SQL 2000 may retire next year april (April 2009) so we have only one year left for this.
2) For SQL 2005 we have to do MCITP Database Administrator Course which i feel better since now industry demands SQL 2005.
3) For MCITP there is a pre-requiste to do MCTS so we can have two certifications.
Check out this link having comparison on the above certifications!
Also Check out this beautiful Roadmap for Ceritifications
Check this link for the Certifications for Technology