Hello,

I read your article with interest, because I have to solve similar problem recently. Both solutions are interesting, and both were considered when I was going to write this part...

Sorry, I may be sound stupid, but I did not understand you phrase "database the dropping with stop because your user is now in SQL Server".

Do you suggest that...

Let me get it stright

What you suggest is

1. enable client's databases to accept either Windows OR SQL Server login

2. create config file with valid login, which would be accepted...

I probably could not explain properly.

There are more than 10 users, all of which have their own databases and client applications

All those databases have Windows authentications, none have extra files...

Thanks for your reply

It is winform application.

The user CONNECTED on the first place to the database, using the same connection string. It means, that he has right to connect....

Thanks, everybody.

I believe the filegroups options will not be OK for me, because I will need to restore not one or two tables, I will need to restore number of...

Can you, please give more details?