Has anyone else encountered this? I've installed "MSDE 2000 for Developers Using Visual Studio .Net". System is Win2000 Pro SP4. Visual Studio .Net...

Maureen

07-31-2003 06:29 PM
Maureen

Does anyone have documentation on how to create an unatteded install of Client Tools without Enterprise Manager

Liz

07-31-2003 04:39 PM
Liz

Am trying to backup a db to a hdd on a computer that is on our network. The error message I get is a follows: Cannot open backup device...

Nick

07-31-2003 04:08 PM
Andrew J. Kelly

Based on the Standard Edition of SQL Server 2000 what are the licensing requirements if the server has more than the 2 gig of memory in total. If so...

Mike

07-31-2003 03:27 PM
Dinesh.T.K

Hi, I have a database that was migrated from sql7 to sql2000. After, the migration it seems that sql2000 is ignoring the default values for...

dpower

07-31-2003 02:05 PM
Andrew J. Kelly

If your talking about trying to run SQL Server on the WEB edition of Win2003 as I believe you are, then you simple can't do it. Win 2003 Web...

Greg

07-31-2003 02:03 PM
Andrew J. Kelly

Hi, I have a question regarding licensing. If I install a second instance of SQL 2000 on the same server, do I need to purchase another SQL license?...

Seing Cheah

07-31-2003 02:03 PM
Dinesh.T.K

Every time I try to install sql 7.0 it freezes at MDAC install

Andy Farris

07-31-2003 01:42 PM
mike

Is there a way in the SQL Server Enterprise Manager to perform a daily backup every day except Sunday? I'm assuming I edit my scheduled backup job...

Oliver J

07-31-2003 01:23 PM
Dinesh.T.K

Someone has sent me an SQL Server 2000 database (e.g. DBMS.BAK). I want to "restore" it on my copy of SQL Server 2000. It isn't one of the...

Andrew Chalk

07-31-2003 12:33 PM
Andrew Chalk

Alex

salam

07-31-2003 11:30 AM
Neil Pike

Hello. I was sent some files from the county tax office that I need to extract some marketing info from. They sent me a .TDF, .Txt and .Idx file...

Mikey

07-31-2003 11:04 AM
Mikey Stephenson

I'm wanting to install sqlredis in my msi. Looking at the SQL Merge Modules for an example of when and how to do this I see there are a couple of...

Michael Tissington

07-31-2003 10:46 AM
Stefan Krueger [MVP]

"alex" <ntnewsNO (AT) SPAM (DOT) hrz3.hrz.tu-darmstadt.de> wrote Hi Alex, I just set up SLS and it seems to work like a charm. Wasn't to...

Steven

07-31-2003 09:18 AM
Michael

Under per Cpu Licensing Microsoft states "Under this structure, a customer acquires a separate Processor license for each processor that is located...

Simon Hall

07-31-2003 08:58 AM
Mark Broadbent

I created a backup of a database using the MSAccess Database Utility- "Backup SQL Database". I then copied the resulting ".DAT" file to a different...

Nicholas

07-31-2003 08:30 AM
Greg Low \(MVP\)

Is there a white paper or "how to" for setting up two SQL Servers that are mirrored so if one goes down the other kicks in.

Phill

07-31-2003 08:04 AM
Mark Broadbent

When I sort a unicode column "a" comes for "A". On a 'char' column "A" comes for "a", as you would expect from the installed character set &...

Andre Braakman

07-31-2003 08:02 AM
Bart Duncan [MSFT]

Hi, We have tried the Dropserver routine and this part works in that the server changes to whatever newname is specified. However when we now reboot...

dan.elms@spicerhaart.co.uk

07-31-2003 02:27 AM
Mark Broadbent

I run the command sp_helpdb and have a couple of tables that show a sort order = 0. Does SQL2000 have a sort order of 0? It is causing us some...

dave

07-30-2003 06:19 PM
dave

is any of you using the microsoft crm ? -- am planning to go to a microsoft seminar on this topic and learn...

jeo

07-30-2003 03:55 PM
jeo

Hi My Application is designed for 5 languages.English,Spain,France,Japan and Germany. It works fine for all other 4 languages except...

sumathi

07-30-2003 03:21 PM
sumathi

Hello, Is is possible to use the sql server upgrade wizard in sql 2000 to upgrade a sql 6.5 database to a named instance instead of the default...

jen

07-30-2003 10:47 AM
jen

Look up RESTORE HEADERONLY in BOL This will tell you the backups in the device -- ---------------------------- Allan Mitchell (Microsoft SQL...

Allan Mitchell

07-30-2003 09:50 AM
Andrew J. Kelly

SQL server 7.0 (desktop edition) appears to run ok on w2k laptop but fails server registration in Enterprise manager with general network...

Felix

07-30-2003 09:11 AM
Felix Dalldorf

I had an sql server 2000 install which I primarily used as a client to other SQL servers. I recently installed a 3rd party application which uses an...

Andrew Brill

07-30-2003 09:02 AM
Andrew Brill

Hello all, I will try this one a different way than my last explanation... I have a couple of files: test_data.mdf, and test_log.mdf These files...

Andrew Mueller

07-30-2003 08:53 AM
Dinesh.T.K

I get the following error message when trying to connect to SQL Server on a Win2003 Server machine which has SQL Server2000 from a WinXP workstaion...

mo

07-30-2003 08:06 AM
mo

Hello I am about to install a SQL Server 2000 standard. I am using a Dell PowerEdge 1U with 3 harddrive configured in RAID-5 (max 3 HDD (36.7G)...

HY Sia

07-30-2003 06:01 AM
John Bell

Please help... Here's the contents of the sqlstp.log file: Starting Service ... SQL_Latin1_General_CP1_CI_AS -m -Q -T4022 -T3659

James Scotto

07-30-2003 04:05 AM
James Scotto

I am applying the service pack 3a to a SQL 200 server with service pack 3a and encountered a error message "setup was unable to validate your...

Charles Cheng

07-30-2003 02:44 AM
Charles Cheng

I have a msdb that was in suspect mode and I executed sp_resetstutus stored procedure. Now the msdb is in loading mode and I don't have a good...

William Ni

07-30-2003 02:25 AM
Mark Broadbent

I downloaded Books Online, but when I tried to install, I got a window from Norton AntiVirus saying: --- Alert: Malicious script detected Object:...

Doug Latto

07-30-2003 01:49 AM
Jasper Smith

I downloaded the Eval version, then tried to install. It said it wanted 340 MB, but I have 100 GB free! Help! I need this for tomorrow! Thanks.

Doug Latto

07-29-2003 05:51 PM
Dinesh.T.K

I have several remote installations of MSDE 2000 and want to upgrade them to SQL 2000 Personal Edition. Does anyone have an unattended script for...

Steve

07-29-2003 04:51 PM
Steve

I am setting up Log Shipping for the first time to determine if it will be a stable, reliable disaster recovery solution for our site. I decided to...

tb

07-29-2003 04:41 PM
Susan

Hello all, I have been having some problems with converting SQL7 to SQL2000. It stops at the upgrade1.sql portion of the installation. At that...

Andrew Mueller

07-29-2003 04:40 PM
Andrew Mueller

Reinstall your OS... "Marc DellaValle" <Marc_Dellavalle (AT) quantumpharmacy (DOT) com> wrote

Wilfredo Burgos

07-29-2003 04:37 PM
Wilfredo Burgos

Just completed installation of SQLServer 2000 on a Win2003 Server with no problems. I also want to be able to manage SQL Server from my Workstation...

mo

07-29-2003 04:19 PM
Ray Higdon

When installing SQL Server 2000 on my XP Pro machine: On the Service Account dialog, Domain User is the default selection and I leave it that...

Brad

07-29-2003 03:18 PM
Brad

I created a backup device for each of a dozen databases on my sqlserver machine and now all the accumulated backups are quickly filling up my...

frank brown

07-29-2003 02:48 PM
Andrew J. Kelly

Hello all: I have a question. I am trying to setup Oracle 8i and SQL 2000 on the same server, and there are some problems communicating with...

Brad Walsh

07-29-2003 02:40 PM
Brad Walsh

One of our computers was running SQL 7.0 Desktop. Our company reciently upgrade to a Active Directory. In the process, the computer was renamed and...

Sam Berry

07-29-2003 12:08 PM
Sam Berry

Using Enterprise Manager in SQL 2K, I defined a backup plan that performs a full database backup each morning at 2AM. This backup plan also defines...

Charlie Miller

07-29-2003 11:58 AM
Andrew J. Kelly

I am trying to install SQL 6.5 SP5a on a Windows 2000 AS and keep getting the message: "Setup Initialization could not be completed...

Curtis O. Bouknight

07-29-2003 11:31 AM
Curtis O. Bouknight

I plan to have two network cards in a server, each on a different IP network (one will be private). I want to configure SQL Server (a single...

Frank

07-29-2003 11:28 AM
Jasper Smith

Hi, The default date format shown in SQL Server 2000 is mm/dd/yyyy. Our application is targeted on different languages in different settings. It...

Sumathi

07-29-2003 09:18 AM
Mark Broadbent

Hello - I have a SQL 2000 Server here (to which i have full sa and console access) that was operational when I arrived, and the guy who set is no...

Tom Jackson

07-29-2003 08:55 AM
Tom Jackson

I wish I had an answer but I get the same error on a Windows 2000 Server - if anyone has a fix it is greatly appreciated.

EJ

07-29-2003 07:03 AM
EJ

I am using os windoowsxp professional edition i was faild to install sqlserver 2000 enterprise edition on it. Is there any one, who could help...

muntasir

07-29-2003 04:41 AM
Mark Broadbent