Viewing 15 posts - 36,181 through 36,195 (of 39,717 total)
If you are really cracking down, then they should not be able to schedule jobs or alter packages. You are introducing places where change is not managed. Someone should approve...
June 18, 2003 at 11:10 am
Might be able to with Log Explorer if you have the logs (www.lumigent.com)
Steve Jones
June 18, 2003 at 11:07 am
None I'm aware of. Since everyone's standards will deviate, this is probably something that would be custom, though a framework would be nice.
You can check at http://www.ssw.com.au/ssw/default.aspx, I know...
June 18, 2003 at 11:05 am
Check the Windows Event Log as well for any events in that time frame.
Steve Jones
June 18, 2003 at 10:59 am
We tend to work with IE mostly because we all use it, it's the largest audience, not likely to have too many non-Windows users.
That being said, I use Mozilla (1.3)...
June 18, 2003 at 10:58 am
Chris has good advice. You can also take some of your long running queries from Profiler and check them in Quary Analyzer. See if there are any physical reads. If...
June 17, 2003 at 11:18 am
I didn't have any trace flags, though I probably should have. I did run a checkdb and it didn't show errors.
So far it hasn't appeared again and I hope...
June 17, 2003 at 11:12 am
Haven't used them, but they are around the corner from me and hiring SQL DBAs.
Steve Jones
June 17, 2003 at 11:07 am
the sa/god problem is one that most people are concerned about, but a sysadmin has to be trusted with access. Of course, you should also be fired/sued if you abuse...
June 13, 2003 at 10:48 am
Might be. Perhaps there is some temporary file there. Can you move the location for backup files and then restart?
Steve Jones
June 13, 2003 at 10:44 am
IANAL - I am not a lawyer.
I searched out our security people and they said that the info sec policy that we agree to says that you do not have...
June 13, 2003 at 10:15 am
great advice above. One more I'd add - SQL Litespeed. Works great and has reduced our largest backup substantially in size and time. Went from 60G native to 9GB...
June 13, 2003 at 10:12 am
I'd use a view as well. Use separate dbs if they need to maniuplate the data separate from other users.
Steve Jones
June 13, 2003 at 10:08 am
Sorry haven't read it. Can you post your thoughts or write a review? We'd love to have it on the site. Send a review in email to me (sjones@sqlservercentral.com) if...
June 13, 2003 at 10:05 am
Remove guest from msdb and do not give him access to this database.
Steve Jones
June 13, 2003 at 10:00 am
Viewing 15 posts - 36,181 through 36,195 (of 39,717 total)