Can you create triggers on TRUNCATE and DROP on this table to insert details on the caller into some new table?

Designating the column as Primary Key causes it to be used as the base lookup of any indexes that are applied to the table (by default it is also clustered,...

I'll agree with you that Paradox9 and SQL do not get along well! Not building in a mechanism to access passworded tables into the ODBC driver caused me some...

If you have source code and ability to modify/recompile your program, you could consider having your code raise an error on the SQL server with a specified error number. ...

Make sure you are referencing the owner of the stored procedure when you call it.

Ex.: SqlDataAdapter.SelectCommand.CommandText = "dbo.my_new_procedure"

SqlDataAdapter.SelectCommand.CommandText = "my_users_enterprise_manager_DB_Login_name.my_stored_procedure"

Sounds like a concurrency / record locking problem.

Make sure you are committing or rolling back your transactions in the code (and closing your SQLClient.Connection when you are done).

While Norene is correct, there are other good reasons to separate your data files from your OS files, and a separate partition is better than the same partition, although a...

It is hard to make a recommendation without knowing what you are trying to accomplish.

You could DELETE the matching records from the child table first, this would allow you to...

For this purpuse, how about

IF Len(@a) Len(@b)

PRINT 'Not Equal'

ELSE IF @a LIKE @b-2

PRINT 'Equal'

ELSE

PRINT 'Not Equal'

...

If the table is empty, TRUNCATE TABLE user.tablename will do it as well.

I have found there are a few things to watch out for when moving your tables into SQL, but for the most part what you say should be correct.

Do not...

Sounds like a perfect example of where executing a stored procedure to perform the updates would be the best solution for security and performance. Do you have access to...

If you do decide to stick with Access, the functionality you are looking for is called linked tables. The basic steps required would be to export all your data...

I agree with the others, using the barcode as your primary key is a great idea, as long as it can meet all your needs. If you do use...

Is the file system on their PC NTFS or FAT32? FAT32 drives have a maximum file size around 2GB if I remember correctly. (Can't copy single file DVD...