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

OLEDB jet 4.0 driver In Vista 64bit / he 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine

Well i think you must be thankful for me specailly for this research i am really getting the solution after 6 month research that is how to enable the oledb jet 4.0 driver in vista, i read arround 100s of articles and maximum said that is not possible to enable it and ala bla well at the end i got the answer that is so easy Acctually that is correct that oledb jet 4.0 driver is not avaialble for 64 bit but if you run your IIS on 32 bit instead of 64 then Oledb jet will working fine Here are the steps Click on the Start > Program > Administrative Tool > IIS Management panel Select the Computer name Right click on the application pool and select properties Select "TRUE" in Enable 32 Bit Application by default it is false Then this problem will resolve if you need any assitance then feel free to email me rashidbilgrami@hotmail.com Regards Rashid Imran Bilgrami CEO Best visualization www.bestvisualization.com
3 comments
Read more

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

C# Generate All Dates between starting and ending date

Dear Readers This code  will return a generic list of DateTime containing the dates between a starting date and ending date:  //Here is the function private List<DateTime> GetDateRange(DateTime StartingDate, DateTime EndingDate) {     if (StartingDate > EndingDate)     {         return null;     }     List<DateTime> rv = new List<DateTime>();     DateTime tmpDate = StartingDate;     do     {         rv.Add(tmpDate);         tmpDate = tmpDate.AddDays(1);     } while (tmpDate <= EndingDate);     return rv; } //Here you call this function DateTime StartingDate = DateTime.Parse("02/25/2007"); DateTime EndingDate = DateTime.Parse("03/06/2007"); foreach (DateTime date in GetDateRange(StartingDate,EndingDate)) {    Response.Write(date.ToShortDateString()); } And it will r...
2 comments
Read more