AndrewSQLDBA (3/31/2013)
You can put any of the user databases on the box into single user mode.Why would you be developing against a production database? If needed, create a database on the same box, or install another instance on the box. You should not be developing on the same database that is being used as a production database.
Is this what you mean? I am not totally clear as to what you actually need.
Andrew SQLDBA
Dear Andrew,
Thanks for advice. The system I'm working on is an old database and now the owner asked me to add some more tables, making new joins, etc based on their new needs so I know it is not a proper situation.
To do my job, I need to work both on user interface app and database and it might take time so I want to be sure only I can connect to database to avoid disintegration of data.
Any suggestion will be appreciated.
Regards