when you use a pst file as your Outlook mail store, SQL Server will use the file while it's running.

When you connect via Remote Desktop, you are actually creating...

Is this the entire query? Do you have other tables joined or a WHERE clause?

Can you put the query into a stored procedure and use the stored procedure as your...

This is one of the many questions covered at http://www.sqldts.com

http://www.sqldts.com/default.aspx?200

When you reinstalled, did you uninstall first? If not, try that.

Also, try re-applying the latest service pack.

In addition to Jeremy's comprehensive post, to run .sql scripts check out the OSQL utility in Books Online.

You might also want to check the date settings on the server.

Where, and how, does the VB executable run?

If you are using the Excel Application object to do things like formatting, etc... then no. Jet doesn't know about Excel properties.

Why are you using ActiveXScript? Why not use the inbuilt workflow?

When you define a dataset in Reporting Services you can manually enter the fields in the Dataset Properties dialog.

It's nothing to do with views.

Try this example,

Run the following in Query Analyzer,

create table tmp (a int, b int, c int)

insert into tmp values ( 1, 2, 3)

insert into tmp...

The reason for the error when running the estimated execution plan is because the procedure is not actually run, therefore the temp table is not created.

As I posted previously the...

So are you exporting data using BCP or the DTS Datapump?

For Deletes and Updates (which are actually deletes and inserts) the table will require a unique key to determine which record to delete.

There are issues with using temp tables in reporting services. It has to do with the way the meta data is returned. It should work if you manually add the...

Thanks for the response, but as I mentioned in my initial post, I can't delete all the records in the Production database.