Hello--
We are setting up a new SQL 2000 server running on W Server 2003.
I am just trying to test the mail session profile and I get an error that
says:

I'm wanting to make a second backup that is sent to a machine other than our
server.  Is it possible to have SQL Server's Enterprise Manager (8.0) send
the backup to a mapped network drive?  It looks to me like this can't be
done but maybe there's something I'm missing.

I am doing an SQL Server 2005 Cluster install. The install appeared to go
okay. On the active node everything installed fine. However, when we looked
at the other node only the configuration tools got installed. SQL Server
Management Studio did not get installed. Would anyone ...

If running SQL Server 2005 32 bit on a 64 bit Windows 2003 OS with 8GB of
RAM, what needs to be done to allow SQL Server to address memory above 2GB?  
From my reading in BOL I thought we needed to enabling AWE in SQL Server
Management Studio and grant the startup account for the ...

I am running SQL 2005 Standard Edition on a dedicated Win2003 R2 Enterprise
machine. I have 8GB of RAM installed, but SQL server only seems to seize 3GB
(performance monitor only reports 38% memory utilization). Currently my
boot.ini looks like:

I have a process that I can't kill.  I've read online that the only way to
get rid of it is to stop and restart SQL Server which I think is lame.  Does
anyone know of a better way?  When I look at the process with STATUSONLY, I
get the following:

Howdy Everyone,
In SQL 2000, I used
SQL Enterprise Mgr --> Task --> Transfer Logins Task --> Source Tab (select
sourcce sql server name--> Destination Tab (select destinate sql server name)

I cannot open SQL Server Query Analyzer from Enterprise manager
I get the following error when attempting to open SQL Query Analyzer
from an opened database in Enterprise Manager:
-------------------------------

Hi all the group;
Recently we've bought two IBM Blade servers and we'd want to install SQL 2K5
Standard Edition to implement its brand new mirroring technology (one server
acting as 'master' and the other one as 'mirror' and then all the

is it possible to install sql 2000 developer and sql 2005 on same
machine? if yes .. what coul d he cases when i could need both of them
..or  any issue trying to put existing sql databases iam having in 2000
version?

I want to install a dedicated SQL Server database server. I suppose there are
certain recommendations for setting this up?
I suppose its not a good idea to install SQL Server on the same server as a
domain controller / AD? What are other options to share a machine to install

We need to move an existing 2000 Sql Server to a new box and are interested
in upgrading to 2005 at the same time.  Are there any KB articles or tools
that will help with accomplishing this?

 I have installed SQL 2000 & SQL 2005 in my windows 2003 server. SQL 2000
server is functioning properly with default instance whereas SQL 2005 is
running with a named instance. We are able to connect SQL 2005 from local
machine but not from the remote machine. It says that it ...

Trying to install SP1 on Sql Server 2005; my server is Win 2003 EE R2. I
want to run SQL Server DB mirroring in production. I'm being hit with a
failure that seems common to other people running R2. Database Services and
Analysis Services reports "Failed" on install.

I will be deploying a solution that will use SQL 2005 on the following
hardware :
2 x Dual Core woodcrest CPU   +  4GB RAM + lots of HD  (poweredge 2950 )
in an alternate location I will duplicate the hardware and hope to setup