When is it and where do you live?... Days out are nice and aggree that wife'y needs some attension too! She probably works harder at it then you do so...

Also you can try connecting from SMS with the service account that is being used by RS to connect to its database.... Is your RS standalone with remote db or...

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