Sybase Question:
Download Questions PDF

How can I tell the datetime my Server started?


Answer #1
Method #1
The normal way would be to look at the errorlog, but this is not always convenient or even possible. From a SQL session you find out the server startup time to within a few seconds using:
select "Server Start Time" = crdate
from master..sysdatabases
where name = "tempdb"

Method #2
Another useful query is:
select * from sysengines
which gives the address and port number at which the server is listening.

Answer #2
select @@bootime
errorlog file

Download Sybase Interview Questions And Answers PDF

Previous QuestionNext Question
How do I interpret the tli strings in the interface file?Raw partitions or regular files?