Viewing 15 posts - 8,386 through 8,400 (of 9,715 total)
lee.pollack (3/19/2009)
please remember that my company is still using sql2000 - so WHILE does not exist for me
Lee,
You can also nest IF...ELSE statements and CASE statements. It could be...
March 19, 2009 at 8:48 am
JacekO (3/19/2009)
March 19, 2009 at 8:43 am
Lee,
Before I go any further, Label 1 confuses me.
label1:
-- 1st check - do we have a customer record in CP
IF EXISTS (Select * From DATABASE.OWNER.TABLE 6 WHERE cust_id = @memvar...
March 19, 2009 at 8:18 am
JacekO (3/19/2009)
March 19, 2009 at 8:14 am
Ah. I forgot local help could be disabled.
But shouldn't he still be getting something from the online stuff, assuming he has a network connection?
March 19, 2009 at 7:24 am
Wow. That's a new one.
You say it was working before?
Has anything changed since then? Any programs removed from your box? Anything added (service packs,etc.)?
Check Windows Explorer and see if you...
March 19, 2009 at 7:18 am
Nesting is a broad term. You can nest triggers, stored procedures, transactions, IF..Else statements and loops.
Basically, a "nest" is when you embed one thing inside of another and the internal...
March 19, 2009 at 7:14 am
I should also clarify that I don't advocate nested stored procedures (which is different from nested transactions).
I've never had any reason to use them, though, and I know of at...
March 19, 2009 at 6:07 am
Lee,
I think you misunderstood me. Nested transactions can be wonderful things, if you need them. If you don't, I don't advise indulging because it's a lot of wasted effort.
What I'm...
March 19, 2009 at 5:58 am
At this point, you need to contact the help desk of your third party mail server and maybe even engage Microsoft in the problem. It sounds like an issue on...
March 19, 2009 at 5:13 am
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
Viewing 15 posts - 8,386 through 8,400 (of 9,715 total)