I hear that!  It was easier to drive a car like that when all I had to pay for was rent, gas, and beer.

Greg

I've fallen back on my trusty '77 Chev pickup since my Toyota decided to blow a hole in the engine block. 

I'm afraid, as I've gotten older, I've fallen victim to...

We use a 3-part naming standard for data elements. 

part 1 - Entity prefix  acronym or abbreviation of the logical entity or physical fil that the element is an attribute...

Also, to be a "real DBA", you have to get some experience in addition to reading. 

Greg

Use the command line utility dtsrunui to generate the DTSRUN command with parameters.

I won't give you the details because Phill Carter gives a good explanation of how to use it...

Then back up the log now, if you haven't already.  Restore the full backup using WITH NORECOVERY, then restore the log backup using WITH RECOVERY and designating the STOPAT time.

If...

Antoine,

In order to restore to a point-in-time, you must have a full database backup from before the deletions as well as an unbroken chain of log backups taken since the full backup. ...

I've used the trial version of Embarcadero's DBArtisan and liked it, especially for multiple platform administration.  At the time, we had both Oracle and SQL Server and I could use...

I agree with Lamp.  You can't do this with the wizard.  You need to create a package.

The Transform Data tasks will execute serially if only one source connection is used. ...

Terry,

Can you give your users a web application that will execute the stored procecure? 

Exporting to a csv file without column headings is easy in DTS, but then you have to...

I agree with Dinesh and I'll add that, practically, the order of columns in a tabe doesn't matter.

Greg

Can you connect to the SQL Server using the SQL Server Agent login and run the package manually?

Greg

I'd use method 2 but omit dropping and recreating the primary keys.

Greg

Let's make it simple and say sysadmin.  Users and developers shouldn't be able to install anything on a production server.

Greg

I agree with Remi.  Use DTS and do the data conversion en route to the new database.

Greg