Thanks A LOT! Worked like a charm...

For example I have the following data set:

For example I have the following data set:

1. It is indeed a stored procedure

2. Yes I did do a CheckDB to check all the data.

3. It is the only transaction that fails, the specific stored procedure updates...

Allready tried that.

Is there a method to polll the cluster service itself for this type of events? Preferably to the virtual machine.

Regards

Try to use Visio. It has EXCELLENT tools built in for this purpose.

http://office.microsoft.com/home/office.aspx?assetid=FX01085798

On very big tables it makes a HUGE difference in speed doing all comparisions in the joins. Especially if you try to join tables with 30 million plus records. On...

You can start by building your WHERE clauses into the JOINS, should make a significant improvement.

Remember these basic things:

1. When you do a normail SELECT * FROM Table, Table1, Table2 WHERE blah blah, in effect all the data is selected from the tables before doing...

Tr to use this script as in the SQL Books Online (SQL 2000). In the SELECT @maxfrag = 5.0 parameter you specify the maximum fragementtaion allowed as per object.

This will...

Please check this discussion:

http://sqlpass.org/Forums/messageview.cfm?catid=359&threadid=7275

It was eventually fixed up running this a few times:

dbcc checkdb (bwyzil,repair_allow_data_loss)

Could you perhaps give me the PSS number?

Andy,

Thank you for the help. So if I understand you correctly the identity column must just be manually recreated on the subscription database and it should work fine? What about...

Is the :: perhaps refering too something specific ?

quote:

---

I actually mean the database log.

---