I installed visual studio 2005 beta 2.0,Sql server express edition should
be installed along with that.But it is not installed.So i tried to install
sql server express separately but it asked to delete .net framework 2.0 and
other previously installed sql server components.Then ...

We have multiple instances of SQL Server to support development and
testing of our applications.  But when I run the application from our
testing server, the wrong instance of SQL Server is responding to
queries.  I have set up remote debugging to find that the application on

   I am evaluating upgrading to SP4 on one of our main SQL2K SP3 servers.
The SP4 upgrade will only be to this single SQL2K SP3 server, but we have 2
other production SQL2K SP3 servers that it will need to talk to (linked
servers)

I would like to know if I can run all of the instances on my active/active
cluster over the same port (1433).  As I'm sure everyone knows, each instance
has a tcp port assigned to it when it is created.  I was just curious to know
if I could have all of them share one port to ...

I'm trying to setup SQL Server SP4 on a windows 2003 cluster, but the
setup hangs on the Validating User dialog box,  I've seen the sqlsp.log
file and it seems the program hangs when it stops and starts the SQL
service with the SCM.exe program. After 20 minutes or so, the program

Is there an easy way to transfer login accounts from SQL 7.0 to SQL 2000.?

Can you install SQL Server 2000 and 2005 on the same machine?  Can SQL Server
2000 and 2005 run at the same time on the same machine?
Thanks
David

Very strange problem here! Installed SQL 2000 on my Windows Server 2003 with
SP1. All went well. Got my DB working and clients connecting fine.
Went to connect a box in the DMZ via ODBC using TCP/IP on 1433 and it failed
to connect. Tried another box on the LAN and that wouldn't ...

i have configured sql mail in sql server 2000.
the mailid is also successfully getting tested.
but when i execute the xp_sendmail command
i get the following error

Hello --
I downloaded and installed
SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE
These 4 SQL queries in Query analyzer indicate that I still am at SP3

I keep getting this error when I try to instal Microsoft SQL Server 2005 CTP
june 2005 on a win2003 server upgrading a MS Sql 2000.
Please help.
I don't know what to do with the SQLACCOUNT and SQLPASSWORD specified in the

Hello --
Right-clicking Design Diagrams results in
"mmc.exe application error"
which is non-recoverable.

Hello --
If this is off-track, please suggest a group in which to post it.
I am using SQL Server 2000 (Management Console SP3).
I receive this error after clicking (LOCAL) (Windows NT), after

I need to understand transaction logs. I have an SQL server/application.
Every once in a while the application will tell the user there is an error
and that the transaction log is full. It then recommends backing up   the
transaction log.

Server environment:
Win 2000 server with SP4, SQL 2000 server without SP
Problem:
I apply SP4 on SQL Server and return error message "sp3_serv_uni.sql(1)".