I need to update the catalog on my SQL 2000 box so our SQL 2005 64 bit box
will allow a linked server to be setup (query executed) and I know I need to
run the instcat.sql. My question is how will this affect my SQL 2000
production database when I do this? I have replication ...

I need to update the catalog on my SQL 2000 box so run distributed queries
from a 64-bit SQL Server 2005 server to a linked 32-bit SQL Server 2000
server and I know I need to run the instcat.sql per KB # 906954. My question
is how will this affect my SQL 2000 production database ...

We are running sql server 2000 locally and remotely (our web server in
another state) at my workplace.  On my old workstation I am using Sql Server
2000 management console/ Query analyzer... and can see all of our servers -
local/remote...

When I try to login to SQL Server 2005 from Microsoft SQL Server Management
Studio, I got following:
A connection was successfully established with the server, but then an error
occurred during the login process. (provider: Shared Memory Provider, error:

I am getting a SQLServerException:The statement must be executed before any
results can be obtained. The statement must be executed before any results
can be obtained. randomly when doing an insert of a table and needing back
the IDENTITY field.  It seems to be when server is ...

Hi experts,
As per the subject, can SQL Server 2005 SP1 'mirror' an Access database?
We have an Access database (associated with a commercial software product)
that is not particularly programmer friendly, and uses its own custom

This may be confusing but here's my scenario:
Server A is running SQL 2K5 x64 on Win 2K3 X64
Server B is running SQL 2K on Win 2K3 X64
Server C is running SQL 2K5 x64 on Win 2K3 X64