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...

If you leave the databases in 8.0 mode you don't get the benefits of the additional functionality in SQL 2005. I'd change the compatibility mode, run Trace on the...

I wouldn't call myself a musician, but I play Bass Guitar. Contemporary Christian and Christian Rock mainly.

Please don't put in duplicate posts as folks will waste their time looking at both.

Original post here: http://www.sqlservercentral.com/Forums/Topic548775-149-1.aspx