Hi, After i loaded informatica power center on my machine. i am not able to open ms sql server\ Enterprise Manager, getting the following...

subbu

07-17-2003 04:53 PM
Dinesh.T.K

Hi, I get an error saying that SQL server can't be installed on my machine. It says that some components prevent the installation of SQL server on...

Teo

07-17-2003 04:34 PM
Teo

English version Facts: For about 3 months now, when testing, we observed, periodically (3 occurences every 2 weeks), a performance problem with a...

Patrick

07-17-2003 01:07 PM
Andrew J. Kelly

I ran into the same message today: Error running script: sp3_serv_uni.sql (1) trying to install SP3 over Enterprise Evaluation Edition, with Win2k...

Bruce Hanson

07-17-2003 12:45 PM
RGettys

Ok, I just set up Microsoft SQL Server 2000 Standard Edition. I have it on a server running Windows 2000 Server. I then put it on one computer...

Aaron Shover

07-17-2003 12:31 PM
Jasper Smith

Hi Have a Microsoft Windows 2000 Member Server offsite with an installation of MSDE 2000. Would like to change the Server Computer Name with...

Charles Mitchell

07-17-2003 10:11 AM
Mark Broadbent

Ray, --For SQL2000 SQL Server 2000 Evaluation Edition , Developer Edition ,Personal Edition and MSDE. --For SQL7 SQL Server 7.0 Desktop Edition and...

Dinesh.T.K

07-17-2003 09:16 AM
Dinesh.T.K

also check "default language Option" in BOL Check all logins for their language-setting. jobi "jobi" <jobi (AT) reply2 (DOT) group> wrote

Bernard

07-17-2003 07:42 AM
jobi

Please help!! I am getting the following message when attempting to restore one SQL7 db on to a new SERVER. The installation calls for CASE...

Lorraine Westerdale

07-17-2003 07:38 AM
Sanj

(Win2K Adv Server; Win 2K pro and XP pro wkstations) Just installed sp3a on server and wkstations and now can't connect to server. I try to create a...

Sydney Lotterby

07-17-2003 04:41 AM
Mike

Is there any "general" reason the sql server agent will stop by itself after running for 15-30 seconds. Each time I start the service, it will shut...

Tom L

07-17-2003 12:21 AM
David Pless

Hi John, Where and what is Servies applet ? I don't have log file. I even can not open SQL manager and make it run. I have tried to uninstall dan...

Handoyo

07-16-2003 07:10 PM
John Bell

You may need to reinstall Jet from http://support.microsoft.com/default.aspx?scid=kb;en-us;Q282010 Also look...

Allan Mitchell

07-16-2003 03:38 PM
Elizabeth Teffner

That really depends on the component, but probably it will come out of the default heap of SQL Server, since CDO is an in-process COM...

Gert E.R. Drapers

07-16-2003 02:12 PM
Gert E.R. Drapers

I'm attempting to upgrade our SQL 7.0 installation to SQL 2000 SP3a, but when I run setup, I get the following error (which I remember running into...

Don Woeltje

07-16-2003 01:31 PM
Don Woeltje

Let me make sure I understand what your after. I assume you want to replace the MSDE with Standard edition of sql server and keep the existing db's....

Lynn Owens

07-16-2003 01:06 PM
Andrew J. Kelly

Simply running setup.exe for MSDE will not do the trick for you. you are getting the message because when you do that without specifying an...

kris yumul [MS]

07-16-2003 12:49 PM
kris yumul [MS]

Can somebody help me please, I have sql 6.5 install on NT, but will like to upgrade to sql 2000, what is the upgrade steps to follow. I can upgrade...

someone

07-16-2003 12:31 PM
Dinesh.T.K

Hello, Is there a way to change the TCPport number on installation? I am using MSDE 2000 SP3 and need to a remote deployment using the command line...

Mike Ralph

07-16-2003 10:55 AM
Mike Ralph

What could cause the message: "The format of the virtual server name is invalid" if {_} "underscore" is used in the name of the Virtual SQL Server 2k...

Vladimir

07-16-2003 10:10 AM
Vladimir

How do I know if we back up our database with the overwrite option? By default, doess the back up just append to the media? If that is the case, how...

Anh Tran

07-16-2003 07:19 AM
Allan Mitchell

Hi Shimon, I suggest that you first check if you can run MSDE 2000 Setup.exe successfully using command line (not through merge module). If you...

shimonsim@talamus.com

07-16-2003 05:13 AM
Bill Cheng [MSFT]

Try this page http://www.tkdinesh.com/faq/ans/Snapinfail.html HTH Ray Higdon MCSE, MCDBA, CCNA *** Sent via Developersdex...

Ray Higdon

07-16-2003 05:08 AM
Ray Higdon

Please help! How do I get MSDE 2000 desktop to install on my D:\ drive with all of my other programs. There are no options offered and my C:\ drive...

mitchell.fendley@serios.biz

07-16-2003 05:07 AM
Greg Low \(MVP\)

From SQL Books Online: The COLLATE clause can be specified at several levels, including the following: 1.. Creating or altering a database. You can...

kris yumul [MS]

07-15-2003 11:29 PM
Ida Espiritu

I know best practice is to separate the database devices and the transaction log devices in a SAN layout. Where is there a Microsoft document...

Douglas Collimore

07-15-2003 08:42 PM
Andrew J. Kelly

User databases are anything that you created or that are used by off the shelf applications (like Great Plains). Jobs are something that you would...

Keith Kratochvil

07-15-2003 05:21 PM
Keith Kratochvil

How do I determine if sql 2K installed with the Latin1_general_bin collation is unicode or nonunicode. I tried SP_HELPSORT the result was not useful...

sara

07-15-2003 04:43 PM
Dinesh.T.K

Hi Everybody, I have installed Sql-server-2000 on windows-2000 based- server, i have a trouble with a table, it has 5.5 millions of records and...

FEVIS

07-15-2003 02:05 PM
Keith Kratochvil

I just installed SQL server on our windows 2003 server. I changed start service in the service applet twicw, one is from domain account to local...

Ann

07-15-2003 10:01 AM
Ann

Net, See How to Obtain SQL Server 7.0 http://www.microsoft.com/sql/howtobuy/obtain70.asp -- Dinesh.

Dinesh.T.K

07-15-2003 09:27 AM
Dinesh.T.K

Don't know if you can maximize it per say but you certainly should be able to resize it. You might want to get in the habit of using QA to edit...

Andrew J. Kelly

07-15-2003 09:17 AM
Dinesh.T.K

Is it possible to upgrade SQL Server 7.0 Standard edition to 2000 Developer Edition? Any known issues? Thanks

Vipul Shah

07-15-2003 08:14 AM
Vipul Shah

Jeff, I thought you had SQL 2000 not 7.0. I don't know for sure if 7.0 EE can be installed on 2KServer. My guess would be no and the error seems...

Andrew J. Kelly

07-15-2003 06:18 AM
Mark Broadbent

Hi, I'm trying to install SP3 for Analysis Services but I keep getting error An error occurred during the move data process: -132 Any ideas...

Julian Potter

07-15-2003 04:52 AM
Julian Potter

When trying to access the properties of any SQL database using the Microsoft Management Console, the console pauses for about 30 seconds then...

Mark Walsh

07-14-2003 07:56 PM
Mark Walsh

Currently, I'm running SQL Server 2000 on Windows 2000 Advanced Server. I created a new Windows user who is not in the Administrators group. Then, I...

ABG

07-14-2003 06:46 PM
ABG

I installed SQL 2000. I need to upgrade to sp3. Are the service packs cumulative or do I need to install sp1,2, then 3........php

Pat

07-14-2003 06:28 PM
Pat Hampton-Porter

Your CD of SQL Server has the following files in the root: sqlcli.bat sqlcli.iss if you run sqlcli.bat from the command prompt In SQL Server Books...

Oscar

07-14-2003 05:12 PM
Oscar

i am having an issue upgrading my clustered (active- passive) SQL 2000 sever to sp3a. with all sql processes online, from the active node, i start...

mike connor

07-14-2003 04:45 PM
mike connor

I have recently upgraded from MSDE to SQL Server 2000 Developer. I had two instances under MSDE - vsdotnet and netsdk. The upgrade (using the...

Ian Smith

07-14-2003 03:32 PM
kris yumul [MS]

install MSSQL Server 7 and 2000 on one box ? Any subtleties?

Vlad Gonchar

07-14-2003 03:23 PM
kris yumul [MS]

Only MSDE2000 is supported on Web Edition. Have a look at http://www.aspfaq.com/show.asp?id=2461 -- HTH Jasper Smith (SQL Server MVP) I support...

Jasper Smith

07-14-2003 12:59 PM
Andrew J. Kelly

I have a problem after I install SQL and netSDK examples, I have problem with my internet connection. after instsalling the SQL I run my computer for...

gtr7

07-14-2003 11:31 AM
Mark Broadbent

When upgrading from SQL 7.0 to SQL 2000, I encountered this error complaining that script sp_vupgrade_replication cannot be executed. The...

Wee Seng Lim

07-14-2003 02:06 AM
Wee Seng Lim

Also, keep in mind that you should not use an administrator account to run the SQL Server service as, because that will give a potentially hacker to...

Kristofer Gafvert

07-14-2003 02:02 AM
Kristofer Gafvert

Yes, you're absolutely right. It even says so in BOL under the Software requirements for Installation heading. I really should have thought to look...

Steve

07-14-2003 01:14 AM
Steve

Matt, I ran into the same problem today and I also found MSDE's installation instructions to be somewhat lacking in clarity. After...

kris yumul [MS]

07-12-2003 03:41 PM
Steve

Howdy - Got slammed (slammer worm)at work. Had to assume that my system (which was on the network at the time and running SQL Server might have...

randyv

07-12-2003 11:43 AM
randyv

The description for Event ID ( 1001 ) in Source ( SQLCTR70 ) cannot be found. The local computer may not have the necessary registry information or...

Mex

07-12-2003 09:11 AM
Mex