I understand your overall point.

I would argue that SQL Server is not doing this since the query...

OK, thanks for the response. I guess there are two potential views on this setting:

1) Functionality that has been deprecated (or changed) in a newer version will be reverted...

Is there a list of these partially backwards compatible functionality changes documented anywhere?

Agreed that it is not optimal. However, that is a business decision and I have to deal with the current situation. There are technical reasons that an upgrade...

philcart (10/29/2007)

---

With more relevant field names we can get an idea of what sort of data is stored in them.

One thing I see a lot of is duplicate address fields...

Grant Fritchey (10/29/2007)

---

Honestly, one table... Why put it into a relational data management system? Assuming at least a good primary key, this can be accessed faster from a file than...

philcart (10/29/2007)

---

:w00t::sick::unsure:

Presuming the field names have been changed to protect the innocent, how about posting something a little less generic and we might be able to steer you towards a...

I realize this is an older thread...but came across while looking up some info about Aliases and Linked Servers.  One of the main reasons to use this approach was as...

Michael,

Thanks for your reply.  I have the SET XACT_ABORT statement in the stored procs.  Does not help.  The remote stored procedure returns a resultset after some complex processing.  I can...

David,

Thanks for the reply.  I have seen a number of articles on the issues with DTC Security changes with Windows XP/2003 and how to change the security settings to work with...

racosta,

It was not created with the NOT FOR REPLICATION property.  I don't think that is even possible since the "NOT FOR REPLICATION" property only applies to IDENTITY Columns, Check Constraints & Foreign...

I thought of that as well.  I ran a trace on the Source server (Publisher) and the Destination server (Subscriber).  The trace on the Subscriber shows the sp_MINS_XXX calls being...

Thanks for all the feedback.

I could not do a database detach because the database is setup for replication.

I ended up restoring an older version of the database and all is...

We do not have a Backup Application running on this server that looks at the database files. Also, we have disabled the Anti-Virus program, but we are still getting...

I have tried running sp_resetstatus(DBNAME) and then restarting SQL Server...did not help. I have also tried running sp_resetstatus(DBNAME) and then DBCC DBRECOVER(DBNAME) and I get the same error as...