John, Ivanna,

Thanks to both of you for getting back to me.

Ivanna, I tried what you suggested and could not see the user 'bennetp' listed as a 'dbo' for any database....

Hi there, good afternoon and thanks for your response.... Thing is I ran it as yoou suggested on each db and got no results for the 'bennetp' user.

I am at...

There were no records for two of the users but 'hussaia' has the following:

Using Server -> Properties -> Permissions I un selected his rights and...

Hi there and good morning to you too.

Thanks for your reply. Yes thos 5 were the entire result set. I have removed principal_id records 428 and 430 (test accounts which...

Its ok, I do find that when you have been chasing your tail, its always good to go back to the basics 'is it turned on? etc'. Unfortunately, yes, I...

Hi there and thanks for replying.

I have already gone through that step. I ran the same script which I found on an MSDN thread and got a result. I then...

Thanks for your help. Think I'm just gonna convince the higher ups to let me try a tool!

Have a great weekend.

Thanks for yoru help.

I have restored the db to'SA-restored' on my local SQL server. This was restored from a backup yesterday (after the deletions occurred). I then restored the trans...

Can you suggest how I can restore the two backups (db and trans) without having them redo or undo or truncate?

Hey guys thanks for your replies.

Ok, so next problem, when I run the 'dbcc log ("SA-restored", type=3)' command i only get the recent transactions (since it was restored).

So what...

Ok, I understand now. This sort of query doesn’t seem to work because you have to do 'Select.... Openquery(....)'. That’s not working cause there is nothing to output from the...

Sorry, you've lost me. 'Dynamic SQL'?

Hey Grasshopper,

Thanks for your reply. I actually started off with 'SELECT * FROM OPENQUERY(......)' but found that it didn’t really work.

It works fine to query a table or as...

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...