Ok thank you for your inputs. We are planning on installing/testing on development system first. Just wanted to know if there are any major changes/differences in the overall database/server level...

Thank you so much!!!!

Has anyone done something like this? please share.. thanks in advance

In order to make all the check and FK constraints trusted, is there a script/procedure that will re-create/make all the constraints trusted? I found this SQL which generates the script...

Thank you so much for all your inputs... We are looking into other reasons that is causing the slowness..

Also would like to mention that I'm reading on user experiences that they have faced performance issues with as less than 100 pages and fragmentation over 70%. So I'm wondering...

Thank you everyone. We are going forward to make all the constraints trusted then run the tests to see if it improves performance.

Thanks again for all your inputs.

Has anyone come across this problem? Please help.. thank you so much

Yes.. it was some network related problem. After reboot of the server, it worked

Thanks a lot everyone. It was indeed permissions issue, we got it fixed,

We tried that SQL.. same error from the application.. We are planning on running a trace on ODBC tomorrow I will post that hopefully that will give us some clue..Thanks...

Ok..Here is the background.. This SQL runs from our application connected to SQL Server via ODBC. TABLE1 in the SQL is an oracle table, queried via linked server. We are...

Hi Sean

It is an error from our application.. not sure if will help

“An attempt was made to call a stored procedure that expects a boolean value.”

Thanks

Thanks Luis.. We will try it out..

Sean, the query works from SQL Server but not from the application. So we are trying to try alternate SQLs..

Thanks

THank you for the replies. May be I misinterpreted about the conversion... We are converting Oracle database from ANSI to Unicode. SQL Server 2005 database remains the same, so...