Thanks John

So when copying over the database does that actually bring the permissions of the users over as well? and then after that login is created I need to then...

Hi Jeffrey

Thanks for that, I used sp_help_revlogin and it worked well.

• It gave me a list of the entire logins on the sql instance.
•  I then copied out the 5...

Ok great thanks for the info, I am transferring to different windows domains so I'm not its going to work as I need to use different accounts on different domains.

Ok thanks Andreas, that involves powershell to copy the database and jobs and users I take it?

What would be the command ?

Thanks Jeffrey

Ok thanks

I am a bit rusty with this stuff so just to confirm is the correct process as follows:

• run sp_help_revlogin on the master DB and that will create a...

CHECKPOINT;

GO

DBCC DROPCLEANBUFFERS;

GO

Is that something that can be done on a production system?

My understanding was it could be a bit risky ?

Yes agreed, it is most likely a futile exercise but still a requirement from the vendor, so the question is how to do it not why.

Yeah it is being purposely put into single user mode as part of a nightly refresh, the backup happens directly after the single user mode has been set and it...

So as part of some data load ...the DB in question is put into single user mode. I presume this is to ensure no more data is added to the...

Yeah good question. It must be part of some job than runs which I do not have visibility of yet.  In the error log I see the database put into...

Hi Sue

There are 100's of servers and the request is for one email containing all failed jobs.

It seems powershell is the only way to achieve...

@Sreekanth B & Michael L John Thanks for the responses.

I...

Thanks @lowell......its seems its not so straight forward, I was hoping for something easier alright.

Thanks Vegard