Thanks for this script!

As the agents of technological change, we are in positions of privilege and power that can blind us to the reality that there are many people without the capacity for...

Vormetric offers a very interesting and easy to manage product.

http://www.vormetric.com

No, according to this 2005 thread, the availability of a linked server isn't testable using pre-Yukon TSQL.

http://www.sqlservercentral.com/Forums/Topic109509-8-1.aspx

Thanks - My apologies for not noticing I was in the 2000 forum.

This looks like a good solution for environments where the command shell is permitted.

I need a solution that doesn't use the command shell.

Agree with jpowers. Additionally, if the API is robust and provides function overloading the problem of drowning in discrete modules can be ameliorated.

Thanks much, Roy - problem solved.

Carl

Thanks, Roy.

OK, I've removed all vestiges of the "Replication agents checkup" job,

but when I execute sp_adddistributiondb I still get the same error.

I notice that I still have jobs:

"Reinitialize subscriptions having...

Thanks - that makes sense.

Sorry I didn't note from the start that the query works just fine in QA against the SQL2005 instance.

The source tables have identical data.

I agree that 200K records is a bit much - the application was built solely to extract records and write them to a flat file....

Thanks to all for your help - I appreciate it very much!

Carl

Thanks! Sorry I wasn't explicit about the load method - I use bulk insert to get the raw data into a non-indexed table in another database, but then use INSERTs...

Thanks - yes I was aware of this oddity. My perplexity stems from the lack of information on what to expect from a fill factor of (for example) 98 in...