Wednesday 20 April 2011

ASE : How to know when your ASE server was started??

# In ASE 12.5, the server boot time has been captured in loggedindatetime of sysprocesses for the internal system processes:

select min(loggedindatetime)from master..sysprocesses where suid=0

# In ASE 12.5.0.1, it's even simpler:

select @@boottime

The static global variable @@boottime is undocumented, but happens to be identical to sysdatabases.crdate for tempdb.

No comments:

Post a Comment