Start with ALTER TABLE in BooksOnLine.

Greg

I trialed it a couple of years ago and the feature I liked most was being able to administer heterogeneous DBMSs with one console.  At the time, we had SQL...

Look in the backupmediafamily table in msdb.

Greg

I don't know if you can prevent dbo from changing the autogrow option, but I know that you can't prevent dbo from performing database backups. 

dbo is a member of...

You can actually name a backup file anything you want.  I've seen examples where full backups go to a file with a .ful extension and differential backkups go to a...

In the wizard, you'll see the options for appending, deleting, or creating the destination table on the "Column Mappings and Transformations" screen.  You get there by clicking on the elipse (...) in...

RTM stands for "Release To Manufacturing".  You're right, it's the initial release of the product before any service packs have been released.

Greg

I'll add that you can also restore log backups after restoring a differential, which can save a lot of time when restoring.  

For example, if you do a full backup at...

Do any steps fail?  Try logging all the package steps and examine the resulting log files to see what happens.

Greg

You can create a connection using the MS ODBC driver for Oracle, the MS OLE DB driver for Oracle, or Oracle's own ODBC or OLE DB drivers.  I used the...

Look at this article here on SSC.  We've used it and it works well.

Greg

http://www.sqlservercentral.com/columnists/jyao/makinggooduseofsysforeignkeystablepart1displaytabl.asp

It's not true that SQL Server must be started by a local user for full-text indexing to work.  We use full-text indexes on serveral databases on a server whose service is started...

An ODBC connection to Oracle would certainly make the DTS package simpler.  You wouldn't have to worry about adequate disk space for the intermediate text files and it would eliminate...

Generally, we install Windows and all of it's service packs and patches before installing SQL Server.  Here's an article that lists the order of installation:

http://support.microsoft.com/default.aspx?scid=kb;en-us;192710&Product=sql

Greg

How about this:

Create a new database role and add your user to the role.  Then add the new role to the existing db_datareader and db_datawriter database roles.  That takes care...