I elaborate my question:

1. What would be impact of changing sql server 65 compatibility to 80?

2. All tables are having ansi NULL off, that will not change automatically, Do I have to create new tables and with ansi null on and export data?

3. Application is old and working good, what would be impact? do we have to change the application where "=NULL" with something like isnull() or is null?

4. We are having " in application, (quote identifier on " ) so do we have to change the application with ',

This is all i could think now....add on more if anyone feel so.

Appreciate any help.

Vinay