antonio.collins (8/8/2008)

---

depends on how many reports he has to do and when they have to be done. since the sql is coming from existing code, making 'improvements' may open...

antonio.collins (8/8/2008)

---

you do realize that if you'd go back to your original code and replace @holidayTbl with @HolidayTbl (as...

Just to pile on, I agree it was an interesting article and cleared some things up for me. It has been a few years since I have looked a...

Can you post the error message you are getting? Are you getting the error in BIDS/SSRS or iin SSMS/Query Analyzer?

Since you are asking I will tell you, but it is generally not the best idea to give everybody rights on things.

Grant Execute on [procname] to Public

Everyone that has access...

I'd take the whole thing and stick it in a stored procedure:

[font="Courier New"]CREATE PROCEDURE report_name

AS

DECLARE @StartDate SMALLDATETIME,

           @EndDate SMALLDATETIME,

           @Range INT,

           @HolidayCnt INT  

DECLARE @HolidayTbl TABLE (HolidayDate SMALLDATETIME)

--...

I don't really have any experience with BCP or Bulk Insert. I do avoid using xp_cmdshell because it can be dangerous and on my 2005 servers it is disabled,...

I think Jeremy's post really answers your first question. The formula for autoupdate was probably not being reached. AS far as your next 2 questions, I don't have...

I think it might be that you are running the 32-bit DTSexec. I don't know for sure, but that certainly sounds right. Are you running ht epakcage on...

Good catch Matt, I don't enough experience in Access, for which I am thankful, to have experienced that.

rbarryyoung (8/7/2008)

---

My oldest son is a Bass Guitarist. I met...

What events are you profiling? I would check the locks and lock timeouts and blocking. You could also run sp_who ro sp_who2 which will show if your process...

Steve Jones - Editor (8/7/2008)

---

Jack,

Write me a few articles this year and we might fund your trip. We usually get a couple free admissions to PASS, one going to Jeff...

64-bit or 32-bit? I'm guessing 64 and I think this thread may have your answer: http://www.cooldevelopers.com/program/656/76656-cant-aquire-connections-because.html

Make sure that if you get the answer here you post it on the...

In SQL 2000, I don't think there are any ways to determine who had been on the server in the past unless C2 auditing is on. In SQL 2005...