I just setup a new server, Windows 2003 64-bit with SQL Server 2005 64-bit.
How can I install the management studio on either my Windows XP workstation
or another Windows 2003 server that's 32-bit?  Can I install the management
studio from the 64-bit media or do I need to get the ...

Is it possible to log on to two different servers from my CPU? If so how do I
configure it? two different domains?

I keep getting this error:
Details
Product: SQL Server
ID: 50000

Setup:
Windows 2003 Server +
SQL Server 2000 Std +
Navision Application Server

We do a daily full backup of our database.   We want to keep 4 weeks worth of
backups so we append each backup to a file called full.bak.  We are storing
our backups on a second Windows 2003 server which does not run SQL 2005
Server.  We accomplished this by creating a device with ...

I am running SQL 2000 and I just renamed one of my DB using:
alter database <OLD_DB> modify name= <NEW_DB>
The name of the DB did change when I look into the SQL server manager but
the name of  the data file and the transaction log on the HD are still the

I'd like to dig out the things/component/elements that would prevent sql
server 2005 express sp3 from successful installation.
-- The MSXML6 SP2 seems a big one if the XP machine has a version of sql
server already installed.   See this URL, for its status,  

I'm trying to install 2005 sql standard on my server.
I have a C: drive which only has a little more than 1gb available, and a D:
drive that has many many many gigs available.
I have selected everything for the install and it wants to install to the C:

I would like to know does SQL server support physical databases on
different drive?
For example, MyDatabase 1 on Drvie C and MyDatabase 2 on Drive D:
Your information is great appreciated,

I have a database written in MS Access which I've developed over 10 years and
deploy to the public from my web site.  After downloading, it runs an msi
which installs the database Front end/Back end on the users PC including a
shortcut on the desktop which can be used to launch ...

I've got SQL SERVER 2000 and 2005 database which are updated using an ACCESS
application.  The .MDF is around 5 gig and the log file recently got up to 25
gig.  To debloat the file, I:
-- change the Restore Method to SIMPLE

We have two processor licenses of SQL Server 2000 and are looking at
re-building the server.  I am unclear on the licensing, but assuming we
could run the 64 bit version the bigger problem seems to be finding the
media.  Anyone know where it is sold anymore, and perhaps more ...

When I'm installing SQL 2008 x64 Standard on Server 2008 x64 Standard i get
the following Message fom the SQL - Managed - Installer, before the GUI is
launching:
"Managed SQL Server Installer stopped working"

I've built an application using vb.net that runs against a SQL database.
Originally I developed it in a live environment using SQL 2005 express. The
SQL DB is on our domain server and clients connect. I've since upgrade our
DB to SQL 2008 Express and all OK.

Though there's a published workaround solution, see Aaron Bertrand's
thread, however, it's NOT a solution for those who distribute sql
server 2005 express.
I uninstalled SP3 for my XP home edition box last night, and used MS's