Lynn,

I couldn't agree more. I try to account for as much as I can get my brain around it. But sometime rely on someone else testing to make sure.

Thanks for...

Lynn,

That is for other than the US, unless that has changed recently.

ie: somewhere in south america and some places in Africa use 1/2 hours and 45 minutes.

Al

Why is that happening?

I am going to try Lynn's approach to see if that also triggers the problem.

Yes, I also noticed that doing it straight code you would get less problems.

I going...

Kathy,

Your solution to remove the RsClientPrint.* files from the Windows/System32 folder worked for me.

Thanks,

AL

RBarryYoung (4/16/2009)

---

The next installment is scheduled for the 27th, though Steve might move that up.

Also, there are many, many other opportunities...

Andy DBA (4/15/2009)

---

Bruce W Cassidy (4/15/2009)

---

[font="Verdana"]I'm not sure it would make much of a difference. You are still calling the email stored procedure sequentially, whether it is inside a...

RBarryYoung (4/14/2009)

---

RBarryYoung (4/14/2009)

---

neufeldb4 (4/13/2009)

---

Allow me to make some observations.

...

This is the type of problem I have seen in 100% of the articles like yours that claim the cursor is a...

RBarryYoung (4/14/2009)

---

RJ (4/14/2009)

---

RBarryYoung,

I would like to see how you can eliminate using a CURSOR or WHILE loop for sending emails using "msdb.dbo.sp_send_dbmail". My requirement would be to send email notifications...

RBarryYoung (4/14/2009)

---

longobardia (4/14/2009)

---

...

Now, I am no SQL Genius but I was able to formulate the following query based on the example:

select max(k.RowNum)

From (

select ROW_NUMBER() over (order by s.dta desc) as...

:-DMe three!

There is really nothing wrong with using cursors. If the application doesn't call for performance, YES cursors are quite easy to implement and everyone can read and understand them.

I myself...

One other one to add to the mix here,

a "training server".

In a previous post, I asked if you tested this scenario and you said you said, "Yes", with another person and hitting the submit key or whatever you are using...

Without seeing some sample asp.net code, it is hard to conclude or make a good assesment of the problem at hand.

Post some of the actual code and maybe we can...