Recently we started receiving the following occasionally during SQL 2000
backup windows:
Event ID 20
Connection to the target was lost. The initiator will attempt to retry the

I had uninstalled sql2000 then installed sql2005. I now receive the following
message in the application event viewer
login failed for SA (client 127.0.0.0)
Source: MSSQLSERVER

I have sql 2k std. edition, having one server, removed all the replications
using sp_removedbreplication '<Database name>',
and restarted sql server,
now when i restore the backup i get database with publiser created on it,

Newbie question:
select b.ABCD_TYP_CD,a.* from ABX_REQ_BUCKT a inner join
auth_req_iteM_hdr b on a.MKTG_ITEM_HDR_ID = b.MKTG_ITEM_HDR_ID where
b.rights_req_id = <name> and a.ABCD_SYS_CD = "TS" and a.auth_id =

I started running sp_delete_backuphistory before leaving work yesterday and
now 17 hours later it is still running. I know there where over 270,000
records in the backupset table so I knew it would take a while to run but
this seems too long. Should I cancel the query execution ...

I've got a table that I've added a computed column to.  That column is part
of an index.  As soon as I attempt to insert a row I get the infamous:
INSERT failed because the following SET options have incorrect settings:
'ANSI_PADDING'. Verify that SET options are correct for use ...

I try to setup WMI alert for BROKER_QUEUE_DISABLED
and i use following WSQL - SELECT * FROM BROKER_QUEUE_DISABLED
but receive error:@wmi query cannot be executed in @wmi namespace
provided.

hi, on 2000, i have created such job with stored procedure script(created on
msdb database), inside the SP, we defined job name, job step , job schedule
and job server, after created, i checked the step is  : EXECUTE
master.dbo.xp_sqlmaint '-CopyPlanName " xxx Log_Shipping" ' , ...

I have a production server which has about six user databases. Recently,
when I try to do a restore ( I wanted to see the available backup sets) on
any of the databases using Enterprise Manager (All Tasks -> Restore) it
hangs. However, it promptly brings a pop up window when I do ...

Getting errors on my backups, SQL 2005 SP2. Backups do complete successfully
however I'm getting errors in my App logs on my SQL Server.
During the snapshot part of the backups, these for lines appear in my SQL
Logs:

I copied SQL 2005 server (2CDs) to the hard drive, and named disk1 and
disk2. But when I finish the installation of disk one, I was not reminded to
put disk2. The screen always show " could not find the files in disk one",
but actually these files are stored in disk2.

Is there a way to disable SQL server 2005 from starting up automatically in
Vista?  It is not listed in startup tab in MSCONFIG or on any option
screen.. But the database always loads upon bootup.. I want to start it
manually only.. how do i do this?

Gurus,
Running SQL Server 2005 SP2.  I was wondering something about our company's
SQL Server 2005 installation.  Where is the original SQL Server 2005 install
LOG file kept?  You know, the one that kept a record of your installation

I am using SQL Server 2000. I backup database dbA in machine A. I would like
to restore this backup in another machine (machine B).
In Machine B I map network drive to machine A (say to drive X).
So, in Enterprise Manager on the SQL Server for machine B, I created a

I need to get some help with my T-SQL statements.  Basically, I have
the follwing
data in a SQLServer table and it looks something like this:
Current data: