Viewing 15 posts - 36,361 through 36,375 (of 39,903 total)
There might be a script in the library here, if not it's easy to write. Setup a stored proc to scan sysprocesses and check the last batch against the current...
June 19, 2003 at 9:24 am
Are the master and targets at the same SP/patch level? Check @@Version.
If you can't delte them from EM, use QA and whack them from msdb..sysjobs and msdb..sysjobsteps.
Steve Jones
June 19, 2003 at 9:10 am
check what the service is trying to start. Double click it and look for the command line. Verify that the sqlservr.exe application is actually there.
It sounds like someone moved things...
June 19, 2003 at 9:06 am
Redesign is in the works, but it's time consuming, plus we've added so many little features around Snitz that a bunch of stuff is breaking when we move.
Actually poor...
June 19, 2003 at 8:57 am
Salary is a funny component. Everyone wants to know, no one (usually) wants to say what they make. Not that I care too much about people knowing my salary, but...
June 18, 2003 at 11:20 am
That will work. You also do not need to use the encrypted string. If the SQL Agent account has rights, you could just schedule the job with DTSRun (see BOL...
June 18, 2003 at 11:11 am
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
Viewing 15 posts - 36,361 through 36,375 (of 39,903 total)