Idera has a free tool called SQL Permissions that does exactly what you're looking for.

We use it and it works great.

This works really well....

"Scheduling Backups for SQL Server 2005 Express"

http://www.mssqltips.com/tip.asp?tip=1174

Jeff,

I had the exact same problem with Websense. I couldn't believe that's how they set up their product. I pushed hard on the Security Admin not to...

Be happy with your 46 days a year. Very typically, the standard vacation time in the USA is 15 days a year.

ARGGGHHHH ! I can't believe I read the question wrong. I missed the "NOT". Just got in a hurry reading. Slow down Tim......

I wasn't sure of the answers - I did not look them up. instead, I thought I'd just try each one;

sp_changedbowner 'tim'

Msg 15109, Level 16, State 1, Line 1

Cannot...

This thread got me thinking...why couldn't you use the sp_msforeachdb procedure to set all user DB's in single_user??

So, I tried it;

exec sp_msforeachdb 'alter database ? set single_user with rollback immediate'

it...

I get 0 rows returned. tried it on several DB's.

I've used Apex SQL Log and Apex SQL Recover and it works perfect for just such a situation as this. I read Lumigent is a good product as well....

Short Teram:

(Assuming you can logon to the server). Stop the SQL Server service and take a cold backup of the .mdf and .ldf files. Restart the service.

Download a...

You have to reinstall using the command prompt methos with a parm of SKUUPGRADE=1

ie. setup.exe" INSTANCENAME=instancename SKUUPGRADE=1 /qn

Note:

If you use the SKUUPGRADE parameter, Setup will remove all hotfix and...

I just tried to test out the Apex solution and it did not work.

I tried several scenarios using detach, offline, moving the .mdf, etc....

Sorry !

I'd like to chime in here on the original question of the lost .MDF file....

HOW the data file was lost could make a difference.

APEX SQL Recover will go out and...

this script was just posted last week. Some very good detailed info...

http://www.sqlservercentral.com/scripts/SQL+Server+7%2c+2000/61297/

sorry, maybe I'm missing something, but I get an error using the 2005 script:

Msg 102, Level 15, State 1, Line 84

Incorrect syntax near '?'.

I can't see what line the error...