Re: SQL Server 2000 to 7

2005-12-20 Thread Robert Everland III
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 ~|

RE: SQL Server 2000 to 7

2005-12-20 Thread Dave Watts
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 a

Re: SQL Server 2000 to 7

2005-12-20 Thread Bryan Stevenson
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,

RE: SQL Server 2000 Full-text search issues

2005-10-05 Thread Martin Parry
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

RE: SQL Server 2000 Full-text search issues

2005-10-03 Thread Martin Parry
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

Re: SQL Server 2000 Full-text search issues

2005-10-03 Thread George Abraham
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

RE: SQL Server 2000 Full-text search issues

2005-10-03 Thread Snake
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

RE: SQL Server 2000 Full-text search issues

2005-10-02 Thread Snake
: 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

RE: SQL Server 2000 Full-text search issues

2005-10-02 Thread Martin Parry
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

RE: SQL Server 2000 Full-text search issues

2005-10-02 Thread Burns, John D
: 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

RE: SQL Server 2000 Full-text search issues

2005-10-02 Thread Burns, John D
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

Re: SQL Server 2000 Full-text search issues

2005-10-01 Thread George Abraham
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 to define searches in ways that were not really fair to the user. That is why I decided to turn to another appliance for full-text search

RE: SQL Server 2000 Full-text search issues

2005-10-01 Thread Taco Fleur
: 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

RE: SQL Server 2000 Full-text search issues

2005-09-30 Thread Matt Osbun
IT Toolbox has a fairly active discussion group about SQL Server that you might want to try out. Not that I'm against turning to this list for OT help (I'm one or two failures away from doing it myself soon, but that's a different kettle of fish).

RE: SQL Server 2000 Full-text search issues

2005-09-30 Thread Martin Parry
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 no results. If I find a solution I'll post it here. IF! Martin Parry

Re: SQL Server 2000 Driver for JDBC

2005-09-23 Thread Stephen Dupre
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

RE: SQL Server 2000

2005-01-06 Thread Robertson-Ravo, Neil (RX)
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

Re: SQL Server 2000

2005-01-05 Thread Mike Kear
Make that 100% positive Jim. That's what I do. I have the EM2000 and other tools, and connect mostly to SQLServer2000 but I have one client with SQLServer7 and it works just fine with that. Just like a bought one. My advice also is to install the client tools, but not the server and you can

Re: SQL Server 2000 developer edition?

2004-07-14 Thread Matt Robertson
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

Re: SQL Server 2000 developer edition?

2004-07-13 Thread Bryan Stevenson
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 SQL Server product comparison page and hunt aroundas

Re: SQL Server 2000 developer edition?

2004-07-13 Thread Matt Robertson
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

Re: SQL Server 2000 developer edition?

2004-07-13 Thread Jeff Garza
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

Re: SQL Server 2000 developer edition?

2004-07-13 Thread Todd
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

Re: SQL Server 2000 developer edition?

2004-07-13 Thread Matt Robertson
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 a

Re: SQL Server 2000 developer edition?

2004-07-13 Thread Bryan Stevenson
: 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

Re: SQL Server 2000 developer edition?

2004-07-13 Thread C. Hatton Humphrey
good to know it's changed (we have the Action Pack so we get all the goodies)thanks Matt ;-) When I was searching for SQL Server solutions for development this is what I found: - You can download the trial version of SQL Server.The server expires after 120 days, the Enterprise Manager and

Re: SQL Server 2000 developer edition?

2004-07-13 Thread Claude Schneegans
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

Re: SQL Server 2000 developer edition?

2004-07-13 Thread Claude Schneegans
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]

Re: SQL Server 2000 developer edition?

2004-07-13 Thread Paul Hastings
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

Re: SQL Server 2000 developer edition?

2004-07-13 Thread Doug White
://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

Re: SQL Server 2000 developer edition?

2004-07-13 Thread Paul Hastings
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]

RE: SQL Server 2000 developer edition?

2004-07-13 Thread Samuel R. Neff
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

RE: SQL Server 2000 and Pagination

2003-12-22 Thread Dave Watts
I'm curious how folks are implementing pagination using SQL Server 2000 and avoiding returning entire recordsets to CF. In other words, if I have a search result set of 1,000 rows, and the user will be walking through that recordset 25 rows at a time using prev pagenumbers next methods,

RE: SQL Server 2000 and Pagination

2003-12-22 Thread Mike Townend
i tend to use this... CREATE PROCEDURE [dbo].[spr_PagedItems] @Pageint, @RecsPerPage int, @Tournementint AS -- We don't want to return the # of rows inserted -- into our temporary table, so turn NOCOUNT ON SET NOCOUNT ON --Create a temporary table CREATE TABLE #TempItems ( tempID

Re: SQL Server 2000 and Pagination

2003-12-22 Thread Calvin Ward
in inconsistency. - Calvin - Original Message - From: Dave Watts To: CF-Talk Sent: Monday, December 22, 2003 8:39 AM Subject: RE: SQL Server 2000 and Pagination I'm curious how folks are implementing pagination using SQL Server 2000 and avoiding returning entire recordsets to CF

Re: SQL Server 2000 and Pagination

2003-12-22 Thread Calvin Ward
Mike, That looks pretty good, what's the performance like on large recordsets, do you happen to know? Thanks, Calvin - Original Message - From: Mike Townend To: CF-Talk Sent: Monday, December 22, 2003 8:33 AM Subject: RE: SQL Server 2000 and Pagination i tend to use this... CREATE

RE: SQL Server 2000 and Pagination

2003-12-22 Thread Mike Townend
the one we actually ues it for is quite slow, couple of seconds for a 1 record set, but it is doing more than just select * from foo HTH -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Monday, December 22, 2003 13:55 To: CF-Talk Subject: Re: SQL Server 2000

Re: SQL Server 2000 and Pagination

2003-12-22 Thread Cedric Villat
Calvin, I use a combination of 2 queries, which are VERY fast. cfset start = 50 cfset end = 75 cfquery name=ID SELECT t.TicketID FROM Tickets t WHERE 1 = 1 AND whateverelse /cfquery then SELECT t.TicketID, etc. FROM Tickets t WHERE 1=1 AND same whatever else from above AND t.TicketID

Re: SQL Server 2000 permissions problem

2003-04-02 Thread Kay Smoljak
Matthew Walker wrote: Can you dimply do a global search and replace any dbo. In your code with ? My code doesn't have dbo... My code doesn't have anything except tablename.field, and that's always worked on three dev servers and at least three production servers before :) In fact, I've DTS'd

RE: SQL Server 2000 permissions problem

2003-04-02 Thread Matthew Walker
Ouch... I was hoping I could just run a stored proc :( Um I don't really know what I'm doing when it comes to SQL Server so bear that in mind ;-) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4

Re: SQL Server 2000 permissions problem

2003-04-01 Thread Kay Smoljak
Kay Smoljak wrote: I'm having some weird kind of permissions problem with our dev box SQL Server that I've never come across before, which makes me wonder if something has changed on the machine to cause it. So either a permanent solution or a temporary work around would be fantastic. This is

RE: SQL Server 2000 permissions problem

2003-04-01 Thread Matthew Walker
Can you dimply do a global search and replace any dbo. In your code with ? Now that I've created the new database and populated it with the data, the local code can only access those tables that are owned by dbo. Trying to access one of Fred's tables results in Base table not found.

Re: SQL Server 2000 and CFMX

2002-07-11 Thread Michael Dinowitz
I'm sorry that I don't have an answer for your specific problem but I do have a comment. Using the ODBC socket is slower than using the JDBC connector. When I set it up I used the JDBC and set a new user for SQL2k with a specific password and limited access. I've been running into some

RE: SQL Server 2000 and CFMX - Solved

2002-07-11 Thread Mike Roberto
PROTECTED]] Sent: Thursday, July 11, 2002 8:21 PM To: CF-Talk Subject: Re: SQL Server 2000 and CFMX I'm sorry that I don't have an answer for your specific problem but I do have a comment. Using the ODBC socket is slower than using the JDBC connector. When I set it up I used the JDBC and set a new user

RE: SQL Server 2000 and @@Identity

2002-04-11 Thread Clint Tredway
Try putting this into a stored proc and trying it. I am using SQL 2000 and I have no problem doing this. Clint -Original Message- From: Rick Walters [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 2:02 PM To: CF-Talk Subject: SQL Server 2000 and @@Identity Hi List, I

RE: SQL Server 2000 and @@Identity

2002-04-11 Thread Tony_Petruzzi
try upgrading your mdac. also why aren't you delcare lastid and making your statement SELECT @lastid = @@identity Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Rick Walters [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11,

RE: SQL Server 2000 and @@Identity

2002-04-11 Thread Rick Walters
Checking on the MDAC upgrade idea.. @lastid would assume lastid is a declared variable, it's just part of my select statement. I could have named it anything. Thanks for the MDAC idea. It's a new server and I forgot about that. Good Fortune, Richard Walters, Webmaster, Davita Laboratory

RE: SQL Server 2000 and @@Identity

2002-04-11 Thread Dave Watts
also why aren't you declare lastid and making your statement SELECT lastid = identity If he did that, he wouldn't get lastid back as a query column. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444

RE: SQL Server 2000 and @@Identity

2002-04-11 Thread Chip Harlan
, April 11, 2002 3:36 PM To: CF-Talk Subject: RE: SQL Server 2000 and @@Identity also why aren't you declare lastid and making your statement SELECT @lastid = @@identity If he did that, he wouldn't get lastid back as a query column. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice

RE: SQL Server 2000 and @@Identity

2002-04-11 Thread Dave Watts
also why aren't you declare lastid and making your statement SELECT lastid = identity If he did that, he wouldn't get lastid back as a query column. I usually use SET NOCOUNT ON INSERT INTO people (password, username) VALUES ('something', 'testuser123456')

RE: SQL Server 2000 desktop version.

2001-11-01 Thread Patrick Harkins
Subject: RE: SQL Server 2000 desktop version. Ahhh... Ooops... I stand corrected. There's a first for everything =) Here's Microsoft's link to a comparison: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ ar_sa2_9gz4.asp -Original Message- From: Dave Watts

RE: SQL Server 2000 desktop version.

2001-11-01 Thread Dave Watts
OK, so it looks like for what I need (a SQL server on my local development machine -- my 120 eval is about to expire, and I've really started to dig SQL Server), I need the developers edition. This costs $500. With this, I could, if I wanted -- in addition to my usual CF-based

RE: SQL Server 2000 desktop version.

2001-10-30 Thread Mike Craig
There is a desktop version? -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 11:10 AM To: CF-Talk Subject: SQL Server 2000 desktop version. Do you need a license to install the desktop version of SQL Server 2000? Thanks. Dave

RE: SQL Server 2000 desktop version.

2001-10-30 Thread krisch
Yes, it's actually called Personal Edition. I'm not sure of the licencing issues. I would guess that there is at least one licence included since it comes with the server edition. FWIW, Kristine C. Hege [EMAIL PROTECTED] Database Applications SpecialistPhone: (802)

RE: SQL Server 2000 desktop version.

2001-10-30 Thread Costas Piliotis
]] Sent: Tuesday, October 30, 2001 10:39 AM To: CF-Talk Subject: RE: SQL Server 2000 desktop version. There is a desktop version? -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 11:10 AM To: CF-Talk Subject: SQL Server 2000 desktop version

RE: SQL Server 2000 desktop version.

2001-10-30 Thread Dave Watts
It's called msde. It comes with Office 2000/XP. Not Really a desktop edition but rather a scaled down implementation of SQL Server. As far as I know, if you have an Office 2000/XP licence, you have a MSDE licence as well. MSDE isn't the same as SQL Server Desktop Edition. With SQL

RE: SQL Server 2000 desktop version.

2001-10-30 Thread Mike Craig
, October 30, 2001 1:50 PM To: CF-Talk Subject: RE: SQL Server 2000 desktop version. It's called msde. It comes with Office 2000/XP. Not Really a desktop edition but rather a scaled down implementation of SQL Server. As far as I know, if you have an Office 2000/XP licence, you have a MSDE licence

RE: SQL Server 2000 desktop version.

2001-10-30 Thread Dave Watts
oh...i've seen the msde stuff...not real impressed but a good desktop mechanism...I was hoping for a full blown version of the database server for a workstation like they used to have with 6.5 and 7.0. Well, they do have that. If you just want to install SQL Server on your workstation for

RE: SQL Server 2000 desktop version.

2001-10-30 Thread Mike Craig
the way it works with SQL. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 2:10 PM To: CF-Talk Subject: RE: SQL Server 2000 desktop version. oh...i've seen the msde stuff...not real impressed but a good desktop mechanism...I was hoping

RE: SQL Server 2000 desktop version.

2001-10-30 Thread Dave Watts
Ok...let's say I believe you...where is the developers edition? If you try installing 2000 on a Windows 2000 machine the first thing it tells you is that you cannot install it on workstation. Uh, you have to BUY it. It's a separate product, to the best of my knowledge. If you're an MSDN

RE: SQL Server 2000 desktop version.

2001-10-30 Thread Costas Piliotis
, October 30, 2001 11:01 AM To: CF-Talk Subject: RE: SQL Server 2000 desktop version. It's called msde. It comes with Office 2000/XP. Not Really a desktop edition but rather a scaled down implementation of SQL Server. As far as I know, if you have an Office 2000/XP licence, you have a MSDE

RE: SQL Server 2000 desktop version.

2001-10-30 Thread Jeffry Houser
/8_ ar_sa2_9gz4.asp -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 11:01 AM To: CF-Talk Subject: RE: SQL Server 2000 desktop version. It's called msde. It comes with Office 2000/XP. Not Really a desktop edition but rather a scaled down

RE: SQL Server 2000 desktop version.

2001-10-30 Thread Costas Piliotis
, 2001 12:56 PM To: CF-Talk Subject: RE: SQL Server 2000 desktop version. Ahhh... Ooops... I stand corrected. There's a first for everything =) Here's Microsoft's link to a comparison: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ ar_sa2_9gz4.asp -Original

RE: SQL Server 2000 desktop version.

2001-10-30 Thread Mike Craig
:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 7:10 PM To: CF-Talk Subject: RE: SQL Server 2000 desktop version. I have one more thing to add to all of this. ( It is in-line) At 12:55 PM 10/30/2001 -0800, you wrote: Ahhh... Ooops... I stand corrected. There's a first for everything

RE: SQL Server 2000 desktop version.

2001-10-30 Thread Dave Watts
SQL Server 2000 will not install on Windows 9x. You must have either NT or 2000. You can install the client tools, such as Enterprise Manager and Query Analyzer. But, the Server portion will not work. SQL Server 97 worked great. 2000 was a no go. Au contraire:

RE: SQL Server 2000 desktop version.

2001-10-30 Thread Owens, Howard
OK, so it looks like for what I need (a SQL server on my local development machine -- my 120 eval is about to expire, and I've really started to dig SQL Server), I need the developers edition. This costs $500. With this, I could, if I wanted -- in addition to my usual CF-based development --

RE: SQL Server 2000 desktop version.

2001-10-30 Thread Jeffry Houser
: grumble, grumble: I wish I knew that a year ago. Thanks At 04:27 PM 10/30/2001 -0500, you wrote: SQL Server 2000 will not install on Windows 9x. You must have either NT or 2000. You can install the client tools, such as Enterprise Manager and Query Analyzer. But, the Server portion

Re: Sql Server 2000

2001-09-25 Thread William J Wheatley
Nope still went into Single User Mode again this morning and its only 1 db this is so damn weird and even after Sql Server SP1 Bill Wheatley Director of Development Certified Master ColdFusion 5 Developer AEPS INC Allaire ColdFusion Consulting Partner www.aeps.com www.aeps2000.com 954-472-6684

RE: Sql Server 2000

2001-09-25 Thread Peter Tilbrook
- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of William J Wheatley Sent: Tuesday, 25 September 2001 22:27 To: CF-Talk Subject: Re: Sql Server 2000 Nope still went into Single User Mode again this morning and its only 1 db this is so damn weird and even after Sql Server SP1 Bill

Re: Sql Server 2000

2001-09-25 Thread Al Musella, DPM
Try disabling any automated maintanace tasks... it may be that it is putting the db into single user mode to process the task, then not completeing successfully, so it never gets to removing the single user mode. Check your error logs for problems relating to automated maintanace tasks. At

RE: Sql Server 2000

2001-09-25 Thread Michael Ross
http://www.anzfa.gov.au -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of William J Wheatley Sent: Tuesday, 25 September 2001 22:27 To: CF-Talk Subject: Re: Sql Server 2000 Nope still went into Single User Mode again this morning and its only 1 db this is so

Re: SQL SERVER 2000 GOING TO Single User Mode

2001-09-24 Thread Mike Tangorre
when you set it up did you use the right licensing mode? :-) - Original Message - From: William J Wheatley [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, September 24, 2001 9:16 AM Subject: OT: SQL SERVER 2000 GOING TO Single User Mode Sql server 2000 keeps going

RE: SQL SERVER 2000 GOING TO Single User Mode

2001-09-24 Thread Carlisle, Eric
Certified Master ColdFusion 5 Developer ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives:

Re: SQL SERVER 2000 GOING TO Single User Mode

2001-09-24 Thread William J Wheatley
[EMAIL PROTECTED] Sent: Monday, September 24, 2001 9:24 AM Subject: Re: SQL SERVER 2000 GOING TO Single User Mode when you set it up did you use the right licensing mode? :-) - Original Message - From: William J Wheatley [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday

Re: SQL SERVER 2000 GOING TO Single User Mode

2001-09-24 Thread William J Wheatley
Developer AEPS INC Allaire ColdFusion Consulting Partner www.aeps.com www.aeps2000.com 954-472-6684 X303 ICQ: 417645 - Original Message - From: Carlisle, Eric [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, September 24, 2001 9:19 AM Subject: RE: SQL SERVER 2000 GOING TO Single User

RE: SQL SERVER 2000 GOING TO Single User Mode

2001-09-24 Thread Sicular, Alexander
i recently had this happen on sql7sp2. the fix was to patch it to sp3. i think sql2k has a sp1 out. the change log may speak to your problem. -alex -Original Message- From: William J Wheatley [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 9:16 AM To: CF-Talk Subject: OT:

Re: SQL SERVER 2000 GOING TO Single User Mode

2001-09-24 Thread William J Wheatley
[EMAIL PROTECTED] Sent: Monday, September 24, 2001 9:53 AM Subject: RE: SQL SERVER 2000 GOING TO Single User Mode i recently had this happen on sql7sp2. the fix was to patch it to sp3. i think sql2k has a sp1 out. the change log may speak to your problem. -alex -Original Message

Re: SQL Server 2000 DTS Import help

2001-06-04 Thread Massimo Foti
Brian Hogue [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... Also, is there a good NG on SQL Server (like this is for CF)? You can find excellent mailing list at: http://www.swynk.com/ Massimo ~~ Structure your ColdFusion code

Re: SQL Server 2000 DTS Import help

2001-06-04 Thread Massimo Foti
I guess my mail server is faster to collect the mails from the list :-) Massimo Brian Hogue [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... Massimo - You must be a mind reader. How can your reply's timestamp be 14 minutes before my question? :-)

Thanks Re: SQL Server 2000

2001-06-01 Thread Art Broussard
Thanks for all the info. I think I am going to try using Access first since I have that installed allready. If that doesn't work then I going for the SQL 2000 client tools. Art Never put your finger where you wouldn't put your nose. ~~ Structure

RE: SQL Server 2000

2001-05-31 Thread Dan Phillips
You need Enterprise Manager. This should be on the same CD that you used to install SQL server. Just run that CD on your workstation and choose the install for the Network Tools. Dan Phillips www.cfxhosting.com -Original Message- From: Art Broussard [mailto:[EMAIL PROTECTED]] Sent:

RE: SQL Server 2000

2001-05-31 Thread Lee Fuller
Yes.. it comes with SQL 2000. It's called Enterprise Manager. Take a look at the client tools on the disc. Lee Fuller Chief Technical Officer PrimeDNA Corporation / AAA Web Hosting Corporation We ARE the net. http://www.aaawebhosting.com -Original Message- From: Art Broussard

Re: SQL Server 2000

2001-05-14 Thread Adrian Cooper
- Original Message - From: Derek Hamilton [EMAIL PROTECTED] Sent: Monday, May 14, 2001 10:23 PM I am in the process of planning my upgrade to SQL Server 2000 from SQL Server 7.0. I was wondering if anyone has noticed anything odd or difficult in respect to ColdFusion (4.5 and No -

RE: SQL Server 2000

2001-05-14 Thread Gregory Harris
]] Sent: Monday, May 14, 2001 2:56 PM To: CF-Talk Subject: Re: SQL Server 2000 - Original Message - From: Derek Hamilton [EMAIL PROTECTED] Sent: Monday, May 14, 2001 10:23 PM I am in the process of planning my upgrade to SQL Server 2000 from SQL Server 7.0. I was wondering if anyone has

Re: SQL Server 2000

2001-05-14 Thread Bill Davidson
Be sure to double check your stored procedures. SQL Server 7 was tolerant of the create procedure name being different from the actual stored procedure name, but 2000 isn't. Or at least the import routine isn't. It will just fail, but if it does, then that's probably the problem. When we

RE: sql server 2000

2001-05-01 Thread Matthew Fusfield
The administrator setup is similar to the setup for an ODBC datasource; the main difference is you must type in SQLOLEDB in the provider field...other than that, setting your server database names as well as username and password are the same. The datasource name used in cfquery is whatever you

RE: sql server 2000

2001-05-01 Thread Mike Brunt
** Macromedia Representative ** Here are a couple of Knowledge Base articles to help you. http://www.allaire.com/Support/KnowledgeBase/SearchForm.cfm then select article ID's 14709, 14632. Kind Regards - Mike Brunt Macromedia Consulting Tel 562.243.6255

RE: sql server 2000

2001-05-01 Thread Jay Brushett
Thanks to all who responded. I found the answer in the knowledge base articles. Jay At 12:31 PM 5/1/2001 -0400, you wrote: ** Macromedia Representative ** Here are a couple of Knowledge Base articles to help you.

RE: SQL Server 2000 warning

2001-04-26 Thread Janine Jakim
David, It's funny how timing works...I had just read this email from another list I am on and then came across yoursso I did an old copy/paste job. Hi All, I am the king of OT posts this week, but y'all know yer stuff, so... Every time I change a SQL Server TABLE, any VIEWS associated

Re: SQL Server 2000 warning

2001-04-26 Thread David Cummins
Yeah, bizarre coincidence! BTW, sorry if my post was a little strong, just had clients hassling me about it, and needed to pass it on! ;) David Cummins Janine Jakim wrote: David, It's funny how timing works...I had just read this email from another list I am on and then came across

RE: SQL Server 2000

2000-12-18 Thread Aaron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hey Dave, SQL Server works on port 1433. Aaron Johnson, MCSE, MCP+I Allaire Certified ColdFusion Developer MINDSEYE, Inc. phn617.350.0339 fax617.350.8884 icq66172567 [EMAIL PROTECTED] ___ "Never forget that

RE: SQL Server 2000

2000-12-18 Thread JustinMacCarthy
port : 1433 is the registered port of mssql Justin -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Monday, December 18, 2000 5:30 PM To: CF-Talk Subject: SQL Server 2000 What is the default/common port used for sql server? Thanks. Dave

RE: SQL Server 2000 per CPU pricing

2000-07-05 Thread Steve Pierce
At $20,000 per processor for SQL Server Enterprise, the drop in Oracle pricing couldn't come soon enough. The $20K is a trial balloon price to see what happens in the press about the price hike. I have heard MS is going to drop the price, probably to $10,000 per processor. That will be in most

Re: SQL Server 2000 per CPU pricing

2000-07-05 Thread Adrian Cooper
- Original Message - From: "Steve Pierce" [EMAIL PROTECTED] Sent: Wednesday, July 05, 2000 7:25 PM At $20,000 per processor for SQL Server Enterprise, the drop in Oracle pricing couldn't come soon enough. The $20K is a trial balloon price to see what happens in the press about the

Re: SQL Server 2000 per CPU pricing

2000-07-05 Thread paul smith
Microsoft speak with forked tongue? One part of the announcement below says no CALs are required for SQL Server 2000, the table following it says otherwise. Which is correct? best, paul At 06:32 PM 7/5/00 +0100, you wrote: Those backending your apps with MS SQL Server might be interested in

Re: SQL Server 2000 per CPU pricing

2000-07-05 Thread Phil Labonte
00 7:19 PM Subject: Re: SQL Server 2000 "per CPU" pricing Microsoft speak with forked tongue? One part of the announcement below says no CALs are required for SQL Server 2000, the table following it says otherwise. Which is correct? best, paul At 06:32 PM 7/5/00 +0100, you wrot

RE: SQL Server 2000 per CPU pricing

2000-07-05 Thread Ken Wilson
Microsoft speak with forked tongue? One part of the announcement below says no CALs are required for SQL Server 2000, the table following it says otherwise. Perhaps I took it the wrong way, but I read that to say we have two options in our quest to make Bill richer: Server Licensing -

RE: SQL Server 2000 per CPU pricing

2000-07-05 Thread Steve Pierce
smith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 05, 2000 7:20 PM To: [EMAIL PROTECTED] Subject: Re: SQL Server 2000 "per CPU" pricing Microsoft speak with forked tongue? One part of the announcement below says no CALs are required for SQL Server 2000, the table following it says

While on vacation (was: Re: SQL Server 2000 per CPU pricing)

2000-07-05 Thread Jennifer
At 07:44 PM 7/5/00 -0400, you wrote: Dumb question. I wanted to knowwhat is the best thing to do when I am on vacation for this list should I unsubscribe while I am away... or is there a temp stop feature? No temp stop feature. If you really don't want the mail (or if you will be turning on a

RE: SQL Server 2000 per CPU pricing

2000-07-05 Thread paul smith
erver 2000 than SQL Server 7 CALS licensing. It will be easier to administer with per CPU licensing though. - Steve -Original Message- From: paul smith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 05, 2000 7:20 PM To: [EMAIL PROTECTED] Subject: Re: SQL Server 2000 "per CPU"

  1   2   >