Thanks for all the replys.

Unfortunately, I didn't solve the problem, the same network error.

Principal server is domain1 which is located in production area. The production area has firewall.

Mirroring server...

Yes, same error.

the both server are in the...

Mayank Khatri (3/31/2009)

---

One thing in Mirroring is u have to set up your SQL server Agent and your SQL server under same account. Do it same thing with your Mirror...

If I ran these three SQL statements in one transaction, First returns nothing, second returns "col1".

Otherwise, both return nothing.

I didn't finish my post and accidently posted it.

I downloaded SQLIOSim and just slightly changed the default configure file to do stress test. I did two stress test, one...

I downloaded SQLIOSim and just slightly changed the default configure file to do stress test. I did...

My Fault!

It was not related to SP3 installation. We used to have one big physical drive which crossed two Arrays. And then this physical drive was seperated into three logical drives....

Actually, I applied SP3 at my new active/passive Cluster server and did test. Everything looks fine for SP3. But our SAN was broken somehow and every setting on both nodes...

WOW, So professional. I need time to digest the knowledge. I will response you back soon.

Thanks a lot.

Thanks For all your answers. I have use Adi Cohn's solution on my stored procedure. It works perfect and just meet my requirement.

Thanks. I will try my best to explain clearly. The resultset will always be sorted by "Rating" decending. but if same bookid has two rating, one is very high, another...

arun.sas (2/9/2009)

---

Tray this

simple

Create table #t(rating int,bookid int)

insert into #t

select 97, 201

union all

select 96,100

union all

select 95,300

union all

select 50,100

union all

select 10,201

union all

select 30,300

select a.rating,b.bookid from #t a, #t b

where a.rating...

Thanks all of you!

I am sorry to reply late because I am kind of busy on cluster configuration.

What I want is just order by rating descending, but if there...