CF requiring owner name prefix to tablename during query

[AndyDC]

Hi,

We are beginner a transfer of all of out apps from CF5 to CF7 and I noticed
that, when the owner of a table is not DBO, then I have to prefix table names
with the owner name. For example...

Say we have a table called "SysAdmins", it is owned by the user "Andy".

This doesn't work, but worked in previous versions:
SELECT * FROM SysAdmins

But, this works:
SELECT * FROM Andy.SysAdmins

Is this a new function of CF7? Is there are setting to make CF not require
this prefix?

Thanks!

Andy

PS. We are running CF7 with MS SqlServer v8.

[zz3top]

We are running on CFMX v6.1 with SQLServer7 and have not experienced this
issue. Sounds like it may be an account configuration issue with your
SqlServer account access. Have you tried manually accessing SqlServer with
Enterprise Manager using the account in question?

[James168]

Hi Andy,
If you create public synonyms for those tables in the database, table owner prefix will not be required. This works in Oralce. I think MS SQL does the same.

James
[url]www.kidSale.com[/url]