How to add folders in SQL 2005

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)

How to add folders in SQL 2005

Author

Topic

rajkumarrai_bis
Yak Posting Veteran

78 Posts

Posted - 2007-06-13 : 19:42:10

does anyone have idea How to add folders in SQL 2005
thanks in advance

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-06-13 : 19:48:26

you can use xp_cmdshell and use command line commands to add folders.

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

rajkumarrai_bis
Yak Posting Veteran

78 Posts

Posted - 2007-07-03 : 04:24:44

Sorry for the late reply
I think there is some confusion here
I meant the Folders that we see in the object explorer pane of SSMS
Is there any way we can add remove folders from that

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-07-03 : 11:22:12

hmm.. not that I know of..

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-07-03 : 11:25:35

no.
what would you like to add?
what would they contain?

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-03 : 12:30:20

You can send to Microsoft's wish list for this.

rajkumarrai_bis
Yak Posting Veteran

78 Posts

Posted - 2007-07-06 : 21:21:18

I know for definite that this is possible
I want to add a folder which will list all the schemas in the DB

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-07-07 : 09:19:39

you know for definite that it's possible?
care to share with us where you heard/saw that?

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-07 : 11:36:38

I like to know as well.

KenW
Constraint Violating Yak Guru

391 Posts

Posted - 2007-07-09 : 16:28:59

quote:
Originally posted by rajkumarrai_bis

I know for definite that this is possible
I want to add a folder which will list all the schemas in the DB

If you know "for definite" that this is possible, shouldn't you also know how to do it, or at least know someone who does?

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2007-07-09 : 16:35:58

quote:
Originally posted by rajkumarrai_bis

I know for definite that this is possible
I want to add a folder which will list all the schemas in the DB

This already exists. Under a database you can choose

Security -> Schemas

And it will list all the schemas.

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.

rajkumarrai_bis
Yak Posting Veteran

78 Posts

Posted - 2007-07-09 : 23:44:07

got it
sorry to bother all you people
this really was a dumb question

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-07-10 : 01:37:04

it wasn't dumb. extensibility of SSMS would be great to have. unfortunately extending OE like this is not supported by MS.

There used to be an article on codeproject about doing it via some hacks, but it looks like it's been removed.

elsasoft.org

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources