Goto the users property and check under the database membership

msdb | Security | Users | [UserName]

This works for me when I just want a count of a bunch of stuff....

Select

(

SELECT COUNT(tem.ComputerName) AS JavaRecords FROM (SELECT ComputerName FROM v_Java2345 UNION SELECT ComputerName FROM v_Java67)...

Execute As doesn't go outside the local database without extended authentication from the other database. It's scope is within the local DB. I only recently learned this myself. ...

Jason's script should work. Did you run it as is or add to it? Post the actual script that you ran.

You're adding a 3rd table which is not what you originally asked for. If "maincourses" is a 1 to many relationship then without restricting it to a single row...

Users can use shared datasets in SSRS. Depending on your budget SAP BusinessObjects is really nice for adhoc reports for end users as long as the admin builds the...

here's the DelimitedSplit8k function and you can read the article at:

http://www.sqlservercentral.com/articles/Tally+Table/72993/">

http://www.sqlservercentral.com/articles/Tally+Table/72993/

CREATE FUNCTION [dbo].[DelimitedSplit8K]

--===== Define I/O parameters

(@pString VARCHAR(8000), @pDelimiter CHAR(1))

--WARNING!!! DO...

Are you sure you're local admin on the SSRS server?

You still haven't told us what "limited access" means. Can you connect to the server? Are you getting an error somewhere?

Depends on what the sp is doing with the parameters. You'll need to post the script for the sp.

It's just the UI not refreshing. Just open the filesystem task edit and reselect the variable and ok out of the editor.

Select your variable from the package explorer and...

I've done that before :w00t:

Found it the same way.

On your filesystem task set delay validation to "True". This will get rid of the error or you can initialize the value of the variable to something.

From your original codes your 2nd insert won't insert into the [tblBulkPurchases] since the trans type is not "bulk purchase" so there's no record in the tblBulkPurchases with a "From...

Is usp_update the actual sp that you're editing? On your original post your vb is calling usp_updaterate. Nevermind I should check for more pages on a post.

Step through...