3) When I do a CFQuery, it won't work unless I write the table name as
canadianofficespacecom.city, instead of just city.
Is the database specified in the DSN?
Sounds as if one isn't specified.
Ricardo.
~|
Want to
I wrote:
A client asked me to see if I could get a copy of his old web site up
and
running. I did a restore of the backed up database onto my PC. The
problem is that all the table names have the name of the database
prepended
to them.
When I view the tables in SQL Server
I didn't see a mention of which version of SQL Server you're running,
but it sounds to me like canadianofficespacecom is either an object
owner or a schema:
http://www.sqlteam.com/article/understanding-the-difference-between-owners-and-schemas-in-sql-server
I'm assuming that it's most likely
but it sounds to me like canadianofficespacecom is either
an object
owner or a schema:
+1
That would make more sense than being part of the actual table name.
~|
Want to reach the ColdFusion community with
/library/aa275462%28SQL.80%29.aspx
~Brad
Original Message
Subject: re: SQL Server question re table names - still stuck
From: Larry Soo l...@bc4x4.com
Date: Fri, December 11, 2009 3:07 am
To: cf-talk cf-talk@houseoffusion.com
How many tables are there? If there are under 75, you
Recap of problem: I imported an old, backed up SQL Server file. Now, when
I view the tables or try to access them in CF, it requires me to prefix all
table names with canadianofficespacecom..
Ezra Parker wrote:
I didn't see a mention of which version of SQL Server you're running,
but it
On Fri, Dec 11, 2009 at 2:53 PM, Larry Soo l...@bc4x4.com wrote:
So would I be correct in assuming that
the problem I'm having is that the default schema for dbo is master
instead of canadianofficespacecom?
I believe so, yes. In order to resolve this from the user side of
things you're going
7 matches
Mail list logo