The SQL serverd got installed to drive C as a default. But I would need all
the data bases to drive D: as it is much bigger. How can I move the data
bases to drive D: and set to create all the furute data bases there as a
default?

We are currently running SQL server 2005 on two servers.  One server is in
head office, and the other one is in the Disaster Recovery site.  I'm using
SQL  Mirroring to mirror the databases in the head office to the SQL server
in the DR site, and it works fine.  My question is: ...

I downloaded from msdn subscriber downloads the iso images for SQL Server
2008 both enterprise and standard editions and made to dvd's by isobuster.
I was amazed, that when I try to install the products - either on a standard
or virtual PC - the setup.exe file does not exist on ...

_____________________
For over a year I have been using Visual Studio 2005 Professional. I also
had installed SQL Server 2005 Express. All was working fine.
Yesterday, I downloaded the SQL Server 2008 Enterprise's evaluation version.

I install SQL2005 Express with commandline options in our package, but the
installed SQL server always has 'Enforce password policy' and 'Enforce
password expiration' on (box checked) when viewd with 2005 Manager. How can I
specify option(s) in installation command so that both ...

We a have a data under SQL 2005 which has a large log file that's 90% empty.
I'm trying to shrink it by right-clicking the database and selecting Shrink,
as I do with other databases.  However, this specific database doesn't
shrink without any error messages.  The only difference ...

I am having some difficulty configuring Report Server on Windows 2008 IIS-7.
I can not set the Windows Service Identity or the Web Service Identity nor
can I run the initialization portion of the Reporting Services Configuration
Manager.  I have installed the IIS-6 WMI and ...

I'm using Windows Vista x64 Business SP1 with SQL Server 2005 x64 SP2 Dev.
Edition
Also I have VS 2005 and VW 2008 Express
My question is

I am getting set up to upgrade a couple of servers from 2000 to 2005,
so am running Upgrade Advisor. It's running remotely on an XP Pro
client, the servers are Server 2003 running SQL Server 2000, one is
SP3, the other is RTM. Neither server is running .NET 2.0.

When I try to install the MOM database on the SQL, I get the following error.
There might be something to register which I am missing.  I tried to
regsvr32 the oledb32.dll but no luck..
Also this error is due to sql and not scom...so am posting in sql section

If I for some reason want to disable the feature to use Windows
Authorization to be able to log in to SQL Server 2005 how is this done.
I must admitt that I have no reason at all for doing this now but I just
want

INSTALLATION PROBLEMS cf. SQL 2005 EXPRESS
================================
1. Can Only Download management tools with engine. If engine has already
been installed can't just add Management Studio

I get the following error when installing this update manually.  It alsoe
failed to install via Windows Updates so I tried the manual approach.  This
is from the C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB948109_sqlrun_sql.msp.log

I'm trying to install the Developer edition of SQL Server 2008 on my laptop,
and the setup of the SQL Server Services has me stumped.  I'm on an XP sp3
laptop that is occasionally connected to my SBS 2003 domain.  I think I'd
like to use a Domain User Account for the SQL 2008 ...

Presently we have:
Check Database Integrity -- all dbs
Rebuild Index -- all dbs, keep indexes online is UN-checked, job fails
otherwise, SS says this is only for enterprise??