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 |
|
eraashishgupta
Starting Member
1 Post |
 Posted - 2009-05-30 : 15:44:55
|
| Hi all,I have a mdf file which i m attaching to my sqlexpress using management studio.The problem is i copied it from the App_Data folder in asp.net when using the AttachDBFile property everything works fine as it is using windows authentication by defaut.But when i copy the same mdf file and attach is in sql express explicitly and add a user called 'dev' to this database then an additional string called dbo is attached in front of every stored procs and thus my application is unable to fine the stored proc for example the actual stored proc name was 'Bugs' but after attaching it to sqlexpress the name of the stored proc is displayed as dbo.Bugs and i cannot also rename this because when i rename it shows the correct name.Please can you tell me what wrong i m doingHelp is highly appreciated.thanks in advance.Aashish Kumar Guptahttp://smallworkarounds.blogspot.com |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-31 : 06:36:56
|
| why dont you assign dev to dbo group? or change the ownership of all objects from dbo to default schema of dev? |
 |
|
|
|
|
|
dbo prefix attached by default how to remove this