First no you will not need to have more than 1 package. The following steps should help you build a package for your needs and takes into account if the...

CHeck this out http://support.microsoft.com/default.aspx?scid=kb;en-us;Q281649 should be related and your explination.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

You cannot use BCP to export to an excel file. However you can generate a CSV (comma seperated value) file which Excel can iterpret. Just specify the file as .csv...

It should be but may miss items like references. To really get an exact duplicate you can perform a backup of the first DB and force restore over the new...

You can also use sp_depends to help with views to check their dependencies. Also I posted a script awhile back to go thru DB objects and help you find strings...

If you are running SQL 7 then the virtual logfiles inside the TL tend to not go away. Goto http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=26&CategoryNm=Maintenance%20and%20Management%20&CategoryID=1 and you will find a script to help you get...

I have never heard of any issue with LOCK_TIMEOUTS in regards to data. However I believe if you set it too low and the resultset has not returned you will...

Straight from the horse mouth so to speak

quote:

---

SET NO_BROWSETABLE ON is an undocumented option performed for Remote Data Service (RDS) ActiveX Data...

GLad to here you found the root issue.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Yes step 10 will not trigger a restore. You have to have "Restore Backup Set" as you set option with the restore type then click ok. Whne you do the...

Epol is right as even though the Parameter names are stored in syscolumns the defaults are not stored with them. The only place is syscomments to find them.

"Don't roll your...

Actually there is I believe a script in BOL that you can execute afterwards to do all the reindexing. Most of the items like DBCC DBREINDEX are also real easy...

Sorry currently do not find a whole lot on this at all that is related. What does this package do?

"Don't roll your eyes at me. I will tape them in...

What do you mean reorg tools to be sure I have the right concept?

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

I do believe that each triggers a commit and you cannot rollback. Might try pushing data to a import table if is an import and then handle the move of...