I've downloaded and installed the SQL2k DTS designer components to be able
to edit some DTS packages, but even after rebooting, my Managment Studio
install is not seeing it.
Nothing to do with XP SP3 is it?

I restored a SQL 2000 db to my SQL 2005 instance in the process its putting
the db owner in front of the table name like this
owner.employees
owner.customers

It's a long story, but I have a legacy SQL7 Enterprise server that I recently
installed, patched to SP4 and have been running for a few days (working
great, thanks).  
Tonight, I inadvertently started the SP1 install.  The script failed, but to

is it possible to get sql-server 2000 running on XP with service pack
3?
We have at least problems on one computer installing service pack 3a
and 4 for sql-server 2000 on such a XP system.

I've installed SQL2005 Standard from the disc in my MSDN collection, NOT a
retail version.
When I look at the server's PROPERTIES, and select the MEMORY options and
view the help file, it makes mention of Dynamic memory configuration. The

For server & CAL model purchased via licensing, where are CAL's added?  
During the SQL server installation, we were not prompted for the licensing
key or for the number of CALs purchased.

I have vista home basic on my laptop. I need SQL, but I can't install it on
my system. I faced this error in the middle of installation:
SQL Server Setup could not connect to the database service for server
configuration. The error was: [Microsoft][SQL Native Client][SQL ...

We have a server instance on SQL Server 2005 SP2 build 3042. We have a 32 bit
x86 server. We attempted to upgrade to SP2 build 3054 KB934458. And we got
the following error as stated in the Summary.txt file.

I have a legacy 7.0 SP4 standard running on a machine that is failing.  I
have spun up a 7.0 Enterprise server and am ready to move to it.  I've read
this article:
http://vyaskn.tripod.com/moving_sql_server.htm

I have a big problem with SQL Server Express 2005. I had installed SQL
Server Dev Edition 2005 and SQL Express 2005, both working fine and together
with Visual Studio 2008. Starting on saturday none of the two SQL Servers
are working. I tried a repair installation which didn't ...

Will it work?  If so, do I need to do anything special?
My first attempt appeared to install without error (as did SP2) but it did
not create a default instance and so I cannot login to the Management
Studio.

my first attempt at upgrading a sql 2005 RTM (9.00.1399.06) to a later
version (Entreprise Edition + SP2) failed. What are the correct steps for a
successful upgrade?
Thanks

I am trying to setup a development machine for Sharepoint development and am
installing Windows Server 2008, SQL Server 2005 and then MOSS on a virtual
machine
My original installation went fine and after installing Server 2008 I

I have tried to uninstall sql server like 3 times now, because the reporting
services was messed up.
I constantly get error -2147024893 failed to read IISMimeMap table.
then the uninstaller exits.  I have tried the reccomendations of msdn

I just tried to install SQL Server 2008 CTP5 (on a new Server 2008 Standard)
but almost every function failed to install. Only Full Text Search installed
without errors.
Now I want to uninstall this SQL server but I cannot because the first