Nope never figured it out, it turned out that we had to write our reports in aspx anyway, the client refused to upgrade their hardware. They had an ecommerce site...

is that the right article number? I can't get that article at support.microsoft.com

OK since no one has responded I'll give some more detail. I'm writing a web app to pull requested reports into it via url access into an iframe. One of...

#temp should work fine now, it is going away with Yukon however, all temp tables will need to be @temp instead..

That is most likely not the issue

i dont think that's it you would have gotten a sql error if it was, can't think of anything else besides making sure that all the fields are not on...

hmm i'd delete the dataset and start over..sounds like some field has a format being applied to it and it isn't passing that format action, could be a cast inside...

in the parameters tab delete your parameters, on the main tab make sure it has Stored Procedure selected and your text it just the sproc name. then leave everything else...

I have that problem with #temp type tables, however on stored procedures using temp tables like so (declare @temp table(name varchar(30), phone char(10)) i haven't had the same problem.

remember #temp...

I haven't seen these errors, have you tried just editing the dataset down to only information on that first tab? Don't give it the parameters at all, then hit the...

Yes you'll need every column and in similar/same datatypes as well.

I love the article, straight forward, etc. I've read a few upgrade articles recently because a client is upgrading from SQL 7 to SQL 2000. I've been running their database...

Yeah I agree on that, I try to keep it simple as well, I think it's more because of the size of the database and the amount of transactions it...

Yeah I've been moving that way myself, was hoping to save some time with this but I think i'll just use some inline statements in my dal or sep sprocs...

GRRR...

I'm at my wits end with this, plus im getting very hungry. Anyway so far I can't find any documentation online about programming the snapshot generation. So far I am...

Yeah the problem was knowing what table i was curently working with, here's what I am doing for it, worked pretty well.

Function Main()

Dim oRDB 'As SQLDMO.ReplicationDatabase

Dim oDb 'As SQLDMO.Database

Dim oPub...