default schema SQL Svr Mgt Stdio / 2000

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

default schema SQL Svr Mgt Stdio / 2000

Author

Topic

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2007-09-05 : 14:57:28

Hi,

I have SQL Server Management Studio and SQL Server 2000.
What I want to know is:

Is there any way to prevent displaying default schema or owner, when viwing the "tables list" in the object browser?

eg. Instead of
dbo.MyTable1
dbo.MyTable2
....

I want to view as

MyTable1
MyTable2

Thanks

Srinika

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2007-09-05 : 15:47:56

why? what if you have the same object name but different owners? how will you identify which is which?

in any case.. I'm not a guru and I don't know the answer to your question... just dropping my 2 cents hoping someone would pick them up

--------------------
keeping it simple...

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2007-09-05 : 15:52:14

HI Jen,

I just want to view.
In my situation, all the objects are of dbo and I (My Manager) don't want to see the owner name in front of objects (tables / Stored Procs ..), when viewing the objects list by object browser.

Srinika

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-05 : 22:20:12

Then you should use sql2k em instead of ssms.

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2007-09-06 : 07:08:14

rmiao,

You mean, it is impossible in ssms ?

Srinika

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-06 : 22:27:24

That's by design.