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
I can't say I've ever seen that one before, but you could just do a loop
over the contents of INFORMATION_SCHEMA.TABLES and build/exec an ALTER
statement for each one.
http://technet.microsoft.com/en-us/library/ms190273.aspx
How many tables are there? If there are under 75, you might be just
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
Tim,
Make sure that the datatype of the column i set to int. In addition, down in
the column attributes area (assuming you are using enterprise manager) set
the identity attribute to yes and make sure that the Identity Seed and
Identity Increment attributes have a value.. usually 1 and 1 by
, 2004 12:31 PM
To: CF-Talk
Subject: RE: SQL server question
Tim,
Make sure that the datatype of the column i set to int. In addition,
down in
the column attributes area (assuming you are using enterprise manager)
set
the identity attribute to yes and make sure that the Identity Seed and
Identity
Tim, right click on the table and generate the sql script for it... then
post the script to the list.. I'll take another look.
Mike
_
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 15, 2004 12:43 PM
To: CF-Talk
Subject: RE: SQL server question
Michael... thanks
] TEXTIMAGE_ON [PRIMARY]
GO
-Original Message-
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 15, 2004 12:54 PM
To: CF-Talk
Subject: RE: SQL server question
Tim, right click on the table and generate the sql script for it... then
post the script to the list
[PRIMARY]
GO
-Original Message-
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 15, 2004 12:54 PM
To: CF-Talk
Subject: RE: SQL server question
Tim, right click on the table and generate the sql script for it... then
post the script to the list.. I'll take
No... not trying to insert anything there I'll check that column on
their server to make sure its identity
-Original Message-
From: Taco Fleur [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 15, 2004 3:27 PM
To: CF-Talk
Subject: RE: SQL server question
Did you send them a copy
THAT WAS IT !... they didn't have the identity value set... thanks much
-Original Message-
From: Taco Fleur [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 15, 2004 3:27 PM
To: CF-Talk
Subject: RE: SQL server question
Did you send them a copy of the db or a script? sometimes it just
I recently did something really dumb - I had a really small
SQL server database that I was using for a home project, and,
during an upgrade fiasco (long story), I deleted it by mistake.
Now... I see that the .MDF and .LDF files still exist in my
MSSQL7/data folder, and I would like to
Open Enterprise Manager and right click the Databases folder. Choose attach
database from the all tasks menu. A new window will open which will allow
you to select the MDF file and attach the database.
chris
_
From: Robyn Follen [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003
Ah, perfect. This worked!
Thanks
-Robyn
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003 8:42 PM
To: CF-Talk
Subject: RE: SQL server question
I recently did something really dumb - I had a really small
SQL server database that I
As a general rule...
use what is neccessary to store as little as possible. Storage space is
really not a factor with the low disk space, but you really don't want to be
upgrading your system all the time. That means not storing data multiple
times etc etc.
-Original Message-
From:
Subject: RE: SQL Server Question
As a general rule...
use what is neccessary to store as little as possible. Storage space is
really not a factor with the low disk space, but you really don't want to be
upgrading your system all the time. That means not storing data multiple
times etc etc
To: CF-Talk
Subject: RE: SQL Server Question
I am ok with that idea..what I don't know is exactly what datatype to
use,
or what they all mean..
I am in search of a resource that explains the data types a little.
Mike
-Original Message-
From: Won Lee [mailto:[EMAIL PROTECTED]]
Sent: Friday
impressed with all their products.
-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 14, 2001 12:36 PM
To: CF-Talk
Subject: RE: SQL Server Question
I am ok with that idea..what I don't know is exactly what datatype to use,
or what they all mean..
I
The two ways I know about to import Dbs are;
1- Access has an upsizing wizard, but I've never used it myself.
2- The Enterprise manager has an import Wizard that will walk you through
importing a new DB into SQL. Access is one of the import types.
As far as linking them It's no doubt possible
Whew, sounds like you stepped in a pile of SQL Server. Let me try and help
you out here.
Why would you want to access the old database after all of the data is in
SQL Server? All of the tables that were in the Access db will be in the SQL
db...
As for the second question, when you say link. Do
I am not very savvy on the 'mechanical' workings of SQL
Server but I need to remove it from my C drive and install
it on my D drive. I am used to Microsoft ACCESS where I
could simply 'cut and paste' the database to the D drive
and then re-add it into my CF Server. What do I need to
do and
26 matches
Mail list logo
