Here is the functioning re-worked openquery.

If anyone is wondering why openquery is used instead of 4-part naming, it's because half of our servers use NTLM authentication instead of Kerberos.

...

Makes sense about OPENQUERY not supporting multiple results. Thanks.

Looks like sp_MSforeach_worker and #qtem come form the code in the prcedure sp_msforeachdb...

Good tip. thanks rich.

Wouldn't you have to use OPENQUERY if the servers use NTLM authorization?

Thanks! Had to think about this for a bit but I tracked it down to a special login we use just for NTLM servers. Changed the permissions and...

Success! Gentlemen, thanks so much for your assitance. Your responses have been extremely helpful and insightful.

John

thanks for the reply. Adding the single quotes allowed the 'parse' check to be successful but when the code was executed, a syntax error occured.

--

Msg 102, Level...

IT WORKS! THANK YOU VERY MUCH!

Here is my code. When this code is executed it inserts '@ServerName,@Port_nbr'into the sys.servers table. Currently all the servers are Kerberos so I dont need a login...

very helpful, this was a little more of what I was looking for 🙂

thx, this was helpful

Thanks!

I think its working coded like this:

If (@CreateDate > GETDATE() - 7 )

EXEC sp_executesql @sql, N'@servername varchar(250) , @Port_nbr...

Thanks much for the assistance.

Below is my modified code. When executed it appears to run successfully. All the records are read from the HOSTSERVER table but the server properties...

My code is working. Thanks very much. Quotation marks will be the death of me...

-jon