Menu
I'm currently building a database. The tables are all done and now I'm adding in my stored procedures. I'm also writing tests using tSQLt and Red Gate's SQL Test. Because of how this adds information to the database (each test is its own stored procedure, plus there are a large number of tSQLt stored procedures), I'm getting a very, very large number of stored procedures.
I'm finding that I'm scrolling up and down a lot in the Object Explorer window as I go back and forth between the list of tables (writing several tests for each table based upon its data structure) and the stored procedure list (when I need to create/update a stored procedure for a test that is failing).
I've already split out my Object Explorer and my SQL Test windows onto a separate monitor (Apple TV Airplay on a 55" TV FTW!), yet I'm finding that a little tweak could help me immensely.
Typically, I'm working in one range of my table list and one range of my stored procedure list, so that if I had two windows, I could set one to the relevant area of my table list and one to the relevant area of my sproc list, limiting or eliminating my scrolling.
Each time I try to select "Object Explorer" from the "View" menu, it simply highlights the currently-opened instance. Is there any way to get 2 of these? Is there any other workaround to get the same effect?
684
Object Explorer can only display up to 65,536 objects.
Object Explorer is visible in Management Studio by default. If you cannot see Object Explorer, on the View menu, click Object Explorer.
Just grab the Object Explorer windows and drag it until a blue cross appears. Continue dragging the window and point your mouse at the different points of the cross. This will display a greenish highlight within SSMS to show where the window will dock. When you have the one you want, let go of the mouse button.
Have you tried running two instances of SSMS?
73
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
