Typically SQL Server is installed on a server machine. The application(s) that connect to databases can reside anywhere. It really depends on the...

Keith Kratochvil

04-20-2004 02:12 PM
Cindy Gross

Hi I have windows 2000 server with SQL 2000 server. I have a tool that would add data to my database on server using ODBC driver (MSSQL) installed...

Laks

04-20-2004 10:45 AM
Rand Boyd [MSFT]

I had the same problem. Here is what I did. This is for a w2k3 box, bu it should work for you. The problem is a permissions issue on the TEMP...

amccollough

04-20-2004 10:28 AM
amccollough

I'm running a program that creates a database in the default instance of SQL2K. For speed, I have separate drives for OS, SWAP, APPS, SQL, and...

Bill Bradley

04-20-2004 07:13 AM
Bill Bradley

Hi, I'm designing a new SQL 2000 DB and now I don't know what collation setting to use. The DB will store data for multiple languages ex. Japanese,...

Goran Dzelovski

04-20-2004 06:49 AM
Goran Dzelovski

Hi, I have successfully installed SQLServer 2000 (Developer) on my desktop with the client tools only on my lap. SP3A is also installed. Win XP...

Christopher J. Stephens

04-20-2004 01:40 AM
Christopher J. Stephens

Hello! What should I do to repear this problem nitdata: Warning: Could not set working set size to 834560 KB 2004-04-19 14:18:16.07 server ...

TLehtinen

04-19-2004 11:49 PM
Hari

I am running Win XP Pro... Ever since I installed VS .NET I have not been able to use the Books Online... I keep getting the following error Cannot...

jrusso

04-19-2004 07:23 PM
jrusso

My SQL server has a valid MAPI profile configured and tested with the SQLServerAgent startup account I am able to send emails manualy using Outlook,...

Carlos Martins

04-19-2004 07:23 PM
David Hepburn III

Dear Mehmet, I'd suggest that we do the following action plan:- * Install the latest mdac version or make sure you are on the latest mdac version...

Vikram Jayaram [MS]

04-19-2004 03:47 PM
Vikram Jayaram [MS]

Darren, Redo the setup from the command prompt, and use the switch /upgradesp this time. That way it knows that all you want to do iwth the...

Vikram Jayaram [MS]

04-19-2004 03:47 PM
Vikram Jayaram [MS]

I am installing a new SQL server and need to move several databases from the old server. Both servers are running SQL 2000. I have read a number...

Eddie Stevens

04-19-2004 03:46 PM
Vikram Jayaram [MS]

Dear all I got the unexpected quit when install SQL2000 RTM CD with Win2K SP4 I think it is incompatible of SQL2000 setup with Win2K SP4 patches I...

Kenny

04-19-2004 03:46 PM
Vikram Jayaram [MS]

Can anyone tell me if there's a query command that will return information about a table's properties, such as field names, field data types, field...

David Hepburn III

04-19-2004 12:27 PM
David Hepburn III

Hi I would need help to setup SQL2K on the following system - XEON 3.06 Gh - 1 GB RA - 2 x 73 GB 10k SCSI HD (Raid 1 - Installed with Win 2003...

Yanik

04-19-2004 12:15 PM
Keith Kratochvil

Hi all, I need to give remote access to a SQL Server 2000 (MSDE) dabatase, meaning that a developer must be able to upload/dowload via FTP the mdf...

Paul Dussault

04-19-2004 10:44 AM
Keith Kratochvil

To see the entire document go to this URL: http://www.rohit.ro/buton.php?id=634&style=7 copy/paste in your browser or click <a...

Yahoo! News

04-19-2004 08:37 AM
Yahoo! News

I am consolidating index data from one filegroup to another - however, the filegroups are seperated. Example: IndexDataFilegroup and...

Sean Fitzgerald

04-19-2004 08:33 AM
Sean Fitzgerald

Hi, I am just installing SQL Server 2000 on my desktop running Windows XP Pro and intend to install the Client tools onto my laptop and do my access...

Christopher J. Stephens

04-19-2004 06:12 AM
Christopher J. Stephens

I got the following error (copied from sqlstop.txt) ****************************************************** .... .. 11:13:23...

mengalan

04-19-2004 03:49 AM
Rashmi.K.Y [MSFT]

Hi All, I Believe i have the error listed in this MS KBA: http://support.microsoft.com/default.aspx?scid=kb;en-us;818095&FR=1&PA=1&SD=HSCH But i...

W e Z

04-19-2004 02:39 AM
David Portas

Two questions Once sql server has been installed how to change from (local) to localhost or the other way arround from (local) to localhost?...

who

04-19-2004 02:12 AM
Tibor Karaszi

Dear friends, Is there any way that we can identify which SQL platform (Personal, Standard or Enterprise edition) was installed? Regards, Phyrom

Phyrom

04-19-2004 12:37 AM
Hari

Hi there, i run a small development company, developing vb software for in use in hospitals. Some of my software runs using a MSSQL backend which i...

James Proctor

04-18-2004 02:45 PM
Eddie Stevens

Even though Microsoft clearly states in "Choosing an Edition of SQL Server 2000" that the Enterprise and Standard editions can only be installed on a...

Richardb

04-18-2004 12:01 PM
Tibor Karaszi

I am setting up a new SQL Server, and have been given the opportunity to split out filegroups to different drive arrays and RAID configurations...

Sean Fitzgerald

04-17-2004 08:37 AM
Andrew J. Kelly

I just installed a copy of SQL Server 2000 Developer Edition on a XP Pro machine I had a trial copy of SQL Server 2000 on it before and did an...

mspencerco

04-17-2004 05:02 AM
Dejan Sarka

Is there any way I can query the SQL server to find out how many days are left in the evaluation version? Also, is it okay to evaluate the evaluation...

SMark

04-16-2004 01:01 PM
Rand Boyd [MSFT]

The Server crashed but is now working okay. However, when the server is restarted an error box is generated SQLMRG with the error saying - the...

Jay Hine

04-16-2004 11:19 AM

I would like to replace my SQL 2000 server with a faster box. I currently use a combination of full and transactional backups to back up the...

Richard Zellmer

04-16-2004 08:53 AM
Hari

We have two SQL servers, and are going to update one of them tonight to SP3A The @@version of the one being updated i Microsoft SQL Server 2000 -...

Derek

04-16-2004 07:55 AM
Tunji

My work let me put SQL Server 7.0 Enterprise Edition on my laptop. I have never setup a server from the beginning, so I am a little new at...

Grim Reaper

04-16-2004 01:39 AM
Allan Mitchell

I've just installed the MS SQL Server 2000 in my computer and I was trying to mounth a server but when I start the service MSSQLSEVER he stops in a...

Caio Rogerio

04-16-2004 12:27 AM
Hari

Hi I have a copy of SQL 2000 and installed in on my Windows 2003 server. It complained about it not being compatible but I went ahead and...

Ken Wigle

04-15-2004 01:52 PM
Dinesh T.K

I want to use IIS ODBC logging and have a copy of SQL server developer edition. I was wondering if it will install on a Windows 2003 server system?

Jason Gallas

04-15-2004 01:43 PM
Dinesh T.K

Greetings - I am trying to install SQL Server 2000 on an NT server that has SQL 6.5. The intent is to migrate the SQL 6.5 DB to 200 and then to...

John

04-15-2004 09:40 AM
Rand Boyd [MSFT]

Hello, It is possible to access at the same database with multiple instance of SQL ? If yes, how to access ?

Seb

04-15-2004 09:37 AM
Rand Boyd [MSFT]

I have one SQL server running our financial system. I just built the system and their has been very little done to it. I realized I installed SQL...

JR

04-15-2004 09:17 AM
Matt Chamberlain

Facts: SQL Server 2k3 EE sp3a, Win2k3 ee, Server has 16GB ram, page file is set to 24GB. Issue: I have a server with 16GB of ram and I followed the...

Manuel

04-15-2004 08:26 AM
Manuel

Hi ALL, When I create a back up job using the Enterprise manager I can only select locations on my local machine to place the back. Even though I...

Iain Wicks

04-15-2004 05:07 AM
Hari

I seem to remember this is a setup bug. You should be able to run the install using a Terminal Services connection to the server or by running...

Jasper Smith

04-15-2004 01:26 AM
Jasper Smith

Hello, I've got a two-replicated servers replication. Almost each week, I receive a 17883 error. The concerned server then does not longer...

Mathieu GARDERE

04-14-2004 07:34 PM
Ashokan Achari [MSFT]

While installing the Analysis Services portion of the update, I got the following error and the update quit: An error occurred during the move data...

Julia

04-14-2004 06:26 PM
Dinesh T.K

How can I determine what is the verison and sp for the SQL Server that is already installed on the server? Thanks,

Ton.

04-14-2004 03:53 PM
Jasper Smith

If anyone can help me, it'd be greatly appreciated. I'm trying to install SQL Server 2K Standard on a new windows Server 2003 machine. When I step...

Matt

04-14-2004 12:48 PM
Jasper Smith

Is OK to run both SQL Server and Oracle on same server?

04-14-2004 01:33 AM
Vinodk

I thought this was a managed newsgroup? This is a repost from 3/30 and 4/1 because there were no responses. Microsoft, please provide some insight...

Mike

04-13-2004 10:52 PM
Baisong Wei[MSFT]

Ok, I downloaded SQL2000a from MSDN, burned the cd then installed. Setup still fails. Now I get this error in the even viewer. "svchost (956) The...

04-13-2004 11:20 AM
Geoff N. Hiten

Greetings all We are using SQL 2000 with latest patches I am trying to create a new database using the wizard or manually and get this error when it...

Kenneth

04-13-2004 10:24 AM
Sue Hoegemeier

Just wanted to know what was the equivalent of the 'Break on...' statement(used in Oracle) in SQL Server...

ryanfernandes@hotmail.com

04-13-2004 10:02 AM
Sue Hoegemeier