Thanks for the replies.....it was the Truncate log on chkpt setting....it needs to be set to off.

Does anyone have a good documented process for removing replication? I just tried running some of the system stored procedures that get rid of replication, but the error is...

I did. I deleted the publications and even disabled the servers as publishers and subscribers. I then set up replication again, but on a different database. The...

I looked at sysdepends, but it doesn't seem to show reliable information....on one of my most active tables, sysdepends shows that it is not read, updated, or used in a...

Is it a good idea to create statistics on columns that are not indexed? Is there a performance benefit to this, or is it not worth the effort?

If it...

Actually, I forgot one detail....I am trying to set up cascading updates on these FK's as well....your script works, but if you try to set up cascading updates with it,...

The error occurs every time I try the statement, and it happens through EM as well. I will try to reinstall SP2 and then contact Microsoft if that doesn't...

I am running SP2. (version 8.00.534)

Sorry about the delay in posting....answers:

1. Yes, I'm just trying to make the column nullable.

2. Here is the dump information from the error log:

SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005...

integer

We have already started using hints to lower the isolation level of read-only transactions. However, there is a problem; we have a lot of transactions that are read-only, but...

The application does use MTS/COM, and MTS handles all of the transaction management. Is this a design flaw? What is the best practice for transaction handling when using...

what about if I just wanted to return the joined table columns instead of all the text of the stored proc?

you are 'the man'.....

No, that's it....you answered my question. Thanks