Viewing 15 posts - 8,401 through 8,415 (of 9,720 total)
I know you said things are working fine, but curiousity just struck.
Did you create the MP while your SQL Server was at SP1 patch level, then create the new job...
March 19, 2009 at 4:47 am
Another way, if that doesn't find everything, is to use NOT IN. However, you should be aware that NOT IN uses more processing power than an IN statement.
So:
Select * from...
March 19, 2009 at 4:45 am
Lynn Pettis (3/11/2009)
Nice it would be if feedback OP would provide.
Hee! True. @=)
Everytime I run into this issue, it's because I'm either using an = sign with a date...
March 19, 2009 at 4:40 am
Finally catching up to this thread, now that I have a break from major projectness. Sorry, Lee, that I wasn't able to re-respond earlier.
As far as JacekO's (I think it...
March 19, 2009 at 4:37 am
Anurag Tripathi (3/10/2009)
Hi,The above job is not for taking a Database backup. Infact, I have made one Maint plan which is having two steps:
Ah. In that case, you shouldn't have...
March 11, 2009 at 5:06 am
Gags,
Please elaborate. What do you mean "fixed it the same way"?
What precisely did you do to fix the index=0 issue to allow the datafile to grow, please?
March 10, 2009 at 11:58 am
Okay. This is different from what I thought you were doing.
Check the plan history. Any errors or informational messages regarding the email part?
March 10, 2009 at 8:49 am
Lee,
I just caught up to the fact that you're using SQL 2000. You need to repost this in that forum. However, you can still use Temp Tables (look them up...
March 10, 2009 at 7:50 am
lee.pollack (3/10/2009)
Everything is already in one stored procedures.
Lee, according to your pseudo-code in the OP, you're calling at least 4 different stored procedures. That's not really containing everything in...
March 10, 2009 at 7:34 am
ACK! let me rephrase.
I'm suggesting you use the DDL trigger to update the staging table. Then use a normal T-SQL SELECT within a job to get the staged data and...
March 10, 2009 at 7:25 am
What Jack said. I'm not suggesting a Trigger at all. In fact, I strongly urge you not to use a trigger. Triggers play merry heck with the database processing power.
A...
March 10, 2009 at 7:24 am
Slam? I didn't mean to slam. Sorry if you took offense at my reply.
Roy is correct about the procs, though. What you've got will work, but it'll be heck on...
March 10, 2009 at 7:21 am
Lee,
I think they do, but don't take our word for it. Stick in a dummy proc in your GOTO that creates some fake data, then stick another dummy proc in...
March 10, 2009 at 7:15 am
Okay. DB Maintenance plans are created as SSIS packages, so that explains the error format.
More questions & some suggestions.
Do you have any third party software installed for backing up your...
March 10, 2009 at 7:13 am
Kevin,
Can you give us the details of the job step that sends out the mail and is supposed to include the attachment? Things like Step Type, the database it's running...
March 10, 2009 at 7:05 am
Viewing 15 posts - 8,401 through 8,415 (of 9,720 total)