Viewing 15 posts - 38,941 through 38,955 (of 39,466 total)
It is a security problem. I believe the XP_trace procedures are limited to sysadmin role members. If you can get added, this should work.
If not, then you will have to...
November 13, 2001 at 10:23 am
Haven't read it, and I would agree that not everyone requires that level of expertise. But part of what the certification does is present to an employer some level of...
November 13, 2001 at 10:20 am
Can you provide more details? Your description only generally states the problem.
I.e. If you run a restore, what script do you use or what do you check in EM...
November 13, 2001 at 10:10 am
It should have created a text file on the c: drive of the server in the root called testjob.txt. It will not be on your local c: drive, so...
November 13, 2001 at 10:08 am
Can you setup and run this job:
BEGIN TRANSACTION
DECLARE @JobID BINARY(16)
DECLARE @ReturnCode INT...
November 13, 2001 at 9:29 am
AFPEterson,
Well written and a certification like the MCDBA is like a CPA, though I wish it were like a PE.
Should we require certifications? A CPA is really required...
November 13, 2001 at 8:25 am
Chris
thanks for the followup and I apologize. We kind of dropped the ball on this one.
Steve Jones
November 13, 2001 at 8:22 am
November 13, 2001 at 8:09 am
Not exactly. I do think certs should be required, but as far as their value to employres, they should be tiebreakers.
Steve Jones
November 12, 2001 at 2:33 pm
YOu can if you can execute sp_startjob, but this is limited to sysadmins (not sure if anyone else).
Steve Jones
November 12, 2001 at 2:30 pm
November 12, 2001 at 2:29 pm
Two things with $$
1. Employers don't upgrade that often, especially with database software. There is a cost involved with that. If and when they do upgrade, then paying for training...
November 12, 2001 at 1:46 pm
November 12, 2001 at 1:41 pm
That's my life. Mo' impo'tant than the jack is the satisfaction. Getting mellow with kids...
Steve Jones
November 12, 2001 at 1:23 pm
You are welcome. I assume you can enhance my script for the other columns.
POst again if you have more questions.
Steve Jones
November 12, 2001 at 1:22 pm
Viewing 15 posts - 38,941 through 38,955 (of 39,466 total)