Thanks for the suggestions. DTSBackup 2000 worked just fine.

Due to our new network being under construction, I was unable to get the Upgrade Wizard to work. It looked like a Network Permission issue.

I was able to detach the...

Hi Frank,

I'm getting the following error:

Server: Msg 5105, Level 16, State 2, Line 1

Device activation error. The physical file name 'J:\MSSQL\Data\Equifax_Data.MDF' may be incorrect.

I thought it might be a problem...

The table I'm working with is created with an Identity Seed of 39999999. Then it is loaded using source data from a Mainframe Application which has a unique 9 digit...

Thank You

Thank you.

I have a command-line VBScript (cscript) that runs for 24 hours without an index and 30 minutes with one. But if I leave the index on this field, it...

The only non-clustered indexes are on the tables used as input (select). The tables that have rows updated or inserted have one key field as an index. ...

Hi Frank, Please feel free to hook into any of my posts. I'm a developer with 20 years experience, but only 6 months of experience of SQL Server/ASP/ADO/VBScript/HTML and...

What a difference an index will make. Using a suggestion from a DBA, I added one

non-clustered index to one table and the VBScript processed a Recordset of 97,454...

Thanks MW.

I'm using stored procedures and the logic looks simple enough. Maybe 24 hours is as good as it gets.

Thanks to everyone for the help.