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 - 2007-02-21 : 07:45:25
|
| Sunset writes "I am not familiar with MSDE. I am required to do daily shecks on a SQL server. I have to look for the following:1. If SQL Server is running?2. How many databases are on the server3. What the size of the log file is4. If the SQL service is running.I would like to know which statement to use to do this." |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-02-21 : 10:16:27
|
1. select 1 -- if this fails the service is not running, but you won't even get that far really because you won't even be able to connect with QA or any other method2. select * from sysdatabases3. exec sp_spaceused4. see 1.
www.elsasoft.org |
 |
|
|
|
|
|
Daily check on MSDE