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
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 Manager, the table, city, is
as
fast renaming them them by hand.
~Brad
Original Message
Subject: SQL Server question re table names
From: Larry Soo l...@bc4x4.com
Date: Tue, December 08, 2009 1:45 pm
To: cf-talk cf-talk@houseoffusion.com
A client asked me to see if I could get a copy of his old web site up
I have only seen that with exports from MS Access.
Yes, +1 about using the information INFORMATION_SCHEMA views. Tapping into the
system views is my favorite way to generate mass statements on-the-fly ;-)
DECLARE @DBPrefix VARCHAR(50)
SET @DBPrefix = 'oldabc.'
SELECT 'exec sp_rename
10 matches
Mail list logo