Qs) How to create a local version of the database if security permissions do not allow to copy a database in a sql server?
Ans) In this procedure the data will no be copied. Follow the steps: -
1) Right click on the Database name at server
3) Generate Scripts
4) Follow the "SQL Server Script Wizard" steps, step by step as required.
(A script will be generated)
5) Execute this script generated by copying it on a query window in a local sql server.
(All the tables, stored procedures & scripts will be created without the data inside it)