December 12, 2008 at 1:03 pm
hi,
How can i check through
1- SQL Server is running or not (i.e status of sql server)
2- SQL Server is accepting new logins (i.e connection pool is not full, or there is no process blocking)
Thanks,
Usman
December 12, 2008 at 1:46 pm
You can either download a tool to perform these checks or you can run queries from a remote machine to check on the status of SQL and whether logins are functioning.
Check for scripts on this site.
December 12, 2008 at 1:50 pm
Nicholas Cain (12/12/2008)
You can either download a tool to perform these checks or you can run queries from a remote machine to check on the status of SQL and whether logins are functioning.Check for scripts on this site.
Thanks Nick, but i cannot see the website url, can you please repost it?
December 12, 2008 at 3:52 pm
Are you saying how can you programmatically check?
because trying to log in with SSMS is probably a good first place to start for most people.
:hehe:
~BOT
Craig Outcalt
December 13, 2008 at 7:37 am
usman.tanveer (12/12/2008)
Nicholas Cain (12/12/2008)
You can either download a tool to perform these checks or you can run queries from a remote machine to check on the status of SQL and whether logins are functioning.Check for scripts on this site.
Thanks Nick, but i cannot see the website url, can you please repost it?
Just hit the "Scripts" link on the left side of the page, near the top and perform a search. There's some great stuff out there that will do just what you require. 🙂
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply