Gianluca Sartori, thank you very much. It worked now.

I have some doubts here on this topics.. Can someone please give some lights on this?

1. Why Microsoft dont take actions on those actual dumps providers when illegal?

2. These...

Hi,

I found the solution. This was due the script was downloaded from the internet and it was blocked. so clicked the button to unblock.

http://epmframework.codeplex.com/workitem/4483

Thanks.

Hi azdzn

Thanks a lot. Good link to start with.

No, failover wont happen when passive node is rebooted as there is nothing to get failover to other nodes.

Sorry I have put it in wrong place.

I have put the hotfix log file here

11/18/2011 04:31:15.969 ================================================================================

11/18/2011 04:31:15.969 Hotfix package launched

11/18/2011 04:31:17.485 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"

11/18/2011 04:31:17.485 Registry: Read...

Did you just copy and paste the query and ran?

You need to change based on tables available in your database. I ran it and worked fine for me as there...

Try this..

select * from book where id not in (select top((select count(*) from book) - 5) id from book )

Thanks Gail.

The database size is 1.2TB. And growth rate is around 2GB per day. So around 120 days to fill the space.

Thanks a lot Ninja's_RGR'us. It is working fine now.

Good question

Failover is happening within a minute. I am testing by stopping the SQL server services of principal instance.

what about multiple rows in testing.dbo.users? mail will be sent sent to the first one. Rest will be missed.

Thanks a lot.