Doh! Wayne beat me to the punch... Silly me creating test data ;P

OK So, to break it down step by step to hopefully allow better understanding...

--do this someplace safe

USE SSCTest;

--Create my test tables

CREATE TABLE table1

(

crewmemberkey INT,

crewmemberid INT

);

CREATE TABLE table2

(

crewmemberkey...

I agree that we'll need quite a bit more to help you with this. If you read the first link in my signature, you'll see the kinda of data...

Also, make sure that you have distinct names for your columns in your dataset, as this error can be caused by that as well.

Any chance you're using subreports multiple times like is described in this MSDN KB Article? http://support.microsoft.com/kb/971049

-Luke.

You should be able to connect SSRS 2000 to a SQL 2005 database or really any other datasource that you can connect to through OLE, ODBC etc.

Also, you...

I guess my first question would be why does the report take 2 hours? IS it rendering time, or is that how long it actually takes the data to...

Yes absolutely. Additionally, you could look at BCP as...

I'm not really sure that who/when a subscription was deleted is logged by default. You'll probably have to check on it yourself either by a job like was suggested...

I don't understand the full depth of what you are trying to do...

Have you logged into the database with SSMS as that domain user? Were you able to log in successfully?

Have you tried to execute your dataset including using that TVF...

Are you certain that whatever login you are using in your dataset has the appropriate permissions (Select) to read data from your TVF? Make certain it's not in the...

Sounds like it's...

Yup, that's what I was thinking. Just was hoping to find a baseline that I can play around with. Perhaps I'll do a...

Good to know that my memory still works occasionally, and I appreciate the quick response. So to reiterate so that I make certain that I'm understanding... the < 25...