Agreed. Much safer than putting the WITH RECOVERY flag...

ElSuket (3/2/2009)

---

The difference you have between detach / attach and backup /restore is that for the first way, you will lose the cache, which is not the case when you...

There must be someone who has access to the server. The errorlog's just a text file. Without knowing why the DB's suspect, it's hard to offer a solution, and the...

Nope. Barry's solution equates to IIf([x]="YEN","JPY",IIf([x]="EURO","EUR",NULL)) , ie

If X = 'Yen' then 'JPY' ELSE If X...

Do you have up-to-date backups of this database?

Please look in the SQL error log on your production server and look for messages related to this database. There's a reason it's...

Restore Database < DB Name > WITH RECOVERY

Needs the else block as well

CASE x

When 'YEN' Then 'JPY'

When 'EURO' Then 'EUR'

...

Offhand I don't know. I know it's somewhere in the DB's...

It wasn't exactly subtle.

*snigger*

http://www.sqlservercentral.com/Forums/Topic666430-146-1.aspx

I'd like...

alstar (3/2/2009)

---

so my question is, QA did correct job when was comparing NULL = NULL, and didnt set BasketCost to 0, but SP did as it executed NULL = NULL...

That's nothing. Last system I worked on (which did use dynamic SQL to reduce procedure count) had over 3000.

Rather write the procedures. The downsides of dynamic SQL...

Without seeing the code, no.

How many?