On Monday 11 Aug 2008, Scott Stewart wrote:
the main weirdness that I've found is that cfqueryparam is returning
true or false which is a valid response for a boolean
but not what a SQL server bit field is expecting. (IE: 1 or 0)
And what value are you passing into the cfqp there ?
Sounds like
: Scott Stewart [mailto:[EMAIL PROTECTED]
Sent: 11 August 2008 19:14
To: CF-Talk
Subject: cfqueryparam and bit field (was:Re: CF 8 Built in SQL Server
drivers vs. MS SQL Server 2000 SP3 Driver)
The cfqueryparam tags work fine with the character fields, but they're
returning true or false
Hey all,
I've run into an issue that I need opinions on. We've run into some SQL
server issues, where MS is saying patch the driver.
Has anyone used the MS SQL Server 2000 SP3 JDBC driver in place of the
one shipped with CF8?
Has it cleared up 8180 errors?
Any performance gains/losses?
Any
On Monday 11 Aug 2008, Scott Stewart wrote:
I've run into an issue that I need opinions on. We've run into some SQL
server issues, where MS is saying patch the driver.
And what has Adobe said ?
--
Tom Chiverton
This email is sent for and
2008 15:10
To: CF-Talk
Subject: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3 Driver
Hey all,
I've run into an issue that I need opinions on. We've run into some SQL
server issues, where MS is saying patch the driver.
Has anyone used the MS SQL Server 2000 SP3 JDBC driver in place
Nothing,
I've found a couple of CF blogs that point to cfqueryparam as being
the culprit...
But it's in very specific cases:
http://www.petefreitag.com/item/677.cfm
However, mine is a basic insert statement.
the error code(s) returned are:
[Macromedia][SQLServer JDBC Driver][SQLServer]Line
don't cause any issues with CF's built in drivers though so
why not give it a try on your dev box?
Craig.
-Original Message-
From: Scott Stewart [mailto:[EMAIL PROTECTED]
Sent: 11 August 2008 15:10
To: CF-Talk
Subject: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3
as it might have
saved some time.
Craig.
-Original Message-
From: Scott Stewart [mailto:[EMAIL PROTECTED]
Sent: 11 August 2008 17:14
To: CF-Talk
Subject: Re: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3
Driver
Thanks Craig
The higher ups have deemed this a last resort
8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3
Driver
Hey all,
I've run into an issue that I need opinions on. We've run into some SQL
server issues, where MS is saying patch the driver.
Has anyone used the MS SQL Server 2000 SP3 JDBC driver in place of the
one shipped
have
saved some time.
Craig.
-Original Message-
From: Scott Stewart [mailto:[EMAIL PROTECTED]
Sent: 11 August 2008 17:14
To: CF-Talk
Subject: Re: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3
Driver
Thanks Craig
The higher ups have deemed this a last resort
got it handy? it would save me ~15/20 minutes. tks.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
I'm reading that there are many different ways to import data into a SQL Server
database.
I want to set up something that will allow a partner outside our company to be
able to upload
contest entries along with image files and have it all imported into a SQL
Server table.
Any one have adive
Just found this. Maybe would do the trick?
http://www.perfectxml.com/articles/xml/importxmlsql.asp
Will
~|
ColdFusion MX7 and Flex 2
Build sales marketing dashboard RIAâs for your business. Upgrade now
Just found this. Maybe would do the trick?
http://www.perfectxml.com/articles/xml/importxmlsql.asp
Will
I don't have Microsoft Visual Basic or Visual Studio .NET. Don't know Visual
Basic or VBScript. Can I do it with ColdFusion or some wizard in SQL Server?
I've got some elaborate joins I'm performing against tables with which I'm
not all that familiar. Access has a built in function called Relationships
which allows you to visualize tables and their columns. Does SQL Server have
something like this?
Alternately, is there a quick way of dumping a
: Thursday, February 22, 2007 11:36 AM
To: CF-Talk
Subject: A few questions about SQL Server 2000
I've got some elaborate joins I'm performing against tables with which
I'm not all that familiar. Access has a built in function called
Relationships which allows you to visualize tables and their columns.
Does
I've got some elaborate joins I'm performing against tables
with which I'm not all that familiar. Access has a built in
function called Relationships which allows you to visualize
tables and their columns. Does SQL Server have something like
this?
Yes, look for Diagrams. You will have to
Yay...
I found that SQL Server does have database diagrams. That's what I'm looking
for.
-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 22, 2007 10:57 AM
To: CF-Talk
Subject: RE: A few questions about SQL Server 2000
Andy, while I am no DB expert
Ben Nadel wrote:
Create a new file Project using existing database
An Access project is probably a good way to go since you are comfortable
with Access, but it does not use the Access Relationships function
that was described. It has something similar in the Database Diagrams
button that
Right now our production environment is on a Windows server with SQL
Server 2000 for most of the data storage. I've started using a Mac
for local development again and am getting CFMX installed on it to
make life easier on me, but I've got a problem with the database
element - what OSX
SQL Server on a V-PC instance. Won't be crazy fast or particularly
friendly on your RAM, but it'll get you SQL Server.
cheers,
barneyb
On 6/30/06, Damien McKenna [EMAIL PROTECTED] wrote:
Right now our production environment is on a Windows server with SQL
Server 2000 for most of the data
On Jun 30, 2006, at 2:51 PM, Barney Boisvert wrote:
SQL Server on a V-PC instance. Won't be crazy fast or particularly
friendly on your RAM, but it'll get you SQL Server.
DUH! smacks forehead I can just use JDBC drivers and hit the SQL
Server down the hall. Duh!
--
Damien McKenna - Web
On one of my development boxes, I am running CF 7 (on windows XP) I
installed SQL Server 2005 with no issues. I then realized that for one
client, I will need to have SQL Server 2000. I installed 2000 as a separate
instance.
I am unable to connect to the new instance with CF (I was able
On one of my development boxes, I am running CF 7 (on windows
XP) I installed SQL Server 2005 with no issues. I then
realized that for one client, I will need to have SQL Server
2000. I installed 2000 as a separate instance.
I am unable to connect to the new instance with CF (I
boxes, I am running CF 7 (on windows
XP) I installed SQL Server 2005 with no issues. I then
realized that for one client, I will need to have SQL Server
2000. I installed 2000 as a separate instance.
I am unable to connect to the new instance with CF (I was
able to create a Windows DSN
, April 27, 2006 2:58 PM
To: CF-Talk
Subject: RE: Running CF7 SQL Server 2000 and SQL Server 2005 on same machi
ne.
On one of my development boxes, I am running CF 7 (on windows
XP) I installed SQL Server 2005 with no issues. I then
realized that for one client, I will need to have SQL Server
be able
to use them simultaneously.
On Windows XP, you can use netstat to find the program listening at a
specific port. From a command prompt, type netstat -ab (and wait - it
takes a while to run).
To find out what port SQL Server 2000 is using, look in the Server Network
Utility.
To find out what
SQL Server 2000 and SQL Server 2005 on same machi
ne.
On one of my development boxes, I am running CF 7 (on windows
XP) I installed SQL Server 2005 with no issues. I then
realized that for one client, I will need to have SQL Server
2000. I installed 2000 as a separate instance.
I am
Evening folks.
We use MS SQL Server 2000 for a small amount of data on our site, mostly
smaller bits of content separate to our core business (which is in
Cobol), so a few hundred meg of real data I figure.
I'm working on building a new web server to replace the loaner we've had
for a while
OK, nevermind, SQL Server 2005 Express won't work on dual-processor
servers. Ah well.
--
Damien McKenna - Web Developer - [EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
#include stdjoke.h
So has anyone migrated from '2000 to '2005, and if so how well did it
go? We
don't use any fancy stuff in SQL Server like stored procedures, etc,
just basically as a collection of dumb tables, and like I
said we've got
a few hundred meg of data and that's it.
It's my understanding that the
multitasking
-Original Message-
From: Richard Dillman [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 19, 2006 4:07 PM
To: CF-Talk
Subject: Why does this happen with SQL Server 2000 and CFML?
cfquery name=qryDate datasource=#request.dsn#
Select convert(float,getdate()) as datetimefromdb
cfquery name=qryDate datasource=#request.dsn#
Select convert(float,getdate()) as datetimefromdb
/cfquery
cfoutput query=qryDate
display that with: #val(datetimefromdb - 0)#
Returns 38734.6939544 (or whatever date/time it is)
display that with: #dateformat(val(datetimefromdb-0),
this happen with SQL Server 2000 and CFML?
cfquery name=qryDate datasource=#request.dsn#
Select convert(float,getdate()) as datetimefromdb
/cfquery
cfoutput query=qryDate
display that with: #val(datetimefromdb - 0)#
Returns 38734.6939544 (or whatever date/time it is)
display
the date times as integers with
the
datediff('s',application.startdate,now()) to convert the date to
numbers...
Russ
-Original Message-
From: Richard Dillman [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 19, 2006 5:07 PM
To: CF-Talk
Subject: Why does this happen with SQL Server
Hey All,
I have a SQL Server 2000 DB that I need to convert to SQL Server 7. Can it be
done? if so, how?
BTW this is tables, PKs, FKs, and data types.no triggers or stored procs.
TIA
Cheers
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc
I don't think a backup will work for this, but you can try. If that doesn't
work I would create SQL scripts for the structure of the database then use data
transformation services to get the data into the tables.
Bob
~|
I have a SQL Server 2000 DB that I need to convert to SQL
Server 7. Can it be done? if so, how?
You should be able to do this through DTS, if the SQL Server 2000 machine
can connect to the SQL Server 7 machine. If that's not possible, you can
install both on a single machine by installing
You should be able to do this through DTS, if the SQL Server 2000 machine
can connect to the SQL Server 7 machine. If that's not possible, you can
install both on a single machine by installing a default SQL Server 7
instance, then installing a named SQL Server 2000 instance.
Dave Watts, CTO
a problem with MS
Clusters only.
Martin
http://www.beetrootstreet.com
-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 02:18
To: CF-Talk
Subject: RE: SQL Server 2000 Full-text search issues
Martin,
That's the weird thing with ours. I assumed the same
Message-
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 02:18
To: CF-Talk
Subject: RE: SQL Server 2000 Full-text search issues
Martin,
That's the weird thing with ours. I assumed the same thing that it was
the install. So, we scheduled down time for the production box
as
uusal.
russ
-Original Message-
From: George Abraham [mailto:[EMAIL PROTECTED]
Sent: 01 October 2005 14:25
To: CF-Talk
Subject: Re: SQL Server 2000 Full-text search issues
Hi,
Full-text search on SQL Server 2K gave me huge problems. Not only was the
code to conduct a full-text
AND column contains '#word#'
/cfloop
cfelseif isdefined('form.exactPhrase')
AND column contains '#form.searchCriteria#'
/cfif
--
Russ
-Original Message-
From: George Abraham [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 14:02
To: CF-Talk
Subject: Re: SQL Server 2000 Full-text search
: George Abraham [mailto:[EMAIL PROTECTED]
Sent: 01 October 2005 14:25
To: CF-Talk
Subject: Re: SQL Server 2000 Full-text search issues
Hi,
Full-text search on SQL Server 2K gave me huge problems. Not only was the
code to conduct a full-text search cumbersome, but the user had to learn how
October 2005 15:26
To: CF-Talk
Subject: RE: SQL Server 2000 Full-text search issues
What sor tof problems.
I have used FULL-TEXT SEARCH many times without problem, even on a
massive
13gb database with millions of records, it certainly never required the
user
to do anything special, they just
: Fri 9/30/2005 11:41 AM
To: CF-Talk
Subject: RE: SQL Server 2000 Full-text search issues
I too get this on my 2003 cluster. I restored the database as a backup
from my dev box (which it works on) and do a full rebuild - It takes but
a second to say its complete and then gives me absolutely
From: Martin Parry [mailto:[EMAIL PROTECTED]
Sent: Sun 10/2/2005 11:08 AM
To: CF-Talk
Subject: RE: SQL Server 2000 Full-text search issues
I don't have problems on my dev box but when uploading the DB to live
server it never populates the catalogue. I think it's something
PROTECTED]
Sent: 30 September 2005 16:22
To: CF-Talk
Subject: SOT: SQL Server 2000 Full-text search issues
I have a development CF server (Windows 2003 Server, SQL Server 2000
SP4, CFMX 6.1) on which I have a database that has full-text enabled on
a table. When I run a query against the full
: George Abraham [mailto:[EMAIL PROTECTED]
Sent: Saturday, 1 October 2005 11:25 PM
To: CF-Talk
Subject: Re: SQL Server 2000 Full-text search issues
Hi,
Full-text search on SQL Server 2K gave me huge problems. Not
only was the code to conduct a full-text search cumbersome,
but the user had
I have a development CF server (Windows 2003 Server, SQL Server 2000 SP4, CFMX
6.1) on which I have a database that has full-text enabled on a table. When I
run a query against the full-text index, it returns 31 rows.
I have 2 production servers. 1 production CF Server (Windows 2003 Server
-Server-L.asp
Matt Osbun
Applications Manager
Health Systems, International
-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: Friday, September 30, 2005 10:22 AM
To: CF-Talk
Subject: SOT: SQL Server 2000 Full-text search issues
I'm at my wit's end on this one and don't
://www.beetrootstreet.com
-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: 30 September 2005 16:22
To: CF-Talk
Subject: SOT: SQL Server 2000 Full-text search issues
I have a development CF server (Windows 2003 Server, SQL Server 2000
SP4, CFMX 6.1) on which I have a database that has
The DataDirect 3.4 drivers for SQL Server 2000 are causing CFMX 6.1 to
hang when certain insert triggers are executed. I reverted to the 3.3
drivers, but those have other problems with them. I just installed the
Microsoft JDBC sp3 driver in hopes that it is better, and I am
wondering if anybody
The DataDirect 3.4 drivers for SQL Server 2000 are causing CFMX 6.1
to
hang when certain insert triggers are executed. I reverted to the 3.3
drivers, but those have other problems with them. I just installed
the
Microsoft JDBC sp3 driver in hopes that it is better, and I am
wondering
Never too late to reverse a bad decision.
Except when that decision was to step off the curb in front of a fast
moving buss.
s. isaac dealey 954.522.6080
Then again depending on the person, stepping in front of a fast moving buss
would not be a bad decision. Stepping in front of a fast
I've looked in the archives and can't find a good answer to this. I know
I've done it in the past, I just can't remember how and my brain hurts
so i figured i'd ask the list. I have no say about storing the images
in the DB and that decision is already made, so I just need help putting
them in
I have no say about storing the images in the DB and that decision is
already made
Never too late to reverse a bad decision.
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this
I have no say about storing the images in the DB and
that decision is
already made
Never too late to reverse a bad decision.
Except when that decision was to step off the curb in front of a fast
moving buss.
s. isaac dealey 954.522.6080
new epoch : isn't it time for a change?
add
]
Sent: Tuesday, July 12, 2005 2:39 PM
To: CF-Talk
Subject: Re: Storing and retrieving images from SQL Server 2000
I have no say about storing the images in the DB and that decision is
already made
Never too late to reverse a bad decision.
--
___
REUSE CODE! Use
: Claude Schneegans [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 12, 2005 2:39 PM
To: CF-Talk
Subject: Re: Storing and retrieving images from SQL Server 2000
I have no say about storing the images in the DB and that decision is
already made
Never too late to reverse a bad decision
-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 12, 2005 1:39 PM
To: CF-Talk
Subject: Re: Storing and retrieving images from SQL Server 2000
I have no say about storing the images in the DB and that decision is
already made
Never too late to reverse
John, check out this thread:
http://www.forta.com/blog/index.cfm?mode=eentry=1645
--- Ben
-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 12, 2005 2:10 PM
To: CF-Talk
Subject: Storing and retrieving images from SQL Server 2000
I've looked
Certified Advanced ColdFusion MX Developer
Wyle Laboratories, Inc. | Web Developer
-Original Message-
From: Ben Forta [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 12, 2005 2:53 PM
To: CF-Talk
Subject: RE: Storing and retrieving images from SQL Server 2000
John, check out this thread:
http
Thanks for the response, but I'm curious as to why the documentation
doesn't show the variable attribute for cfcontent
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-a1
7.htm#wp2850760
Is this going to be deprecated or is this new or what? I'm using CFMX
6.1.
The VARIABLE
, July 12, 2005 3:40 PM
To: CF-Talk
Subject: RE: Storing and retrieving images from SQL Server 2000
Thanks for the response, but I'm curious as to why the documentation
doesn't show the variable attribute for cfcontent
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-a1
7.htm#wp2850760
and retrieving images from SQL Server 2000
Thanks for the response, but I'm curious as to why the documentation
doesn't show the variable attribute for cfcontent
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-a1
7.htm#wp2850760
Is this going to be deprecated or is this new or what
His job is to monitor email lists. :)
On 7/12/05, Ben Forta [EMAIL PROTECTED] wrote:
Like Dave (who regularly beats us all to the punch, I don't believe he
ever
gets any real work done, that or he has figured out cloning) said.
;-)
Any hint on the latter part of your statement? Is that where I'd need
to convert to base64 or to string and then store in the db and when
pulled out do tobinary()? What exactly is it coming out of the db as
when I insert it? Notice in my first post, I'm having trouble inserting
as well. Not
Mike Chabot wrote:
insert Unicode into these columns without any problems.
you really can't insert unicode into non N columns in sql server
get unicode back. i'd guess you're actually inserting data that the
driver or db is interpreting as non-unicode.
Smart quotes: ''
Where am I wrong in
I thought char and varchar columns would only allow the 255 ASCII
values and would not allow Unicode. SQL Server 2000 seems to let me
insert Unicode into these columns without any problems.
For example, when I insert the two sets of MS Word smart quotes,
separated by a space, into a varchar(5
Also note that you can install SQL 7 and SQL 2K side by side no problem!
-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED]
Sent: 05 January 2005 21:16
To: CF-Talk
Subject: SQL Server 2000
Hi there,
I'm trying to connect to a remote MSSQL database with Microsoft SQL
Hi there,
I'm trying to connect to a remote MSSQL database with Microsoft SQL Enterprise
Manager
but the connection fails because the server requires I uograde to version 2000.
I'm presently using the version 7, I'm pretty happy with it and have no
intention to upgrade.
If I upgrade, I can get
[EMAIL PROTECTED] wrote:
If you install only the Client Tools then they do not time out - only the
server itself times out after the evaluation.
I'm 99% positive that the SQL Server 2000 Client Tools (Enterprise Manager,
Query Analyzer, etc) allow you to attach to both version 7 and 2000
databases
Since this is going to be considered off topic for this list, it'd be best to reply to me off list unless this sparks an interesting discussion.
I've kind of evolved in being the person who sets up the SQL servers for new users as part of my job.I've managed to muddle my way around and get
No mention of any sort of concurrent user limit, and no mention of
thread limits.Does anyone know if these restrictions are lifted and
the published performance limits are all there are?
A 4gb database limit is no big deal to me, and the single-processor
limit isn't an issue as I can't afford a
Does anyone know if there is an Oracle Developer Edition that we could use
to develop an app in-house, then have it hosted at any Oracle host once done?
Same question for SQL Server 2000... ;-)
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com
2000 developer edition?
Does anyone know if there is an Oracle Developer Edition that we could use
to develop an app in-house, then have it hosted at any Oracle host once done?
Same question for SQL Server 2000... ;-)
--
___
REUSE CODE! Use custom tags;
See
Claude Schneeganswrote:
Same question for SQL Server 2000... ;-)
Yes, but it will cost you about US$50.Its license allows you to copy
it anywhere in your office as many times as you like so long as its
use is development/testing only.No production use.I got mine at
cdw.com.
--
--Matt Robertson
2:14 PM
Subject: Re: SQL Server 2000 developer edition?
Yes there isbut getting it is the fun parthave to be part of some MS developer group OR I think you can get it with various MS product licences.
It's called MSDE (Microsoft Developers Edition).Best thing to do is track down hte
This what you mean?
http://www.microsoft.com/downloads/details.aspx?familyid=413744d1-a0bc-479f-bafa-e4b278eb9147displaylang=en
- Original Message -
From: Bryan Stevenson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 13, 2004 5:14 PM
Subject: Re: SQL Server 2000
N :-)
MSDE is available to anyone who has acopy of MS Office Pro, or any
other MS product that includes MSDE... for deployment, even.Its a
chopped down version of the SQL Server engine and contains no
Enterprise mgr, among other things.
The MS SQL Server 2000 Developer Edition is now
: SQL Server 2000 developer edition?
N :-)
MSDE is available to anyone who has acopy of MS Office Pro, or any
other MS product that includes MSDE... for deployment, even.Its a
chopped down version of the SQL Server engine and contains no
Enterprise mgr, among other things.
The MS SQL Server
and SQL Query Analyzer
do not expire.
- You can download MSDE... it's just the server engine and does not
include any other tools.It's free for developers.
- You can purchase a copy of SQL Server 2000 Developer Edition (this
is what I did).Standard retail is about $49.00.
Hatton
[Todays Threads
It's called MSDE (Microsoft Developers Edition).
Thanks a lot.
as always it's buried where you'd never think to lookboy I love the MS site
Yeah, quite frustrating to look for information. The most important things, like reference docs are always buried deep into useless general
Not hard to find at all...
Thanks a lot.
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
[Todays Threads]
[This Message]
[Subscription]
MSDE is available to anyone who has acopy of MS Office Pro, or any
other MS product that includes MSDE... for deployment, even.Its a
chopped down version of the SQL Server engine and contains no
Enterprise mgr, among other things.
you used to have to get it that way, but ms has been giving it
://www.clickdoug.com/mailfilter.cfm
For hosting solutions http://www.clickdoug.com
http://www.forta.com/cf/isp/isp.cfm?isp_id=1069
==
- Original Message -
From: Paul Hastings
To: CF-Talk
Sent: Tuesday, July 13, 2004 8:50 PM
Subject: Re: SQL Server 2000 developer edition
MSDE is being replaced by SQL Server EXPRESS
cool. thanks for the info. it requires .NET a bit more resources than old
msde though.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Express is a version of SQL Server 2005.MSDE is a version of SQL Server
2000 or 7.Hence the different requirements.
Sam
-Original Message-
From: Paul Hastings [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 13, 2004 10:27 PM
To: CF-Talk
Subject: Re: SQL Server 2000 developer edition
I've been advised that I need the 2000 version of the Enterprise Manager
to communicate with SQL 2000.
Should I download Microsoft SQL Server 2000 Desktop Engine (MSDE
2000) (44MB) or do I need to download an entire evaluation version of SQL
server 2000 (172MB...ouch!). The evaluation version
Thanks for the help, I was hoping that there was an alternative to downloading 170MB of waffle just to communicate with the databasepreviously I used SQL Server 7.0 and that had a very quick and simple interface using Access 2000 that allowed me to transfer/edit/delete tables etc.
I've been
I've been advised that I need the 2000 version of the Enterprise Manager to communicate with SQL 2000.
Should I download Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) (44MB) or do I need to download an entire evaluation version of SQL server 2000 (172MB...ouch!). The evaluation version
Is there a HUGE difference between SQL 7 and SQL 2000???Because 2000 is just running really slow and we can't figure out why.Is there a difference in syntax or something?On SQL 7 a multiple insert query (400 inserts) finished in 400ms.in 2000, same query, but in 7 SECONDS!!!
i've google some
Did your indexes come over ok? There is a setting somewhere on 7 I
believe when moving data if you do not say you want indexes to go they
wont. That could impact performace (more on selects I would imagine).
Anyway I have done at least 3 SQL7 - SQL2000 and there were a few minor
problems (and very
Did you update stats?
-Kore
Rob
[EMAIL PROTECTED] To:CF-Talk [EMAIL PROTECTED]
omcc:
Subject:Re: OT:migrating to SQL Server 2000
03/01/2004
03:40 PM
Please respond
to cf-talk
Did your indexes come over ok? There is a setting somewhere on 7 I
believe when moving data if you do not say you
a different CD!
- Original Message -
From: Rob
To: CF-Talk
Sent: Monday, March 01, 2004 3:40 PM
Subject: Re: OT: migrating to SQL Server 2000
Did your indexes come over ok? There is a setting somewhere on 7 I
believe when moving data if you do not say you want indexes to go they
wont. That could
It's reaching, but it might be the collation on the tables.Check it out.
- Original Message -
From: brobborb [EMAIL PROTECTED]
Date: Monday, March 1, 2004 2:45 pm
Subject: Re: OT:migrating to SQL Server 2000
I just did a little test.I created a regular table, with one
field.I used
Are you on a RAID 5? Could cause slower inserts (write) and fast selects
(read).
Does your 2000 server have more RAM than the 7 server?
-Kore
brobborb
[EMAIL PROTECTED] To:CF-Talk [EMAIL PROTECTED]
on.rr.comcc:
Subject:Re: OT:migrating to SQL Server 2000
03/01/2004
03:45 PM
Please respond
No RAID set up.it has 1 gig of RAM, vs 512 on the server with SQL 7
- Original Message -
From: [EMAIL PROTECTED]
To: CF-Talk
Sent: Monday, March 01, 2004 4:09 PM
Subject: Re: OT: migrating to SQL Server 2000
Are you on a RAID 5? Could cause slower inserts (write) and fast selects
(read
: migrating to SQL Server 2000
Are you on a RAID 5? Could cause slower inserts (write) and fast selects
(read).
Does your 2000 server have more RAM than the 7 server?
-Kore
brobborb
[EMAIL PROTECTED] To:CF-Talk [EMAIL PROTECTED]
on.rr.comcc:
Subject:Re: OT:migrating to SQL Server 2000
03/01/2004
1 - 100 of 332 matches
Mail list logo
