Did take a look there and did see a process on that database where the Command column showed "AWAITING COMMAND". Is that what would show on a RollBack?

Thanks Shalk and Frank!

Your suggestions were great. I went with a modified version of Franks example.

Dan

Thanks Frank, that did the trick for me!

Thanks Steve, I did just that and found that is was char(166).

Dan

Hi Jim,

Thanks for the reply. I tried a select * from table where column like '%' + char(124) + '%' and it returned no rows, so I don't think that...

Found the problem... I should have realized it earlier... both databases were going into an endless update to each other, once I initialized the update from database1, the trigger in...

Steve,

No, I am in database1 running an update on table1 - The update trigger fires, and should be doing an update to database2.dbo.table1 with inserted values. That's it... Doing the...

Yes, you can use the Max like:

Select StoreName, Max(Employee), Sum(Revenue) From StoreData Group By StoreName

The Sum() will sum all of the data by the grouping, and the Max() or Min()...

No, was not aware of it. I will save that info for the next time someone has this problem.

Thanks,

Dan

It's over now...

He decided to restore from backup and everything is up and running.

Would have been nice to know how to fix it though...

Thanks for the responses anyway,

Dan

Rebuild_Log did not work...

Right now when trying to Attach the error he gets is:

Could not open new database 'RSM'. CREATE DATABASE is aborted. Device activation error. The physical file name...

You can do a MAX() or MIN() on those columns.

Hello M,

Is what you are saying, I should be able to delete the record out of sysdatabases in master that refers to this database we are having a problem attaching?...

Michael

Ok, thanks. I got it working now...

Thanks again,

Dan

Dave, Thanks for the reply... I got it working through your suggestion along with looking at the Knowledge Base Bug Report 296769.

Thanks for the help,

Dan