how to Find Sql server is installed in Local ? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

how to Find Sql server is installed in Local ?

Author

Topic

mathiyazhagan.sekar@gmail
Starting Member

11 Posts

Posted - 2009-01-13 : 02:13:44

Hi Friends,
Is there any system views/tables/SPs to know the information of system where SQL Server (2005) Installed? I want to know whether the SQL server is running in local/Network for backup purpose.Please help me out.

Cheers,
Mathi
India.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-01-13 : 02:23:38

I don't understand the question.
When you connect to the SQL Server you write "servename" or "servername/instancename" when connecting.

E 12°55'05.63"
N 56°04'39.26"

mathiyazhagan.sekar@gmail
Starting Member

11 Posts

Posted - 2009-01-13 : 02:31:00

Hi Peso,
You are right.But,I am writing to backup a database through "backup database " query with ADO.Net.It is possible to backup a database from local system only.so,I have to check whether the system where backup command issued has the instance or to be connected in network.If it is local,I have to proceed with Backup.that's why I want to know whether the SQL server is running in local/Network.Thanks for immediate reply.

Cheers,
Mathi
India.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-01-13 : 02:55:16

You write "(local)" as servername for local sql server. Or "(local)\instancename"...

E 12°55'05.63"
N 56°04'39.26"

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-13 : 10:23:34

quote:
Originally posted by mathiyazhagan.sekar@gmail

Hi Peso,
You are right.But,I am writing to backup a database through "backup database " query with ADO.Net.It is possible to backup a database from local system only.so,I have to check whether the system where backup command issued has the instance or to be connected in network.If it is local,I have to proceed with Backup.that's why I want to know whether the SQL server is running in local/Network.Thanks for immediate reply.

Cheers,
Mathi
India.

You can check in Config manager whether SQL Server is running in
Local or network account.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources