On your dataflow task properties you can change the Isolation Level to Read Uncommitted or you could put a NoLock hint on the lookup's select.

Since you didn't provide the code you are currently using I'll just give you what I would do:

SELECT

MT.equipment_name,

MT.total_cost,

SUM(DT.amount_paid) AS total_paid,

(SUM(DT.amount_paid)/MT.total_cost) * 100 AS percent_of_total_cost_paid

FROM

master_table MT JOIN

detail_table DT ON

MT.id = DT.id

GROUP...

Have you tried putting an explicit transaction in the procedure?

You can use the ReportingServices Web service to do this. Check out this article

IN 2005/2008 you could potentially solve this by assigning Execute Permissions to the user for the schema.

Grant Exec on Schema::dbo to user

Then the user will have execute rights any stored...

Duplicate post. Please post answers here.

What is @Year? I don't know of anything in SSRS that uses "@". Do you need to have a value there?

Brad,

I was also disappointed with the lack of details, which is why I output the entire row to the XML column. That way I can see the data...

At least in SQL Server 2008 (I assume 2005 as well) you can query sys.tables and check the uses_ansi_nulls column 1 is ON, 0 is Off. I don't have...

Don't worry we won't. We respect you too much:-D

No offense meant to Lawyers, I am friends...

The words "separation of church and state" do not appear in the constitution. Those words are taken from Thomas Jefferson's response, http://www.loc.gov/loc/lcib/9806/danpre.html, to a letter from the Danbury Baptists,...

Yeah, I didn't post it so it would be...

That's the great thing about...

Anyone else want to tell this guy NOT to shrink his databases?

Why are you shrinking your databases? This is not a recommended practice. Please read these blog posts:

http://www.sqlskills.com/BLOGS/PAUL/post.aspx?id=08f8fcc0-8ec7-4403-8257-2d6bf6293e73

http://sqlblog.com/blogs/aaron_bertrand/archive/2009/07/27/oh-the-horror-please-stop-telling-people-they-should-shrink-their-log-files.aspx

http://www.sqlservercentral.com/blogs/steve_jones/archive/2009/07/07/shrinking-the-log.aspx

http://www.sqlskills.com/BLOGS/PAUL/post.aspx?id=a2b9f8a7-ec99-43a5-b365-40143cbb9180

Those are just a few of many articles/blog posts about why not...