By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,152 Members | 1,647 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,152 IT Pros & Developers. It's quick & easy.

Check for existence of server

P: n/a
Is there any sort of check that can be done to see if a particular instance
of SQL Server is present? I already call a method to check for connection --
if no connection, I have the user re-enter server settings (server name and
database name). But the connection check is made by calling for a scalar
value in the database. What I'd rather do is graduate the error messages:

1. No server installed
2. Specified database name not installed
3. Specfied table or sproc not available

Any thoughts?
Jan 3 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Earl
1) if not exists (select * from sysservers where svrname ='blblb')
print 'Server does not exist'

2) if not exists (select * from sysdatabases where name ='blblb')
print Database does not exist'

3) if object_id('test') is null
print 'An object does not exist'

"Earl" <br******@newsgroups.nospamwrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl...
Is there any sort of check that can be done to see if a particular
instance of SQL Server is present? I already call a method to check for
connection -- if no connection, I have the user re-enter server settings
(server name and database name). But the connection check is made by
calling for a scalar value in the database. What I'd rather do is graduate
the error messages:

1. No server installed
2. Specified database name not installed
3. Specfied table or sproc not available

Any thoughts?

Jan 3 '07 #2

P: n/a
Sure as shown on page 565, you can use the dbProviderFactories.GetFactory
method to return a list of (visible) servers based on a specific provider.
These same classes can be used to start, stop or pause the server service as
well (in addition to others).

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Earl" <br******@newsgroups.nospamwrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl...
Is there any sort of check that can be done to see if a particular
instance of SQL Server is present? I already call a method to check for
connection -- if no connection, I have the user re-enter server settings
(server name and database name). But the connection check is made by
calling for a scalar value in the database. What I'd rather do is graduate
the error messages:

1. No server installed
2. Specified database name not installed
3. Specfied table or sproc not available

Any thoughts?

Jan 3 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.