Lowell,

Thanks a bunch. The Split function is exactly what I was looking for. Works great!

Thank all of you for your replies. I ended up going the dynamic SQL route. The query was originally well over 8000 characters but was a UNION query. I busted...

I know the dynamic SQL will work. But I haven't been able to get it to work without building the SQL string. I was hoping to avoid the dynamic SQL....

Yea, we're going to remove the old server from the network when we plug in the new.

Thanks very much for the responses.

We are retiring the current server. The plan is to have the new server with the same name and IP address. Also, multiple servers are...

Thanks for your response.

I ran the script and the server does show up. However, one thing I failed to mention is that the server with multiple sa records is the...

No error. Everything appears to execute normally. However, when I re-enter the Manage Permissions interface, the permissions I assigned to the added columns are not there. In several tests, I...