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 |
|
maxald
Starting Member
7 Posts |
 Posted - 2007-11-09 : 04:20:15
|
| I am using sql server 2005 and my schema name has allways been dbo. But now this suddenly has changed to DOMAIN\my_username (don't now why and how). When I create a new sp the sp:s name will be domain\username.name_of_sp and as a result my webb application don't fint it (it says sp doesnt exist). My old sp:s start with dbo and works just fine.I dont find any way changing this schema name back to dbo and I cant get it to work with this new schema name eather. What is this schema name? I've tried to read about it on the net but its to advanced for me to understand. Please help me out!Thanks in advance. |
|
|
maxald
Starting Member
7 Posts |
Posted - 2007-11-09 : 04:34:55
|
| I find a solution! :) Under security/users/my account... right click properties... I could change default schema back to dbo. |
 |
|
|
|
|
|
Problem with schema name