sql server connect: is there a way to tell how a linked server is connecting? -- sql server connect

RE: is there a way to tell how a linked server is connecting?

Mohit K. Gupta
10/5/2007 6:49:00 PM

I belive it uses TCP/IP by default; but I think it depends on the setting of
your SQL Server. You can choose the protocols your SQL Server accepts.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005

[quoted text, click to view]

Re: is there a way to tell how a linked server is connecting?

Razvan Socol
10/5/2007 10:27:19 PM

[quoted text, click to view]

Try something like this:

SELECT net_library FROM smart.master.dbo.sysprocesses
WHERE hostname=SERVERPROPERTY('MachineName')
AND program_name='Microsoft SQL Server'

--
Razvan Socol

Re: is there a way to tell how a linked server is connecting?

jaylou
10/8/2007 5:59:06 AM

Thank you,
This is what I was looking for.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server connect group.