A much easier way is to create a WMI alert on it and insert the values in a table .

Let me know if you need me to type in the...

forgot to add : before implementing LIPM cap Max memory of SQL Server to 75% of RAM via sp_configure .Else you will be in trouble ..

Regards

Abhay

If you call me and say "We have A/P clustered SQL Server 2005 EE(64 bit) with SP3." and then ask me to guess what issue you could be facing ,...

It would be very dificult believe me .You will achieve it but will spend a lot of time .....WMI alerts will surely help .

But instead you can try creating triggers...

Rohit ,

Looks like the isue is related to the FQDN .is HQ-BMC-D-1.tdic.auh a correct name or the actual name .Or its shadowing the actual name .

Other possibility could be the...

In 2005 no as you can rebuild the index online .

A bit of performance hit will be there as page level locks will be taken at the time the reorganization...

You can also remove it from registry and recycle SQL Server.

Russell,

If you want to manually failover in the case of any contingency then need not to create witness .Else for automatic failover witness is needed .

For your second question ,...

Give full permission to everyone on this file ..

Regards

You need to make changes in the Application string to point out to these servers .That should be taken care by the application guy .

Secondly , with log shippng there...

Its going to take the Sequence number as the starting point till the last sequence number and give you the rows sitting at the distributor to be distributed ...

Regards

Press ALT+CTRL+G or click view >> registered servers .

It will show you the list of registered servers and you can add more .

Regards

Because it runs with option like "with physical only".

Chack the Error log with same timestamp and see the complete command ..

Regards

Generally , if we do not use keep_replication option while restoring it should not be an issue .

Sad thing is that in 2005 , you will not see this option...

There is an option in some agent , i think its the merge agent .

That option is to ignore this error .You simply have to ad the error number in...