Allen,

Looks to me like you've got the backups tuned as well as they can be. I can only offer some suggestions/experiences:

1. How do you minimize the data lost?

Reduce the...

Ritch,

First thing I'd follow up on is the "this has happened a number of times at various sites" bit. I've worked with SQL2000 quite a bit and seen a...

You cannot give the user ALTER TABLE rights on just one table, but you can give them db_ddladmin instead of db_owner.

You can try configuring the web sql as a publisher and a distributor. Don't allow anonymous subscriptions, but define your LAN sql as an allowed subscriber. Then try...

eily,

Are you saying that productfld is a comma-delimited list of product ids?

Noting that you say they only occasionally contain the prefixes, another option that will only issue updates against rows that fit the criteria is:

 

update...

Actually, I like your original example. For your requirement of returning all columns of the candidate rows I can't think of a better solution.

SQLBill may be referring to instances: a default SQL instance (eg. MyServerName) and/or a named SQL instance (eg. MyServerName\MyInstanceName). The default SQL instance listens on port 1433, unless (possibly)...

Did you mean STRIPING?

Striping is the splitting up of chunks of data into blocks that are written across the disks, thus taking advantage of multiple concurrent I/O paths, especially so...

The "executing by another schedule" message suggests that the STOP JOB instruction was not effective, which is what I feared because your host command (FTP activity) is hanging - most...

I find I usually get more indicative results by preceding each test with DBCC DROPCLEANBUFFERS

See the Change Log at the bottom: http://sqldev.net/xp/xpsmtp.htm

See "Cursors Data Columns" in BOL. Looks like you're out of luck in regard to the NAME of the cursor, but other information is available.

Sorry Grant. Still couldn't replicate it, using:

exec xp_smtp_sendmail

@to = 'myusername@myisp.com',

@from = 'mccork',

@attachment = 'c:\boot.ini',

@server = 'mail.myisp.com',

@subject = 'subject subject subject'

Maybe you're right and the NT SP and...

exec sp_msforeachdb 'use

select ''..['' + name + '']''

from sysobjects

where objectproperty(id, ''TableIsPinned'') = 1'