SQL supports raw partitions - but who wants to hassle with them!

Andy

Not that I've seen. Tools are usually only as good as you are - until you master TSQL you're going to have questions. I wouldnt consider it bad to be...

Even if they had been revoked, restarting the service would not fix it. Easy enough to check anyway, right? I like Steve's idea about blocking - worth checking it out....

If the user is not a member of sysadmins, the job will run under the sql agent proxy account. If that account doesnt have sufficient permissions, the job will fail.

Andy

Maybe they have it skipping a 5 row header? I'd set the error logging on the package, see what happens. If you have VB available, save the package as VB,...

I'd check the permissions for whatever account is assigned to cmdexec. Have you tested the batch file as a stand alone?

Andy

Im just slow - have had the flu! I have not used Veritas. Perhaps Im simple minded, but I dont see any advantage to 3rd party backup. SQL native backup...

Hi Larry, thanks for the comments. You may want to post this in our regular forums that see more traffic. better chance of getting input from someone with cross platform...

Hey Mattias,

I found it interesting as well, though I guess I'm going to fall into the opposition camp on this one! To me, this has pitfalls similar to Hungarian naming...

Twice in a week, I agree with Steve. The important thing is to write good SQL - avoid cursors, denormalizing, long operations in triggers. I see entirely too much time...

Have done it several times in EM without a problem. No magic to it, just does what you'd do manually in TSQL. You'd have to have log backups for it...

The only way I've seen is to use the 'print' statement in the script - it will write out whatever you 'print' to the job history. Useful, sorta. If you...

Thanks! Please visit often, to ask or answer a question.

Andy

Thats the point of 6.5 compatibility mode, just about everything stays the same. If you've stuck to documented procs, I cant imagine it would take much time to test. We...

MSDB, or the transaction log for it? Doing a full backup should purge the transaction log.

Andy