Use a text qualifier. When importing, the soft sees "1886 stuart street, apt #515" as one column.

Referential Integrity maintained by the Server is much more performant than RI maintained by triggers, stored procedures or an application.

Auch, didn't look at the Forum, looks like this one should be moved too

Thanks!

Did some tests here and this is the solution i've implemented.

I have a dedicated table I lock exclusively. The other tables in the procedure are only locked when necessary, so...

I have a procedure that runs correctly at my system,

I have done this:

1. Command task: delete the old Excel File

2. SQL Execute task: CREATE TAB on a Excel Connection

CREATE TABLE...

Set the quotes as:

'SELECT * FROM tbl_Table

ORDER BY ('+ @orderby +') DESC'

This gives:

ORDER BY (Rank) DESC

Compiling can take a long time. It is indeed wise to place fixed or parametrized data-handling queries in a stored procedure.

I wonder if compiling time reduces when reindexing the Master...

A good practice for assigning rights to users for an internally developed app is the use of Application roles.

An application role grants rights at runtime.

It works this way:

1. User starts...