Thanks. I was working on this last night in between sending e-mails to you. I got replication working again around 10PM. Everything seems fine this morning.

Robert W....

Another question. I can easily mark a subscription for reinitialization and then start the snapshot agent. My question is, after I do that will the subscription allow me...

I am planning to mark that subscription for reinitiallization and then start the snapshot. Unfortunately I must wait until 9PM to do this so I don't empty and/or drop...

As near as I can tell it was marked inactive at about 2:34PM today. What would cause it to get marked as inactive?

Robert W. Marda

SQL Programmer

bigdough.com

The world’s leading capital...

I like the new design.

I have found that when reviewing other columnists there is a link to see all their articles. However, when I click on my name. ...

Unfortunately, I don't know ASP nor js. As for VBScript, my focus has not been on getting data from SQL Server. This past week I began learning ColdFusion....

I also, would like to know how to get to the columnist page.

Robert W. Marda

SQL Programmer

bigdough.com

The world’s leading capital markets contact database and software platform.

Thank you very much for your response. The error number is never included with the failure logged by the DTS package. I read error 605 and believe the...

I have encountered the same problem. To get around it. I execute child DTS packages with an ActiveX Script task. The child package uses a global variable...

Thanks, so the slot number sounds like it is the row number.

Last night we finally were able to duplicate the error on a consistant basis.

What we have is a table...

Can anyone explain to me what the first part of the error means and/or if I can make use of the info to track the problem.

The first part of the...

I am not sure if this applies to our situation. We recently put SP 3 on our cluster servers. The version shows as: Microsoft SQL Server 2000...

Nice article. I was surprised SQL Server let me place the trigger on that system table. It blocks it for other tables unless you modify the table first.

Keep...

I know some of our servers use an account with local admin permissions, category 1. Probably all are like that.

Doesn't SQL Server need an account with local admin permissions...

I see no reason to use spaces for object names or column names. To me TableName is just as easy to read as Table Name and then I don't...