Is my linked server up?

Question

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 1

I don't think there is a way to test it, but you could of course issue a really simple query just to see if you get a respone. Something like:

SELECT 1 AS TestCol

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

neiljacobson SSCommitted Points: 1717 More actions · Answer 2

Try the utility ODBCPING.EXE on your SQL Server install CD. Use it with xp_cmdshell like this:

exec master.dbo.xp_cmdshell 'odbcping /DodbcDSN /Uremoteuseracct /Pwhatever'

Cookies on SQLServerCentral