My purge run on Sunday night and I have a DBCC CheckDB every day at 04h30 am.

So, the DBCC CheckDB run correctly.

Thanks for the reply.

Is it possible that a lock on a table or a row by a user cause the difference between 1 minute to rebuilt and 3 hours.

Because 3...

Ok.

I understand now.

So I can give to my Windows login the right to select the data and to my application role the right to select, update, delete and insert.

So, my user...

Hi.

I have some difficulty to understand the difference between Application Roles and a SQL Authentication. For exemple, if in my application I'm connecting to SQL with a SQL Login and...

Finally, it's more secure to use SQL Authentication then Windows Authentication ?

For the Windows authentication, even if all the Insert, Update and Delete statement are in a stored procedure, the...

Thanks Julian for your information.

But, do you have another way to secure Windows Authentication from other application ?

For exemple registy, NTFS, .......

Normaly I place Insert, Update and Delete statement in...

Forget it.

I made a silly thing.

With your reply, you helped me to find my error.

Sorry guy.

Hi.

I tried the procedure that has been given over and it did not work.

On the @DBFPathandTableName variable I put the path and the path with the filename without success.

SELECT *...