Using vs2005 BIDS. I have found a procedure that creates an output table (eg: CREATE TABLE #Results (ColumnName nvarchar(370), ColumnValue nvarchar(3630)) then searches all tables and inserts results into this table. Eventually the results are selected. Is such a thing deployable to a SQL Reporting Service? Is there a preferred way of doing such a task? Am I able to create such a holding table on the remote server if I don't have special priveleges? geoff

geoff I do not think so, probably having data set and results to populate the table oe whatever. In order to create a table you need CREATE TABLE permission GRANT CREATE TABLE TO JoeBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/