Viewing 15 posts - 1 through 15 (of 146 total)
Idera has a free tool called SQL Permissions that does exactly what you're looking for.
We use it and it works great.
June 24, 2010 at 8:26 am
This works really well....
"Scheduling Backups for SQL Server 2005 Express"
May 17, 2010 at 8:40 am
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...
April 30, 2010 at 8:35 am
Be happy with your 46 days a year. Very typically, the standard vacation time in the USA is 15 days a year.
April 22, 2010 at 10:10 am
ARGGGHHHH ! I can't believe I read the question wrong. I missed the "NOT". Just got in a hurry reading. Slow down Tim......
April 15, 2010 at 8:14 am
I wasn't sure of the answers - I did not look them up. instead, I thought I'd just try each one;
Msg 15109, Level 16, State 1, Line 1
April 15, 2010 at 7:49 am
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'
March 31, 2010 at 10:17 am
I get 0 rows returned. tried it on several DB's.
March 23, 2010 at 9:31 am
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....
March 19, 2010 at 9:20 am
(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.
March 19, 2010 at 8:56 am
You have to reinstall using the command prompt methos with a parm of SKUUPGRADE=1
ie. setup.exe" INSTANCENAME=instancename SKUUPGRADE=1 /qn
If you use the SKUUPGRADE parameter, Setup will remove all hotfix and...
March 17, 2010 at 8:32 am
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....
February 24, 2010 at 9:30 am
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...
February 24, 2010 at 8:14 am
this script was just posted last week. Some very good detailed info...
February 18, 2010 at 7:43 am
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...
January 27, 2010 at 7:02 am