Problem after upgrading ms sql db

Forum|Forum|18 years ago
March 26, 2008
1 reply
444 views

I have a coldfusion 7mx website that is attached to a ms SQL 2000 DB and all works fine, I copied the DB to sql 2005 and now in order to use the same queries I have to add the schema name to the query (was) database.tablename or just tablename and (now) it needs to be database.schema.tablename. I really do not want to find update a few hundred queries what is the best way to fix this?
thanks
-d

Database access

This topic has been closed for replies.

O

Oğuz Demirkapı

Participating Frequently

I think you can solve your problem by changing your 2005 database compatibility level as backward compatible.

Here is a nice blog entry:

http://blog.sqlauthority.com/2007/05/29/sql-server-2005-change-database-compatible-level-backward-compatibility/

A

Anonymous

I tried that (db comp to 80) but to no avail.
still not working.

-d

-

-__cfSearching__-

Inspiring

dseoane wrote:
the query (was) database.tablename

I was not aware that syntax should ever work. If you omit the "owner" you must use two periods ".." to indicate that the current context should be used.
http://msdn2.microsoft.com/en-us/library/aa224051.aspx

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded