the import wizard inside SSMS uses sql integration services so you have to have that installed.

The Oracle 10 client should be backward compatible with Oracle 8

ensure you scroll to the very top

why not just allow the sql maint plan or job to delete files after N days

thats what i thought.

when the wizard starts, after the welcome screen the next screen is the choose data source dialog. Drop down the list box "Data source" and "flat file...

how are you importing?

are you importing via SSMS?

in SSIS create a new project. Drag a new "Data flow task" from the Control flow items. Edit the new "Data flow task" and in the Toolbox under "Data Flow...

filegroups offer managability but more over performance. They are primarily designed to be spread across disks\arrays and unless doing so are not going to be of any benefit to be...

i personally wouldnt boot from the SAN, i would have local disks for the OS, stick everything else on the SAN. You have many options available just be sure to...

Hi Andy

this was exactly the same line of thinking i had. Very informative. I think you're right no-one ever changes the default for stats during the create index

yes very important make sure you keep a copy of the enterprise system databases incase you need to bring them back online otherwise you'll need the install cd to repair...

not to mention the tone with which the words echoed to whom i would class as a well...

gunna48 (7/28/2008)

---

As far as I know you can only change the network name. Here is how...

sp_dropserver '[YourOldDatabaseName]'--Present Server name goes here

go

sp_addserver '[YourNewDatabaseName]','local'--New Server name goes here ...

on the very rare odd occasion and normally for older processor architecture. 99% of the time the...

not a s good as Kevin and Perry,, yes mrs patterson 😀