if Proc It...

Question: Is there any setting in database where I can set

default size of blank as 10...

panwar.jt (8/24/2009)

---

My complete analysis is

1-- This report is running in sql server 2000

2-- I restore a copy of databse to Sql Sever 2005

3-- Report stops due to different collation between...

Hi,

I suppect the ANSI_DEFAULTS

(ex. ansi_nulls and/or quoted_identifier)

Script the live SP and check how ansi_nulls and/or quoted_identifier are setted

Also check how ansi_nulls and/or quoted_identifier are setted in you quey...

Michael Valentine Jones (8/20/2009)

---

If that is one of the big name ERP systems, there is a good chance there are no FK relationships defined between the tables. Since they...

Phil Factor (6/20/2008)

---

[p] that inspires them to expect, and prepare for, the worst. ....., whereas the exceptional DBA scents trouble everywhere, and prepares for it. It is that...