Viewing 15 posts - 36,226 through 36,240 (of 39,771 total)
June 19, 2003 at 9:39 am
course you have to have the trace running. If you want to do this, set this up in a stored procedure, mark as a startup procedure, and then monitor and...
June 19, 2003 at 9:31 am
Or it could be coding errors or network problems. I've been running XP, as are some others here and while we don't constantly make ODBC connections, I use QA, which...
June 19, 2003 at 9:26 am
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
Viewing 15 posts - 36,226 through 36,240 (of 39,771 total)