Viewing 15 posts - 38,926 through 38,940 (of 39,456 total)
November 13, 2001 at 3:50 pm
I agree with the differences. I think that at some point, for at least some sections, there should be statutary regulations for computer professionals. Especially where life may be at...
November 13, 2001 at 1:57 pm
Agree with Andy. You would need to use filegorups (or add another file to the default group). Hopefully you are on RAID. If so, your raid controller may support...
November 13, 2001 at 1:50 pm
Sorry we couldn't help. Haven't seen this, but if you get in a bind, might be worth calling MS. It's $250, but how soon could you burn $250 of your...
November 13, 2001 at 10:26 am
You can search syscomments if you have rights using
select *
from syscomments
where text like '%sa= %'
Then kick the developers in the a**!
Steve Jones
November 13, 2001 at 10:25 am
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
Viewing 15 posts - 38,926 through 38,940 (of 39,456 total)