dbo prefix getting attached while attaching a database file from the app_data folder
-
Hi i m relatively new to sql server and donot have a deep knowledge.
What Rutt is telling might be right but i m not getting how to achieve this
Let me again elaborate my problem
1.in my project there is is an App_Data folder where there is a mdf file
2.This mdf file is automatically attached to the running sql express instance when we open the solution and everything works fine
3.But the problem is i don't want it to be attached automatically and i dont want the databaase to be in app_data folder.
4.Instead i want to explicitly attach this mdf file to sql server express 2005 and modify my stored procs using sql Server management studio.
5.Now when i attach that .mdf file from the app_data folder to the sql express 2005 using management studio.Although it attaches successfully but it appends dbo. before every object in my database which i dont want because it breaks my code.
Before Attaching when automatically attached
After attaching to SQL server management studio
-
I am not sure you can change that because I have the same definition in the one I am running, I am running the developer edition which means no user instance. So I think when your ASPNETDB is a server instance the DBO schema owns both the database and everything in it.
Kind regards,
Gift Peddie -
Even if you could change it there really is no reason. If you look under the hood I'm fairly sure you will find that dbo owns the objects either way, this just happens to show you that it does. Every object is owned in the database.
Simple answer, this is not a problem and you should not try to solve it. If you do you WILL almost certainly trash your db..
CEWII
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply