I found an article related to upgrading an MSSQL 2000 Standard installation to MSSQL 2000 Enterprise. I am wondering if someone can point me to...

Phil McNeill

12-11-2006 10:25 PM
Hari Prasad

I have an SQL2004 (w/SP3) High Availability cluster (Life Keeper from SteelEye). It consists of 2 servers, one active and one standby. They are set...

Hank Arnold

12-11-2006 02:54 AM
Hank Arnold

Somehow my SQL Server 2000 installation got messed up and refuses to run. I narrowed it down, I believe, to a problem of the DLL drivers for SQL...

Rosman Computing

12-10-2006 02:31 AM
Rosman Computing

What is the server name that i must write in the server field?? i' m in a localhost, (that is not accepted as string), and my O.S. is Windows Xp...

LeoVInce

12-08-2006 11:42 AM
Rick Byham, MS

I am working on Win2K Pro. Due to some reasons, I had to repair Win2K. Prior to this, SQL Server 2005 Managaement Studio Express was working fine...

rn5a@rediffmail.com

12-08-2006 11:40 AM
Rick Byham, MS

Hi, I''m really tearing my hair out here with something I've been working on for a couple of days now. ... :( I have a Server 2003 with SQLServer...

mark.howells@gmail.com

12-08-2006 07:46 AM
mark.howells@gmail.com

We have inherited a brand new SQL 2005 server on which the SQL may have been installed incorrectly. This is a fresh install, no databases. Here are...

Ken A

12-08-2006 06:05 AM
Paul Ibison

Hi, Can anyone please give me some advice about how to migrate the systems table from SQL 2000 to 2005? I am going to use side by side upgrade. I...

Ed

12-08-2006 01:20 AM
Arnie Rowland

On Wed, 29 Nov 2006 11:16:01 -0800, LaurenceRooks <LaurenceRooks (AT) discussions (DOT) microsoft.com> wrote: I installed 2005 Developer Edition on...

Yellow Dog

12-07-2006 09:28 PM
LaurenceRooks

help.

Don

12-07-2006 07:40 PM
Don

When checking the checkbox "Hide system objects in Object Explorer", I'm prompted to restart MMS for the change to take effect. But when I open the...

Morten Snedker

12-07-2006 06:36 AM
Andrew J. Kelly

I'm unable to utilize more than 26.6 GB of RAM on my two SQL Server 2005 installations. Each server has 32 GB of RAM and is running on Windows 2003...

jjbeeson12@yahoo.com

12-05-2006 10:52 PM
Linchi Shea

Hi, we have a working sql 2000 ent active-passive cluster with a single virtual server that I would like to upgrade to sql 2005. I have been...

Jez

12-05-2006 05:24 PM
Jez

I've got a clustered server with a virtual instance of SQL 2005 that I want to remove. Unfortunately, the data drive for the system databases...

Nieves

12-05-2006 01:42 PM
Arnie Rowland

Hi We have SQL Server 2005 trial software installed on our remote server and we have now purchased a fully licenced copy of the...

bazza

12-05-2006 11:23 AM
TH

Hi all How do I select unicode in SQL Server 2000 ? TIA Guy

Guy Cohen

12-05-2006 04:08 AM
Paul Ibison

SQL Server 2005 (running side by side with SQL Server 2000). The problem is with one of my SQL Server 2005 instances. I suffered a power loss. Now,...

Joseph Geretz

12-04-2006 04:38 PM
Joseph Geretz

I'm trying to configure an alias for a sql2005 named instance on the server. My server has 2 instances: sql2k default "sql2005" named One ip...

Blackgoo

12-04-2006 10:50 AM
Rick Byham, MS

Don't know which group is the proper, but here goes: The description of a field in a table - where is it stored? Is it stored in the database...

Morten Snedker

12-04-2006 03:27 AM
Paul Ibison

On Windows 2000 Advanced Server we get the following error messages reported with the msde 2000 (sp3)... Starting custom action RegSqlWithMdac MSI...

Tim Coates

12-03-2006 06:20 PM
Tim Coates

How to properly uninstall SQL Server Express so all the existing server instances are deleted all the registry keys are removed and all the files are...

Vlad Kryvokobylsky

12-03-2006 09:50 AM
Vera Noest

I've already installed visual studio 2005 and the developer edition of sql server 2005, but now I'd like to change the location of the main...

a

12-03-2006 09:22 AM
Hari Prasad

I work in a small office with several Windows 2003 servers. One server runs SQL server 2000. It is behind a firewall and there is no data passing in...

PolarBear

12-02-2006 03:15 AM
Hank Arnold

Some time next year we will be upgrading our SQL2000 server to SQL 2005. In planning for this, I ordered the eval copy of SQL2005 Enterprise....

Hank Arnold

12-02-2006 03:10 AM
Hank Arnold

http://support.microsoft.com/kb/290991 -- Kevin Hill 3NF Consulting http://www.3nf-inc.com/NewsGroups.htm Real-world stuff I run across with SQL...

Kevin3NF

12-01-2006 02:55 PM
Kevin3NF

I am testinng sql server 2005. I needed to re-install the server and followed all the web article I found. But the uninsall program will not remove...

Sn

12-01-2006 10:43 AM
Arnie Rowland

As I recall, SQL 2000 Developers Edition may have only been available with Visual Studio. I'm not 100% on that, but I have never seen a...

Arnie Rowland

12-01-2006 01:24 AM
Arnie Rowland

"My Documents" does not appear on the left hand side of my Open File dialog box. Is there an easier way of getting it on there besides hacking...

j_mcarthur@usa.net

11-30-2006 12:45 PM
j_mcarthur@usa.net

Hi All, I am facing poor perfornance of queries in SQL Server 2005 Standard Edition. whereas I had worked on SQL Server 2005 Enterprise...

PTHSR

11-30-2006 08:05 AM
lucm

My boss is refusing to switch the Verification on Transaction Log backup on, as he feels it imposes an additional load on the server. I say that...

Andy Reilly

11-29-2006 09:25 PM
Hari Prasad

I'm pretty new to both sql 2005 and VB but please bear with me. I have installed SQL 2005 express on a Windows 2003 Standard server. I have also...

josh@adnetss.com

11-29-2006 01:00 PM
Jay B

H! I use SQL Server 2005 and ASP.Net to program a dynamic web site. I use full-text queries against plain character-based data with 'contains'...

djamila

11-29-2006 12:53 PM
djamila

Win2k3 Server RAID5 with 5 disks 20GB system partition (C:) and about 300GB unpartition Trying to install SQL 2000 (not 2005) on the above machine....

John Doe

11-29-2006 12:00 PM
John Doe

I have to allow another application a connection to my database and only grant them select rights to about 8 tables out of a possible 150 tables in...

BrianK

11-29-2006 10:29 AM
BrianK

Can anyone tell me what the overhead of performing a verfication on the transaction log backup is? Cheers Andy

Andy Reilly

11-29-2006 08:34 AM
Andy Reilly

How do I tell which version of SQL and level. of patching is installed tks A

Alex

11-29-2006 08:23 AM
Andy Reilly

Hi, I have to installed one of our applications by a customer (Windows2003 server) who does not have SQL Server 2000. My intention is to first...

Hubert Rétif

11-29-2006 07:41 AM
Kevin3NF

I am trying to use a script to silently install the SQL 2005 client. I am using this command line: start /wait x:\microsoft\sql2005\setup.exe /qn...

JJ

11-28-2006 01:41 PM
JJ

The question is this, is there any "performance" advantage to creating multiple files in a single file group in SQL 2000 or 2005? It seems to be...

Mike H

11-28-2006 12:47 PM
Mike H

How to enable "xp_cmdshell" on unattended installation using "tamplate.ini"?

User

11-28-2006 12:11 PM
Arnie Rowland

We are setting up a SQL 2005 environment in which to migrate all our existing databases to. Below is the hardware configuration we have: 2 servers...

Capt_Ron

11-28-2006 09:40 AM
lucm

Working with my first instance of SQL 2005. Applied SP1 and now I need to add another service (Reporting Services). Not sure how to do it. If I...

Pete

11-28-2006 07:33 AM
Capt_Ron

OK...I'm installing a new SQL 2005 cluster installation. We installed the 64-bit version on these same servers without issue. Due to...

John J. Berlo

11-27-2006 06:25 PM
John J. Berlo

In Oracle's database, there is the concept of mirrored transaction logs. If the primary copy of the transaction logs gets corrupt along with...

Paul

11-27-2006 01:59 PM
burt_king

I installed SQL Server Standard v 9.0.2047. I then installed SP1. When I try to Attach a database and I click the Add... button to select an MDF...

Alex Maghen

11-27-2006 01:24 PM
Suresh

I have been trying to install SQL 2005 on Vista RTM, but it says that the selected features are not supported by this installation. All i want to...

Spenumatsa

11-27-2006 01:15 PM
Suresh

I have two 7200 RPM 320GB drives. I'm thinking to install Vista, .NET Framework, SQL Server 2005 and applications on one drive and put all ..NET...

brett

11-27-2006 03:06 AM
Hank Arnold

Hi, I'm busy with a migration project. To test the app against SQL2005 I have captured the running sbs2003 server into a virtual server. So far no...

Bart

11-26-2006 07:22 PM
Charles Wang[MSFT]

I have a simple Access system which queries 2 Sun System (I think that really means SQLServer) tables via ODBC - as look ups. Can using one of these...

ML

11-26-2006 01:59 PM
ML

Hello I'm having issues with installation of SQL 2000 SP3 on my AMD HP servers. I'm getting the following error in my sqlclstr.log file ~~~ XXX...

mzamborini@gmail.com

11-26-2006 11:05 AM
mzamborini@gmail.com