Viewing 15 posts - 2,491 through 2,505 (of 2,635 total)
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...
Greg
October 6, 2004 at 12:55 pm
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...
Greg
September 30, 2004 at 10:13 am
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...
Greg
September 29, 2004 at 12:35 pm
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...
Greg
September 28, 2004 at 4:00 pm
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
Greg
September 28, 2004 at 3:39 pm
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...
Greg
September 27, 2004 at 9:52 am
Do any steps fail? Try logging all the package steps and examine the resulting log files to see what happens.
Greg
Greg
September 24, 2004 at 10:57 am
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...
Greg
September 24, 2004 at 10:55 am
Look at this article here on SSC. We've used it and it works well.
Greg
Greg
September 24, 2004 at 9:02 am
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...
Greg
September 23, 2004 at 11:51 am
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...
Greg
September 23, 2004 at 11:05 am
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
Greg
September 22, 2004 at 5:34 pm
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...
Greg
September 22, 2004 at 5:07 pm
Local packages are stored in the sysdtspackages table in msdb. You can restore packages by restoring msdb.
Greg
Greg
September 20, 2004 at 5:20 pm
Viewing 15 posts - 2,491 through 2,505 (of 2,635 total)