Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sent_sara
Constraint Violating Yak Guru
377 Posts |
 Posted - 2013-07-22 : 20:56:17
|
| Hi whenever i've created objects in windows authentication,objects were always binded with my windowslogin schema (ie) [munu].[Employee]incase of sql authentication ,objects were binded with dbo schema (ie) [dbo].[Employee]i tried to create objects from my windows authentication mode by specifying create table [dbo].[employee]. but itstill creates with windows schema (ie) [munu].[Employee]how to bind with dbo schema from windows credential? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-07-23 : 06:40:36
|
| In SSMS object explorer, expand the nodes and navigate to the security node under the name of the database you are interested in. Expand that, right-click on the user and select properties. In the dialog that pops up, change the default schema to dbo and click ok.It has the same effect as doing it using T-SQL, but is more visual. |
 |
|
|
sent_sara
Constraint Violating Yak Guru
377 Posts |
Posted - 2013-07-24 : 14:12:16
|
Thanks James and visakh16quote:
Originally posted by James K
In SSMS object explorer, expand the nodes and navigate to the security node under the name of the database you are interested in. Expand that, right-click on the user and select properties. In the dialog that pops up, change the default schema to dbo and click ok.It has the same effect as doing it using T-SQL, but is more visual.
|
|
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-07-24 : 14:23:38
|
| welcome |
|
|
|
|
|
|
Schema binding