Skip to main content

How to assign db custom schema in sql server

Dear All,
In last days, i spend allot of time in identify the solution of assigning custom schema in sql server, specially when you restore any database which have a custom schema you face lot of problems here is the solution

1) Take a back of your database from online server
2) Restore in to destination place
3) Create a new user in SQL server (in Global security section)
4) Provide login name in Login Name section
5) Provide the password as you need
6) Select the default database that you restore
7) Click on the user map  (Left side 3rd menu)
8) In the restore db row select user under the user column and select schema under the schema column
9) save and close as well as disconnected
10) login with the new created user your schema will work

Regards
Rashid Bilgrami
CEO
Best visualization
http://www.bestvisualization.com

Comments

  1. Rashid Imran BilgramiJune 19, 2012 at 10:46 AM

    Thanks, now this blog objective is fulfills :)

    ReplyDelete
  2. Dot NET Development ServicesJuly 1, 2012 at 11:13 PM

    Are you using same credential in local as well as other db? Are they mapped to same roles in both cases?

    ReplyDelete
    Replies
    1. Rashid Imran BilgramiJuly 1, 2012 at 11:47 PM

      Schama is associated with the user and user is associated with the database.

      So if you allow the user to access the other database you can do that.

      I use for both cases but when you mapped the user with the defualt (db) schema database then it you must define the the db.yourtable name or db.yourspname

      i hope it helps you

      Delete

Post a Comment

Thanks for the Comments , Your review will display soon

Popular posts from this blog

How to convert and crack windows server 2012 from Evaluation to Full

Dear All This is a way how you Convert Evalution to Full Step1: Open CMD and run following command DISM /online /Get-CurrentEdition <edition ID> is like ServerStandard with out Eval Step 2: DISM /online /Set-Edition:<edition ID> /ProductKey:XXXXX-XXXXX-XXXXX-XXXXX-XXXXX /AcceptEula WINDOWS SERVER 2012 Serial Key Windows Server 2012 DataCenter: 48HP8-DN98B-MYWDG-T2DCC-8W83P Datacenter: Y4TGP-NPTV9-HTC2H-7MGQ3-DV4TW Standard: XC9B7-NBPP2-83J2H-RHMBY-92BT4 Standard R2: DBGBW-NPF86-BJVTX-K3WKJ-MTB6V Server Essentials: K2XGM-NMBT3-2R6Q8-WF2FK-P36R2 For Standard R2 here is a command For R2 its like that DISM /online /Set-Edition:ServerStandard /ProductKey:DBGBW-NPF86-BJVTX-K3WKJ-MTB6V /AcceptEula Regards
Post a Comment
Read more

SugarCRM Footer Logo Remove & SugerCRM violation Message Remove

Hi Reader, Let us discuss about how to remove the SugarCRM Footer logo.. You all are aware of the power of the SugarCRM Tool and also must be very eager to remove the footer in order to make it look more professional. So below mentioned are some tricks for removing the footer from SugarCRM Community edition. 1)  O pen-modules/Administration/ updater_utils.php Add-exit() ; in between   function check_now()   and   return . any where By doing this u can remove 'powered by sugar crm' footer logo. 2) Go to  modules/Trackers/Tracker.php, line 128, in the 'logPage' function. Drop the 'echo' statement. 3) Now to root(Sugarfolder)\include\mvc\view\sugarview.php and modify the line array(show header => true, show subpanel => true...........and so on) and make the changes to showfooter=>true to  showfooter=>false Now how you remove the violation  Go to include /utils/ mvc_utils.php and remove the line or code b...
10 comments
Read more

DNN 7 Won't go into edit mode or not working with control bar

Dear All, Today when i install the DNN 7 then i found and issue in edit mode after installation. The problem is when i go to edit mode the page refresh with out enabling the edit mode, after a short research on Google i found the solution. I hppe it save your time 1. backup your web.config 2. Open your web.config in a text editor 3. within the web.config file, find the <system.webserver><modules> section. 4.  If the <modules> section says <modules runAllManagedModulesForAllRequests="false"> change it to <modules runAllManagedModulesForAllRequests="true"> OR  if it just says <modules>, change it to <modules runAllManagedModulesForAllRequests="true"> 5. Save the config file. 6. Retry by refreshing the page and trying again.  You can also test this out by trying to a do a journal post (which also uses the services framework in an authenticated way. If some how its will not work then, you must chang...
11 comments
Read more