Enterprise Manager substitute for SQL 2005+
-
I know I can't connect to a 2K5/2K8 server using Enterprise Manager... but is there any other tool that can replace it and have the old look/feel? SSMS Drives me absolutely nuts for trying to quickly pull up information about a stored procedure. It's just so unwieldy. Navigate down in the object browser, then switch to the details window, browse all the way down (I've found the whole filtering system extremely annoying thus far) to where I need to be, try to remember not to double click the SP (Or it'll go to a parameters screen and when I hit back I'm back at the top of the list and have to find it again), right click, modify, go to another window all together and find out if that's the right SP or not. Between all the window switching and everything else I've already screwed up which database I was in a couple times. The entire flow is off. I'm honestly almost at a point where I'd rather write a script to pull the text of the SP out rather than trying to use the object browser.
Assuming that such a tool is not available, is there any way to make SSMS Object browsing suck less?
-
Navigate the tree view in the Object Explorer to the proc you want to look at, right-click it, and select Modify.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
-
The only things that comes to my mind is Toad for SQL and ApexSQL Edit. Haven't used Toad, so can't give you an assessment of the product. I managed to get a free copy of ApexSQL Edit, but I feel more comfortable with SSMS.
-
GSquared (12/16/2009)
Navigate the tree view in the Object Explorer to the proc you want to look at, right-click it, and select Modify.I can't. I have too many SP's.
Posted by Microsoft on 9/22/2008 at 5:02 PM
The current limitation of 2500 items expanded in one Object Explorer Node has been put in place to prevent the Tree View Control from exceeding the 64K limit when multiple Object Explorer nodes get expanded. The Windows XP and Windows Server 2003 version of the Tree View control has a bug where it just stops displaying nodes once the total number of nodes exceeds 64K.Object Explorer Details window can be used to see the entire list of items - it doesn't have the above limitation. Users can see the list by clicking at the informational node that displays the warning in the Object Explorer. Object Explorer Details duplicates most of Object Explorer functionality including all the context menus.
We are reviewing the customer feedback and considering adjusting this behavior one more time. Please let us know if you'd prefer the old behavior back or if you have any other suggestions.
-
persevere, you'll get used to it!
---------------------------------------------------------------------
-
I didn't even mention that the Object Explorer Details tab has another bug with multiple monitors where it puts your right click menu on your primary screen regardless of which screen it is on.
-
Seth you could give LINQPad a try, since it is free;
I like it because i can carry it in a thumb drive; added it to my PortableApps collection;
it's got a basic version of EE/object Explorer that might fit what you want:
it's got some quirks, but generally it's a good tool.
i found that if i create a table ie #sp_whoResults, and then try do do something like
INSERT INTO #sp_whoResults
EXEC sp_who
it always runs the execute statement, and ignores the inser tinto, so my temp table is still empty;
for 99% of what i do, when i can't get to SSMS, it's helping me out a lot.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
I've used Apex SQL Edit. It works. Might do what you need. Haven't used TOAD, but from what I've heard, I'm probably not missing much.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
-
Lowell (12/16/2009)
Seth you could give LINQPad a tryAwesome idea. I actually have LinqPad already, but I never considered using it for that. I mostly used it to try to hack together queries in LINQ for our web person until I finally convinced everyone that it was a bad idea.
I'll give it a shot.
As far as Apex goes, I just convinced my boss to buy me the entire SQL Toolbelt, so I don't think I can justify $900 with 'SSMS is buggy and annoying'.
-
Garadin (12/16/2009)
Navigate down in the object browser, then switch to the details window, browse all the way down (I've found the whole filtering system extremely annoying thus far) to where I need to be, try to remember not to double click the SP (Or it'll go to a parameters screen and when I hit back I'm back at the top of the list and have to find it again), right click, modify, go to another window all together and find out if that's the right SP or not.Why switch to the Details window? I never use that thing. I have the startup options in SSMS set to never even open it.
Tip: to quickly get to a procedure in the Object Explorer, click on the first procedure in the list and start typing the name of what you're after. In a list of thousands of procedures, you can quickly get to dbo.MyProc by simply typing 'dbo.myp'. (Here's hoping you're not stuck somewhere that still thinks prefixes like 'usp_' are still a good idea...). At that point, you can use arrow keys and Page Up/Page Down to get to the proc if you didn't get all the way to it. Once selected, Shift+F10 opens the context menu, then S, C, N (Script procedure as... CREATE to... New Query Editing Window).
Eddie Wuerch
MCM: SQL
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply