Hello, PLease go ahead and install SP4 rahter than trying SP3a. SP 4 is a cumilative service pack which holds all the prior fixes +...

Hari Prasad

01-18-2007 07:47 AM
Hari Prasad

Im trying to install the evaluation version (downloaded the x64 executable) - but when ever i try to install it fails saying that the processor does...

Kris

01-18-2007 04:12 AM
Jens

Hi, After making good progress, the setup fails in "Configuring Components" of Sql Server Services phase during the "Configuring MS Sql Server"...

PhilippeH

01-16-2007 06:10 PM
PhilippeH

Hi, I am building an NSIS script in order to make an install cd for the company's application. One of the checks I have to do is whether the machine...

pplat@exnds.com

01-16-2007 03:05 PM
pplat@exnds.com

A transaction log is expanding very rapidly (twice the size of the entire database within 2 hours), even though the recovery model is set to simple....

Daniel Rimmelzwaan [MVP - Dynamics NAV]

01-16-2007 12:20 PM
Daniel Rimmelzwaan [MVP - Dynamics NAV]

When I try to remove sqlxml4.exe Windows Installer asks for sqlxml4.msi in the path: \\URANUS\c$\62b6d3e8ce38c51a5a827d\HotFixSqlxml4\Files\ This...

Henrik Bech

01-16-2007 11:12 AM
Henrik Bech

Hello! 1.) I try to install "SQL 2000 develop. 64 bit" to install on "W2K3 R2 Std. X64". The system tell me this is not the right SQL version for...

Oliver Riedel

01-16-2007 10:22 AM
Oliver Riedel

Hi all, I am doing a new installation of sql 2005 enterprise edition on a 64 bit server. Wherever I set the default path of the database to be,...

techgrl

01-16-2007 10:07 AM
techgrl

Hi, You haven't explained exactly what you wanted to do with SQL Server Standard Edition on XP. I don't understand the comment about Developer...

Andrew Watt [MVP]

01-16-2007 08:54 AM
Andrew Watt [MVP]

I have looked all over the web for Enterprise manager to manage an MSSQL DB. I realize it is only comes bundled with mmsql and cannot be ontained...

stormfrog

01-16-2007 07:15 AM
Hari Prasad

On Thu, 30 Nov 2006 08:15:02 -0800, Scott <Scott (AT) discussions (DOT) microsoft.com> wrote: The last CTP is 9.0.1314, if I remember...

Andrew Watt [MVP]

01-16-2007 01:37 AM

Changing Domains wil not create any problems. But do not change the sql server machine name. Please do below after chnaging domain:- 1. If you are...

Hari Prasad

01-15-2007 10:38 PM
Gis Bun

Hello: We have a SQL Server 2000 client who has a maintenance plan that conducts a backup of its databases. And, each database is using the Full...

childofthe1980s

01-14-2007 04:20 PM
childofthe1980s

Hi, I have some queries : Can a database have multpile owners ? if yes ? How ? How to grant rights to different owners ? Check the dbo.systypes ...

karthikbg

01-14-2007 11:08 AM
Vicky

I have a setup/deployment package that I've included SQL Express, .Net Framework 2.0, and MSI installer as pre-requisites. The project is created in...

Matt F

01-13-2007 11:15 PM
Plamen Ratchev

Here is the situation: I have SQL server express 2005 installed on my pc as instance SQLEXPRESS. I have created a Visual Basic applicaion with the...

red_tea

01-13-2007 02:22 PM
Sylvain Lafontaine

I have created an endpoint at certain port# but I can't access it thorugh IIS. CREATE ENDPOINT GALACTIC_endpoint STATE = STARTED AS HTTP ( SITE =...

Rajiv

01-12-2007 12:31 PM
Rick Byham, \(MSFT\)

Hello. I have a 180 day trial that expired, but we have produciton data on it. I have the licensed version now. Can I just isntall over itself, or...

Dan

01-11-2007 10:13 AM
Jens

What happens when you install a SQLEXPRESS instance on a machine that already has SQL Server 2005? Will the SQLEXPRESS still run in the limited mode...

Vikram Kulkarni

01-11-2007 09:43 AM
Roger Wolter[MSFT]

Hi, yes this is possible, SQL Server Express is just a usual (limited) named instance. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de

Jens

01-11-2007 01:14 AM
Jens

Hi, which media did you use, you which edition did you install ? HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de ---

Jens

01-10-2007 02:41 PM
Jens

Hi Everybody, I have a problem at my SQL Server, SQL Server Version is 2005, I have scheduled a job, ( Maintance Plan ) To backup all database every...

ILKER SOGUT

01-10-2007 01:52 PM
ILKER SOGUT

Hi We are an action pack subscriber in the UK, we currently want to upgrade our Small Business Server 2003 to R2 but this will upgrade SQL to...

Ben

01-10-2007 09:44 AM
nordberg

Sajal, just in case you haven't seen this, you could connect to the SQL Server instance and run "select SERVERPROPERTY ('Edition')" Cheers, Paul...

Paul Ibison

01-10-2007 08:38 AM
Paul Ibison

I have just installed WinXP 64-bit and i am trying to install Query Analyzer. I have tried just about every version of SQLServer disks we have with...

palfery@fvtc.edu

01-09-2007 10:30 PM
kristy

We will be upgrading from 6.5 to 2005 as soon as possible. (Yes, it's long overdue, but the money is now in the budget. Yea!) We learned from...

Linda Dudzic

01-09-2007 10:19 PM
kristy

We are testing our apps against SQL Server 2005 - (several VB apps and they are working great! - kudos for compatibility MS!) We currently offer...

JerryJustic

01-09-2007 04:31 PM
JerryJustic

Does anyone know if it's possible to restore SYSTEM databases from a default instance of SQL 2000 Enterprise to a named instance? If so, can you...

WMB

01-09-2007 01:23 PM
WMB

SQL Server 2005 will accept the connection but you will not have access to new features. For instance, your old ODBC driver won't understand XML...

Rick Byham, \(MSFT\)

01-09-2007 11:27 AM
Rick Byham, \(MSFT\)

Quick question....If I already have the media, do I need a license to load it up and use it? I see on the web were you would need to pay around $35...

Rossi

01-09-2007 11:17 AM
Rossi

I am NEW to SQL so please understand this when I ask what is undoubtedly a stupid question (I have searched the web, but as I am so unknowledgable on...

JJ

01-09-2007 07:43 AM
JJ

Hi, We noticed on our SQL server 2000 (sp4) that tempdb was set to use MB increment rather than percentage based. We decided to change this to 10%...

Jeff Tu

01-08-2007 08:35 PM
Jeff Tu

R3i: I too get that similar configuraiton login error during installation, and then the installation fails ( and thus am unable to apply the SP2 and...

Arnie Rowland

01-07-2007 04:49 PM
looplocal

SSIS won't start, and this causes the installation of Team Foundation Server RTM to fail. I'm getting pretty desperate and have found no info about...

Tom Murphy

01-06-2007 06:07 PM
Tom Murphy

Sorry bad my english... How do get backup progress position? -- Saygýlarýmýzla Þule Demirci

TEKLIFS

01-06-2007 04:13 PM
Andrew J. Kelly

SQL Server 2000 is the default instance; SQL Server 2005 (SP1) is a named instance in the same server. After upgrading SQL Server 2000 from SP3 to...

Jerry.Rhodes@nordstrom.com

01-05-2007 10:33 AM
Jerry.Rhodes@nordstrom.com

Hello, I'm getting a strange problem on upgrading a Virtual Sql Server on Windows Server 2003. This is the environment : An MSCS cluster with Sql...

etienne.grignon@gmail.com

01-05-2007 07:41 AM
etienne.grignon@gmail.com

My supervisor asked me to move the database mdf and ldf files which had been installed in a default location. The data files were moved to one drive...

Nancy Lytle

01-04-2007 07:09 PM
AlterEgo

Sorry, I don't know of a way to do that. -- Rick Byham (MSFT) This posting is provided "AS IS" with no warranties, and confers no rights. "Greg...

Rick Byham, \(MSFT\)

01-04-2007 10:50 AM
Rick Byham, \(MSFT\)

Thanks for replying. I copied mydb.mdf and .ldf to the directory where i created a new database, but in Management Studio, it's the same: i don't see...

Bob

01-03-2007 02:19 PM
Bob

Hi, i installed sqlserver express 2005. I also use the sql server management studio express. I can connect to (myserver\sqlexpress), but when i...

Bob

01-03-2007 11:31 AM
Bob

I have SQL Server 2000 and when I installed it, the default data directory was set on the C drive. I wanted it on the D drive. I figured out how to...

cfisher440

01-02-2007 08:14 PM
Hari Prasad

If you set the IP address in your connection string there is no need to have the browser running. There should be no extra code involved. -- Andrew...

Andrew J. Kelly

01-02-2007 06:24 AM
Andrew J. Kelly

I just installed sql server express and can not start it. basically says it did not respond in a timely manner...etc. Anyone else get this and...

Tim

01-01-2007 08:40 PM
Andrew J. Kelly

Hi; Is there a way for our setup program to configure Sql Server Express to allow connections from an ADO.NET connection in an ASP.NET app on the...

David Thielen

01-01-2007 07:59 PM
Peter Yang [MSFT]

FYI: my sincere apologizes if this group is not the right place for my questions. Hello, 1. My hosting provider hosts ~500 databases on the server...

Vsevolod Ukrainsky

01-01-2007 07:30 AM
Vsevolod Ukrainsky

I have a setup package that I built with VS 2005. I selected three prerequisites in the package, .Net Framework version 2.0, MSI Installer version...

rmgalante@yahoo.com

12-31-2006 08:53 AM
Plamen Ratchev

How is it possible to create a maintenance plan in SSMS when managing a SQL2000 server? The "Maintenance Plans" option does not appear...

D. Haber

12-30-2006 03:09 PM
D. Haber

Yes, you have the wrong media. "Danny" <Danny (AT) discussions (DOT) microsoft.com> wrote

Mark Yudkin

12-30-2006 07:00 AM
Robert Klemme

We have a aerial photo database that has grown to 1TB in size. The backup file has out grown the space available. The hardware folks are adding a...

Randy K

12-29-2006 10:34 AM
Randy K