MCITP

MCITP

Tuesday, September 11, 2012

To find SQL SERVER 2000 install date via T-SQL


select  schemadate,* from sysservers

SELECT  createdate as Sql_Server_Install_Date  FROM    syslogins where   name = NTAUTHORITY\SYSTEM'

2 comments:

  1. I feel satisfied to read your blog, you have been delivering a useful & unique information to our vision even you have explained the concept as deep clean without having any uncertainty, keep blogging. SQL server dba Online Training

    ReplyDelete

Followers