Hehe, I guess it all comes down to operator precedence (from first to last) :

+ (Positif), - (Négatif), ~ (NOT au niveau du bit)

* (Multiplication), / (Division), % (Modulo)

+...

Not exactly what he means.

I think he's refering to having a temp table (or dedicated table for this) where you can insert the ids that need to be processed. ...

We can't see that : src="C:\Documents and Settings\L8CKHO1\My Documents\My Pictures\exampleresults policy.jpg"

it must be http://www.blabla.com/policy.jpg

Thanx for the info... Had a little fun by starting a trace with pretty much everything except the security and locks audit .

Is it that hard to get developpers to stop doing that??? I didn't have problems to adapt to that change.

Maybe I'm wrong but : 2005-05-17 16:35:48.000 May 17 2005 4:35PM

Takes 2 minutes to fix (yeah right ).

Hehe, we should create a rant about this one and put it in the FAQ .

When you rename any object that has code associated to it, the only change made is its name in sysobjects. The script has to be updated as well manually.

make sure you declare your [var]char variable with its size : varchar(SizeGoesHere). The default is 1 and I suspect that this is your problem.

It may be parameter sniffing at work. However I think that the simplest workaround would be to do something like this :

IF EXISTS (Select * from dbo.ProducTMaster WHERE...

Are you sure that the service is still started?

Which Authentication mode are you using?

What user are you trying to connect under?

why not?? it's only 190k rows... and the heart of the site .

Just take yours and we'll trust what comes up... and agrees with common physics laws .

There must be a message somewhere... But I can't think were it could be.