Thank you for your post!

So basically, it sounds like this process is manual meaning that I will have to look at each table to determine if I "think" it's...

Thank you very much for the follow up and advice. I wasn't sure if it could be done, but I didn't want to say "No" until I confirmed it.

I...

Thank You Kingston!! So, I'm assuming table1 is always the left table because it is the first in the list; is that correct?

Yes, you've helped out tremendously with that...

Thank You Kingston!! So, I'm assuming table1 is always the left table because it is the first in the list; is that correct?

Yes, you've helped out tremendously with that...

Wayne - Thank you for the query. It works great. I plan to research the "FOR XML PATH" statement just to see the use of it. One way for me...

Thanks Lowell for the query. It works great. I really appreciate your help!

Ronnie

Just wanted to say Thank You to everyone for your suggestions. I tried what Lynn had suggested and that seems to have done the trick. Sooo simple...

Anyway, thanks again!!!

Ronnie

Thank you very much. I ran the query and it worked perfectly. Of course I tweaked it a little (very little) but the logic work as expected.

I really appreciate your...

Thanks for the reply!

I would like to store the data in a table so that I can further manipulate it later. I was using the print to test and verify...

I thought I would include my code which might further help:

declare

@GroupName varchar(255),

@ServerName varchar(15),

@AccountName varchar(255),

@ServerID int, @rowsfound int

declare grpCursor cursor for

...

Sorry for the slow reply on this but I wanted to provide a status on this issue. I know that I from my own experience, I hate when I go...

Thanks Guys!!

This is what I ended up doing:

• Created a login account on the database side

• Granted the login the Public role

• Mapped it...

Was that all those step automated or manual. I used to do pretty much the same steps except for zipping. I had a SQL job to back up the database,...

So you are saying that I can backup the production database to my dev (target) server through SQL?

Do I have to create the mapped drive first in order to...

Thanks Andrew.

Unfortunately, I've tried those options and when it tries to start any subsequent components such as the model or msdb databases, it also looks for them in the old...