First you need to research this a bit yourself. What information are you looking for? There is lots of stuff about replication.

Second, most of this is documented in Books Online,...

Yep, that's how I do it for the site. VPN in, run SSMS locally on my desktop, connect to the server.

You just install the client tools from setup, but for...

Glad to help, happy you found it. I've been stymied by these before, and usually only catch them after digging through lots of data.

In that case, what I'd do is set up a script that

a) creates a table after recovery in some database, could be tempdb if needed

b) populates this with code, each...

I'd agree with Brian here that you ought to examine if you really need to do this.

If you go my route, I'd be sure that you don't allow the code...

Did you check both tables? Are you sure there aren't any other characters in there?

Do a select where you check the join fields as well, CAST the field as a...

The tools are part of the 2008 media. I'm not sure they are distributed separately.

You need admin rights for some things. no way around it.

What you could do, however, is put the commands in a stored proc, or even a table somewhere. Allow your...

Not yet! I'd forgotten as well.

I'm sure I'll get a complaint about something soon.:w00t:

The error is a conversion error, not a variable (syntax) error. somewhere in your data, you have a varchar that is being implicitly converted to a float, but it's not...

I tend to agree with Jason. I glance at the post count, and if it's < 10, I tend to cut more slack. However I do just hint, link, or...

Thanks for the test.

No poll. I retain the right to veto all pictures I don't want up there 😉

It's possible that permissions are not granted on that table from those roles. It's a system table, so I'd expect that db_datareader wouldn't, but I wouldn't think db_owner would not....

Is it to any server? Any query?

If so, you likely have a corrupt install. I'd uninstall/reinstall it.