• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 472
  • Last Modified:

Save database object with dbo instead of schema-Domain name + dbo

Everytime I save a view or object it adds my schema  like

\....\dbo....
How can I save a view as dbo owner without the long schema name ?

and if I have save it already how will I chanegre it? thanks
0
zachvaldez
Asked:
zachvaldez
1 Solution
 
DcpKingCommented:
"   create view dbo.fred as   "  instead of   "   create view fred as   "

should let you save it as DBO, assuming you have the right privileges. If not, talk to your friendly DBA.

To change a view, open it using the SCRIPT AS ... ALTER VIEW   when you right click it and change the  "   alter view myname.fred as  "  to  "   create view dbo.fred as  " and run the code
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now