Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-29 : 12:21:08
|
| sreekanth writes "i am not familiar with sql server. Mostly i work with oracle. Is there a way to find out the database up time in sqlserver. in oracle i get it through the following sql.select to_char(startup_time,'MM/DD/YYYY HH:MM:SS') starttime, trunc(sysdate - startup_time) days, trunc(mod(24 * (sysdate - startup_time), 24)) hours, round(mod(60 * 24 * (sysdate - startup_time), 60)) minutes from sys.v_$instance;thankssreekanth.g" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-08-29 : 12:59:27
|
| The current errorlog will show when the Server was started.-Chad |
 |
|
|
|
|
|
database uptime