I think there is a need for you to forget about what table structure you use and analyse your data a bit more and organise things at the logical level....

If you have a connection to the server using Query Analyzer, running sp_who2 and sp_lock can show you if the process is stil running.

Hope this helps

Phill Carter

--------------------

Colt 45 - the...

How is your table structured? What indexes do you have on the table? What is the statement your are using to delete the record?

If you have a single field clustered...

What is the structure of tblHouses, tblCondoes etc...

Are they that different that you need seperate fields?

Can you post the complete schema for these tables?

Hope this helps

Phill Carter

--------------------

Colt 45 - the...

The batch file should reside in the same directory as the file you're pushing to the FTP server. If it's not there, then there is a problem creating the file....

Memory config in 6.5 is one of those black arts. You need to account for memory usage of connections, locks, etc...

I'm not too sure about the limit or instability though....

Do you have package logging enabled? What is the step that's failing? Also, you mentioned this is one of 400+ packages. What sort of workflow is there between these packages?...

If you have a downtime window. Detach and Attach will be the quickest method. You won't need to wait for database backup & restores.

You won't need to worry about the...

Where do you want the DTS package to execute?

If you want it to run on the non-SQL Server, install the SQL Server Client tools and save the DTS packages to...

Can you successfully execute a manual BCP or BULK-INSERT statement?

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

How are the users connecting to the database?

I've seen similar messages when using a proprietary ODBC driver. We had to purchase additional licences.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original...

Which "audit-log" feature are you referring to?

Another way to implement change logging is to access the database only via stored procedures and have the stored procedures insert change/deleted records into...

What is your definition of "registered users"? Is this just 100,000 rows in a table?

What security model are you currently using to access the database.

You could be able to...

You need to make sure the first row of data is complete, especially the last column.

Does your spreadsheet have a header row?

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point...

Can you post the contents of the batch file?

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface