Hi friends,
I have created database on Server.
For eg:Wealth
When i have created table in that database it gives me prefix as Wealth.login
which we when create table in dbo provider, it shows us dbo.login
iam very confused Plz help me out!
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Bryian TanPosted May 27, 2011, 9:14 PM
Have you try to modify the database owner or the table schema? You can transfer the Wealth schema to dbo.
http://weblogs.asp.net/steveschofield/archive/2005/12/31/change-schema-name-on-tables-and-stored-procedures-in-sql-server-2005.aspx
Suthish NairPosted May 27, 2011, 1:23 PM
Posted May 27, 2011, 8:08 AM
While creating the database where are option that you given?