In my case I am not worried about SQL login accounts as in my company only service accounts are created with SQL accounts all the rest are AD accounts (easier...

Hey All, Me again,

While talking to Manu I realised that the version of my script up here is ooooooooooooooooold!

Heres the new version which registers itself as an sp and does...

Hi there Manu,

The script I wrote actually runs from the DR server and pulls data from the Live via a linked server. I went through several different logic versions but...

Hey everyone,

OK nobody replied to the question so I have written the script myself.

Basically I used two cursors, one to create a list of logins which are on the live...

I think you will probably find that because you have not specified a mem amount to be locked by AWE that is why it have locked 256MB (minimum requirement).

I...