Thanks for the update, I will include your changes to the code an update it.

This is a very handy script, Thank you very much for it. I updated the script to handle tables in different schema's. I was using this today and found...

Your Welcome, I am glad. 😀

Create procedure usp_lsping(@nf nchar = 'N', @wtn nchar = 'E')

WITH ENCRYPTION

as

-- ===========================================================================

-- Author:Mark Huber

-- Version:1.0

-- Create date: Oct 19, 2011

-- Description:Description to ping the linked server and see if...

I found that the code I submitted had some extra characthers attached to most of the lines. I have submitted an update and when it is published this issue will...

Sorry about that. Can you tell me a bit about what your seeing. A screen shot or the error messages your seeing and I can see what your seeing. I...