He was definitely server support. At least for the model we purchased, I'd be a little surprised if it was intended for the SAN since it has 21 internal...

Do you have a link to support that? I talked to product info guy at compaq/hp who said that it wasn't supported...meaning hasn't been tested yet. If we...

Along these same lines, has anyone attempted to cluster 2 boxes that were not identical? We have a need for the active/passive because of the large amount of revenue...

I would set the @dbname variable = to the database your are in. Then I would create a string variable that would look something like this:

declare @cmd varchar(1000)

set @cmd...

Try running the profiler on your login while scripting the linked server.

Thanks to you both for contributions. Below are my findings:

--Look for a specific job and convert the jobid to binary, in my case the distribution agent

select name, convert(binary, job_id),...

The following is from MS KB article Q299903:

SQL Server 2000 provides the following stored procedures to assist in creating these stored procedures:

sp_scriptdelproc

sp_scriptinsproc

sp_scriptmappedupdproc

sp_scriptupdproc

sp_scriptxdelproc

sp_scriptxupdproc

Sometimes it is difficult to know which of...

Thanks Andy, I guess that confuses me even more as to why replication wouldn't promulgate the primary key definition to the subscriber tables. I would think the last thing...

I am interpreting your post as you need a trigger to fire that doesn't exist on the publisher table, but only on the subscriber table to perform some action that...

I appreciate your responses. In general, most of the inserts, updates, deletes done in our application are going to be less than 1000 records. We do have large...

Thanks for the replies. I think this KB article will have something that can help. I have not seen events 2020/2021. We are running Win 2k AS...

I too have been a victim of this error. Documentation as you mention is slim. In my experience, I had to stop the SQL Service. I have not...