When setting up different environments (DEV, UAT, DEMO, etc) is it better to
have separate instances on a Box or have separate database on a single
instance.
any thoughts would be appreciated.

I have a Enterprise edition Server 2003 running the Enterprise Edition of SQL
2005.
I recently upgraded the MS Server 2003 to SP2, we also have the SQL Express
edition loaded on the server to support a Tape Backup Program.

The problem we are having is on one of our test systems. When our
software installs in uses the MSBuild bootstrapper to install Sql
Server Express. After it has installed, when we request an enumeration
of Sql Servers on the network it returns "elbert" (the name of the

Never heard of it until I ran into the following wiki piece, URL,
http://en.wikipedia.org/wiki/Microsoft_SQL_Server#SQL_Server_2005
"
SQL Server Express Edition

I have a Dell Vostro 1500 with 4gb of Ram and 200 GB of free space. I have
installed Vista Business 64, and added recommended patches. It also has
Office 2007. I am trynig to install SQL server 2008 express. A prereq for
this is the 4.5 installer.

Is there a way to right click a table and have it auto script inserts
for the data in a given table in SQL Server Management Studio?

wI have a new download of the above installation package. Previously I
installed VS express edition 2008 for web, during which sql 2008 was
installed including configuration and installation tools. I also downloaded
and installed Power shell 1.0.

I have installed SQL Server 2005 on Windows Vista Ultimate x86, then
followed it wth SP3. I then receved the Vista compatibilty error. I wrongly
expected this problem to be addressed in SP3 without having to install SP2.
What is the proper path for me to follow to correcct this?

Please tell me if there's a more appropriate NG for this topic.
I've googled answers to no avail.
I installed SQL 2008 Express in my machine, then MS Visual Web Developer
2008 Express.

I have installed SQL Server 2008 Standard (x86, x64) - DVD (English)
downloaded from msdn on a customers computer, in the installation there was a
pre-pidded product key, the customer now wants to buy this version of SQL
server 1 processor version. What I understand s that he ...

This is driving me NUTS
I know form many years use of Windows that if an update is installed either
automaticlly or maunually it will be removed from the list. How eve not this
one

While attempting to setting up a new user account on a laptop on which SQL
Server 2005 Developer edition is installed I receve an error in SQL Server
2005 Surface Area Configuration. I started surface area configuration with
'run as administrator' and appropriately logged in with ...

We have a small DB app for a customer and want to use SQL 2008 Express. Can
I install the Express and then use the Management Studio from my Laptop
install to manage the Express install for the Initial Setup?
Thanks,

My XP SP3 box has run tons of sql server 2005 installations, from
express to standard to enterprise (possibly) over the years... the
Windows Add/Remove utility has run out of its game, doing so from
registry, did not seem to have covered/removing all instances (may I

We're trying to re-install SQL 2005 on Windows Server 2003 SP1. Removed all
previous components and run the installer clean-up wizard. But we get an
immediate failure on setup with the following recorded. Any suggestions much
appreciated. Ian