Please do not cross post and be carefull of duplicating posts in general. See/leave resposnes in http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=108587

You are looking for IsNull which validates a column or variable to see if null, if not the use the value otherwise assign given value.

Price * IsNull(Qty ,1)

So were we a C programmer before?

Short and simple there is no dereferencing ability in T-SQL (at least not at this time and...

DId you verify that 1205 did occurr. I have seen deadlocks that were ended by other things than being vicitimized. Might also want to turn on trace flag 1204 to...

I have seen this before on a different type of server. The router route tables seemed to round robin the effect and some folks got thru others did not, the server...

Yu have to leave in no recover mode to be able to restore additional TL backups. To be able to use for reporting you have to use WITH RECOVER and...

TO be safer you could add save points to your code.

See "SAVE TRANSACTION" in SQL BOL

ANy ROLE that grants the create index permission will have it and ou cannot stop them unless you deny but that is as a whole not for a single object.

Yes I only found how to set for server and database however this might work.

DMOSQLServerObject.ExecuteImmediate "SET ARITHABORT ON"

Which in profiler did run and will stay in effect until my connection...

I have not seen this issue. Did you validate the results in QA and verify the query itself is doing as expected?

Works like 2000 and I know by default IsQuotedIdentOn is off.

Not knowing what your specific needs are for standards I suggest look at this thread for a common theme answer. http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=108092#bm108121

If not usefull can you be a bit more...

Are any of theobjects owned by anyone other than DBO? Have you found a solution and what is the entire message?

Storing in a text column and using the Full Text Search engine does quite well. However depending on the amount of data building the Full Text index can take awhile...

What is the ultimate goal here for your data? May be the wrong approach.