Hi everyone,
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 sould simply 'cut and paste' the database to the D
drive and then re-add it into my CF Server. What do I need
I'm getting this error from a form submission (autoid is an integer
column that is set to be the "identity" column)... having only used
access in the past, I'm not sure how to resolve this. I would think the
autoid column would automatically increment because it is set to
"identity" . do you have t
Ok have a question about SQL Server 7.0 You can licence
per seat/ per server. Basically any hits to our sql server
will come THROUGH cold fusion. What is the best way
to set up lisenceing for this? Meaning if I do per seat
and then lisence the Cold Fusion server can it then hit the
SQL server wi
Hi everyone,
Can someone point me in a direction to a good resource on chosing the
correct data types in SQL 2K.
I am new to building DBs and could use some help fiiguring out which data
type i need and why I need as apposed to others.
Thanks
Mike
Take ti
I'm not sure if this is the right list to post for this question, but here it
goes.
We have a database that we're converting from Access to SQL server 7, and
since I'm new to this there are 2 issues as of now.
1. Can you set up a link (or alias I guess) that would link the old table
name fro
> 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
. usually 1 and 1 by default.
HTH,
Mike
_
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 15, 2004 11:23 AM
To: CF-Talk
Subject: SQL server question
I'm getting this error from a form submission (autoid is an integer
column that is set to be the "id
ry 15, 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"
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... t
NULL
) ON [PRIMARY] 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 th
://www.tacofleur.com/index/methodology/
Tell me and I will forget
Show me and I will remember
Teach me and I will learn
-Original Message-
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Sent: Monday, 16 February 2004 4:15 AM
To: CF-Talk
Subject: RE: SQL server question
if exists (select * from
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 co
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
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 14, 2001 12:18 PM
To: CF-Talk
Subject: SQL Server Question
Hi everyone,
Can someone point me in a direction to a good resource on chosing the
correct data types in SQL 2K.
I am new to building DBs and could use some
-Talk
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
tim
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 am in search of a resource that explains the data types a little.
Mike
-Original Message-
From: Won Lee [mailto:[EMAIL PROTECTED]]
Se
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 mea
MAIL PROTECTED]]
Sent: Thursday, February 22, 2001 6:32 AM
To: CF-Talk
Subject: SQL server question
I'm not sure if this is the right list to post for this question, but here
it
goes.
We have a database that we're converting from Access to SQL server 7, and
since I'm new to this there
rsday, February 22, 2001 9:32 AM
Subject: SQL server question
> I'm not sure if this is the right list to post for this question, but here
it
> goes.
>
> We have a database that we're converting from Access to SQL server 7, and
> since I'm new to this there are 2 iss
We've received the following error after installing SQL server 2000 personal
edition.
[MS Design Tools] Class not registered
Any ideas?
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkin
Hey all,
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 re
> 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
, 2003 5:27 PM
To: CF-Talk
Subject: OT: SQL server question
Hey all,
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
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 want to add a user via TSQL. I have looked all over and in the books
online. I think I am missing it. If anyone know I would appreciate it!
Thanks,
Neil
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.f
I will be out of the office today, Monday, February 26. I will return Tuesday,
February 27.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/
> We've received the following error after installing SQL
> server 2000 personal edition.
>
> [MS Design Tools] Class not registered
>
> Any ideas?
Typically, when I've had this sort of error in the past, the fix was to
reinstall the latest version of MDAC, available from
http://www.microsoft.
Look into sp_addlogin and sp_adduser.
Bob
-Original Message-
From: Neil H. [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 26, 2001 3:46 PM
To: CF-Talk
Subject: OT MS SQL Server Question...
I want to add a user via TSQL. I have looked all over and in the books
online. I think I am
28 matches
Mail list logo