Anybody have experience w/ this freebie? I have been asked to ferret out
any unknown SQL2000 instances across the subnets our group is
responsible for, since maintainance EOL has been reached. Found this
tool which might be a useable approach but I do have some concerns.

Specifically in SQL Server 2000. We bought a small office (DOMAIN_A)
and need to convert the existing domain users into our domain
(DOMAIN_B). The AD admin is going to migrate the DOMAIN_A users into
our DOMAIN_B.

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