My bad! I hit another sp, it works, amazingly like what I expect. Thanks lots.

ChrisM@Work (9/26/2012)

---

(CROSS) APPLY is ideal for this:

CROSS APPLY (

SELECT DueStatus =

case

When NextReviewDate < getDate() then 'Over Due'

When NextReviewDate >= getDate() And NextReviewDate < getDate() + 30 then 'Due...

Although no more replies here, I figured it out together with my colleague.

One thing that went wrong was the UDP port 1434 should be open instead of 1433.

Another thing...

I have made the udl working and got the right connection string:

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=AOR;Data Source=ISCSGCSTEST1\SQL_SGCS

When I used it in web.config, the page returns:

Keyword not supported: 'provider'.

I then...

I also tried to start profiler to monitor the server, unfortunately it seems it didn't capture any login request.

In order to verify that the profiler is working, on the server...

So far I haven't found a working connection string, it always returns me error like...

After further troubleshooting, I have manually enabled both servers' inbound/outbound 1433 TCP/UDP ports

My connection string is:

connectionString="Data Source=10.40.2.90,1433\SQL_SGCS;

I've tried:

connectionString="Data Source=servername\SQL_SGCS;

connectionString="Data Source=servername,1433\SQL_SGCS;

I got similar error message saying the instance couldn't be...

No problem ping the SQL server, BUT: telnet 1433 failed!

The firewalls for both the servers are turned off; netstat -an returns no 1433 is being listened. WHY?

Other than waiting and applying the...

opc.three (8/30/2012)

---

halifaxdal (8/30/2012)

---

To make things simpler, I feel this would be easier:

1. Instead of creating a fancy report, just create a stored procedure to generate a spreadsheet and use it...

I guess sp_update_schedule can sort it out.

Comment and better idea is always welcome. Thanks.

To make things simpler, I feel this would be easier:

1. Instead of creating a fancy report, just create a stored procedure to generate a spreadsheet and use it as attachment,...

Thank you! It works!

Thanks for this enlightening discussion. To get the right result for sure for every time, I think I better put an order by clause for every query I write?

Thanks guys, I realized adding "order by" can resolve the issue but was just puzzling on why the result was generated differently and why for each DB the sp always...