You've incorrectly built your command.

Basically you want to execute this:

INSERT #Serverproperties

SELECT 'MachineName', SERVERPROPERTY('MachineName')

To do this on a linked server, look at this: http://www.sqlservercentral.com/Forums/Topic584711-145-1.aspx

LutzM (11/26/2010)

---

Steve Jones - SSC Editor (11/26/2010)

---

Celko is Celko. He has written a lot, and very well, on SQL and standards. However he's an anachronism, a throwback to the past...

This is likely a security/config error for the service account of SQL Server, or the proxy for xp_cmdshell.

First get an account that makes this work. Not your account, but create...

The IO errors are hardware or driver issues, in all likelihood, so follow Gail's advice and make sure someone does full diagnostics as re-using this hardware as is will likely...

Good advice above. As long as you move all non-db stuff (logins, linked servers, jobs, alerts, etc.), and the mirroring sets up, you ought to be fine.

Note that log shipping,...

How large are the files? You should be able to delete them, but I wouldn't expect large files from setup.

If the dependency tree in SQL Server is up to date it works, but it isn't guaranteed. I'd agree with Grant, there isn't an easy way to do this. What...

I agree with Jeff, scoping is an issue, but also, why the temporary table?

It's not clear how you are using service broker here. If you have an insert in db X on Server A, does this insert (direct or through trigger) put a...

Where are you unsubscribing? If you click the "Control Panel" link above, just below your account name, it should take you to a forum menu. Then scroll down and you...

If we get a code for 2011, it won't take effect until the early bird rates expire. Likely in Feb time frame.

Not sure what we'll do for a party next...

It would be good to have an SSIS and non/SSIS version

BTW, no idea what's happening in this thread, and not about to go through a few hundred posts over the last week. If there's something I should know, let me...

Celko is Celko. He has written a lot, and very well, on SQL and standards. However he's an anachronism, a throwback to the past when there were few online resources,...

Interesting thoughts, and thanks for the comments. I still think it's important to get an idea of range early on. Then you can factor that in to deciding how far...