| Author |
Topic |
|
Lumbago
Norsk Yak Master
3271 Posts |
 Posted - 2007-12-11 : 06:04:00
|
| I know that this probably is a longshot but do you guys know if it's possible to make feature requests for sql server management studio 2008? Maybe you MVP's can do it? hehe...My idea is this: I often deal with somewhat large databases with quite a few objects like a few hundred tables/views/procedures and I think it would be *reeeeely* handy to be able to group some of them together in folders with custom names. So if I have 15 procedures that deals with customers I can make a "Customers"-folder within the Database -> Programmability -> Stored Procedures folder and put them all in there. This should have absolutely no impact whatsoever on the naming of the objects in sql scripts and such, only a logical grouping as an aid to easily finding the right objects in a reasonable time. What do you think...??--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-11 : 06:08:20
|
Use schemas?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2007-12-11 : 06:10:51
|
Yes schemas.... and if you run your sprocs from jobs then you can also manage them by using categories for the jobs.Duane.  |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2007-12-12 : 06:17:32
|
| Umh...I haven't used them much to be honest but they were not exactly what I had in mind. As far as I know you have to use the schema name when referencing the object don't you? And even though they are sorted in the same location you still see all the objects when expanding i.e. stored procedures. I was thinking more in the lines of dragging and dropping objects in to folders without having to change basically anything at all. Sort of like arranging layers in Photoshop if you guys know how to do that...--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-12 : 06:24:28
|
Ask Mladen, aka Spirit1, if he can cram this request into his ToolPak.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2007-12-12 : 06:38:19
|
| Spirit's making a toolpack? I'll have to check it out :)--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-12-12 : 07:46:09
|
| yes. check my sig.don't you read my blog?? heretic... go and subscribe right now!_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2007-12-12 : 07:51:32
|
So what do you think about my feature request??  --Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-12-12 : 07:54:53
|
| well i can take a look at how difficult that would be to do... probably quite _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2007-12-12 : 08:49:40
|
| Hehe for a Cybernetic Yak Master like you I'll bet it's a walk in the park --Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
|
SSMS 2008 feature request??