Although I have an opinion on your approach, it's been said many times here that the most imporant thing is to be consistent in naming conventions. If you already...

Sure enough, the guest account had denydatareader.

Thanks a bundle.

Everett

I'd toss this mess in to Query Analyzer, comment out the Create Proc part, add code for anything that is passed in (not an issue here?), and start using the...

Hello.

Joins would be the correct way to handle this. If you'd like more feedback go ahead and post your query.

Everett

Quick note: the NT box needs at least SP5.

Everett

Hello.

I unfortunately don't have any experience with the DUMP command beyond BOL which suggests it shouldn't be used (GURUS: IS THIS TRUE FOR A ONE TIME SHOT?).

I ran the following...

Hello. From BOL (Books Online which can be found under Programs - Microsoft SQL Server)...

Updates an existing text, ntext, or image field. Use UPDATETEXT to change only a portion...

Hello.

One possibility is the MDAC version. Make sure that the Access host computer is running the same MDAC as the SQL server (MDAC 2.6 or 2.7)

Everett

Hello.

One possibility is to use a stored procedure for the more sensitive roles. A stored procedure can have more rights than the User executing it, and the stored procedure...

Sorry. It should be: exec(@CreateDatabase)

Here's hoping

Everett

Urk

Can you print out the @CreateDatabase and post it? I took your line, modified it

************************************

CREATE DATABASE test1 ON (Name = test1_db, FILENAME = 'd:\Program Files\Microsoft SQL Server\MSSQL\Data\test1')

*************************************

and had...

Hello.

The quick answer is replace

'size = ' + @DataSize + ')' +

'size = ' + @LogSize + ')' +

with

'size = ' + CONVERT(char(2),@DataSize)+ ')' +

'size = ' + CONVERT(char(2),@LogSize)...

Hello.

By default a Transform Data Task is set to 'Use Fast Load' which causes it to do a bulk insert. If you click off this option...

Hello.

Use CONVERT(char(2),@DataSize) and CONVERT(char(2),@LogSize).

If you print out the string @CreateDatabase you'll see that it's being treated as an integer.

Everett

Hello.

How about using trigger(s) to write the deletes to archive table(s).

Everett