Keeping all data for disparate applications would be a hassle if you needed to restore only one app's data from a backup. Reminds me of my Oracle 7 days...

friend,

We can't see everything you put in the title of your post, so please ask your question in the body of the post.

RESTORE DATABASE database name WITH RECOVERY

When you add the job step that will execute the package, set the type as "SQL Server Integration Services Package". Then, you'll see a series of tabs. When...

More information about what you want to do would be helpful. Do you have a backup of the database?

Note that you'll have to change the column to a numeric datatype. You don't say if the current column has data in it that you want to preserve. ...

I believe the error number is really 15065. According to KB http://support.microsoft.com/?id=303879, you can create a maximum of 16,379 users in a SQL 2000 database. Do you really...

The BOL page I mentioned previously says, "The default trace log is stored by default in the \MSSQL\LOG directory..." and "The base file name for the default trace log file...

Yes. You may want to find info about SQL Agent proxy accounts. There's not much in BOL, but you can find articles and threads that talk about it...

You may be able to get the information you want by querying the defalut trace that is enabled by default in SQL Server 2005. It only keeps up to...

You can create configuration file(s) for the SSIS package that have the connection information for different servers. Too big a subject to go into here, but see "Package Configuration"...

I may not be remembering correctly how to do this in SQL 2000, but I think a non-sysadmin can only start a job he/she owns. A sysadmn member can...

No problem. I know what it's like to be not quite sure if I should try something!

It will only return results where ',[0-9][0-9],' is in the rightmost part of the column.

I don't think you'd need a linked server if it's on the same instance. Try creating the proc in master as

sp_rr_Get_ForeignKeyTables.