I'd recommend that changing the timeout is a patch, not a fix.  All you'd end up doing is allowing code that desparatly needs to be fixed to take its sweet...

Did the problem happen to start on the 13th of July?  Sounds like someone may have changed the default date format from dmy to mdy and your code isn't handling...

Everyone is forgetting about the "other" problem... the excessive row sizes that arise when doing the table ALTERs for the nocheck of constraints.  It means that one or more of...

You may want to try using DBCC FREEPROCCACHE.  If that doesn't do it and it's a GUI proc, you may have to clear cache for the application.  Since I don't...

Ram,

Dunno about the others, but I need to know why you want to simply throw away so many decimal places especially since the target datatype (Money) has 4 decimal places...

I agree... bad message to promote and, depending on what the server is doing, if you down it, you could cost someone their life (seriously... 911 control server, traffic light...

Like I said on the other forum, I think you have a bit of a technical error in the code.  I think this...

ImportFullPath = ImportPath & ImportFile

... should be this...

ImportFullPath...

This is what I call "RBAR" (pronounced "ree-bar" and is a "Modenism" for "Row by Agonizing Row") because you have variables on the right side of an update.  The only...

Thank you for the detailed explanation... I have just a couple more questions , if you don't mind...

Can you post the table of results for the "A" items?

In the formula 18(18)+18(18-15), do...

Very nicely stated and explained, Steve.

Thanks Wutang , but, nope... just a regular ol' SQL guy answering questions if I can.

Have you tried anything on your own?

Now, there's a lesson learned... Thanks, Serqiy.

No effect... maybe size of TempDB?  Mine is set to 1 gig...

Ok... replaced the CROSS JOIN with INNER JOIN like it was supposed to be...

DELETE AD1

FROM   DBO.AILMENTDETAIL AS AD1

       INNER JOIN DBO.AILMENTDETAIL AS AD2

ON  AD1.AILMENTID = AD2.AILMENTID

      ...