Viewing 15 posts - 39,196 through 39,210 (of 39,717 total)
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
Can you create any package and have it run scheduled? (Still reaching here).
Steve Jones
November 12, 2001 at 1:20 pm
Thanks Wes, we have a similar one at SSC, but we don't include the `. Does that one cause problems?
Steve Jones
November 12, 2001 at 1:19 pm
Who'd want to use the FileSystemObject with ftp?
Put your energies into the areas that interest you and can further your career.
Steve Jones
November 12, 2001 at 11:38 am
Let me try to understand. It's easier to have you post the DDL to create the table and some sample data.
I think you have this (sample post):
-- drop table MyTest
create...
November 12, 2001 at 11:03 am
Viewing 15 posts - 39,196 through 39,210 (of 39,717 total)