|
|
|
SSCrazy
      
Group: General Forum Members
Last Login: Yesterday @ 3:27 PM
Points: 2,692,
Visits: 1,075
|
|
Nice short article. Unfortunately Management Studio runs like a dog on my PC so I still use QA quite a lot. Also, in a Master/Target server scenario, the master server has to be SQL 2000. You can't enlist a SQL 2000 server with a SQL 2005 master, but vice versa works. I'd also be interested in how many 'developers' use Management Studio now that Visual Studio 2005 Team System for Database Developers is out in the wild.
Hope this helps Phill Carter -------------------- Colt 45 - the original point and click interface 
Australian SQL Server User Groups - My profile Phills Philosophies Murrumbeena Cricket Club
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: Tuesday, May 21, 2013 3:06 AM
Points: 1,026,
Visits: 751
|
|
You can set the options to comment in the options pane - set it back to the old shiftctrl C if you want. Oh - and btw - to UNComment (or Restore) text, try shiftctrl+R... Now, how do we adjust the size of the results pane (ctrlB...?) 
|
|
|
|
|
Valued Member
      
Group: General Forum Members
Last Login: Monday, April 22, 2013 3:38 PM
Points: 67,
Visits: 143
|
|
Also you can't hide/show query results. There is a button for that in QA.
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: 2 days ago @ 9:15 AM
Points: 1,002,
Visits: 510
|
|
I say, unless you are using SQL 2005, don't switch. The new tools got a TON of bugs. What happened to the "script database objects" feature? I gotta do it all separately per object now? Why does SSMS not save my password change when I change the password for the login on SQL Agent Properties / Connections? Why does SSMS use so much damn memory on my machine, and leak memory too? My advice: Stay with EM until Microsoft fixes SSMS a bit more. SSMS is a powerful tool, just not a quality powerful tool.... at least yet.
A.J. DBA with an attitude
|
|
|
|
|
Mr or Mrs. 500
      
Group: General Forum Members
Last Login: Wednesday, April 03, 2013 10:05 PM
Points: 584,
Visits: 1,571
|
|
There's a button in MgmtStudio as well, but you need to customise your toolbar and add it. It's something of a large button, and it says quite clearly "Hide Results Pane".  As to bugs, our DBA has put the kybosh on using it with SQL2K databases/servers, due to it's not being designed for/tested with SQL2K. I can see some merit in this thought. For me though, Management Studio was just one of the Three Amigos, along with EM and QA. I used the tool best suited. S.
|
|
|
|
|
Valued Member
      
Group: General Forum Members
Last Login: Wednesday, July 25, 2007 12:59 AM
Points: 68,
Visits: 1
|
|
One thing I do not like is that you cannot create a new SQL2K DTS package using Management Studio. Other than that I am slowly getting used to the new tool.
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Monday, December 27, 2010 10:56 AM
Points: 9,
Visits: 33
|
|
| How does one manipulate user permissions for SQL2000 in SSMS? In EM, I could right-click on an object and edit what the groups could do, or right-click on a group and edit what they could do with which objects. I know that SQL2005 uses Schemas for this sort of thing now, but how does one use it with SQL2000?
|
|
|
|
|
SSC Rookie
      
Group: General Forum Members
Last Login: Monday, May 20, 2013 6:03 AM
Points: 33,
Visits: 759
|
|
Permissions for SQL2K can still be edited in SSMS, just have to go one level deeper. Right-click on the object, select Properties, then select Permissions. It is more of a Windows network type of process (search) for working with permissions, but very similar.
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Wednesday, March 13, 2013 10:51 PM
Points: 161,
Visits: 301
|
|
SQL2005 objects are still owned by people, it's just that the ownership is hidden slightly by the fact that objects are also in schemas. In fact, I have another article in the works that talks about ownership chaining issues and 'execute as' to address this.
And as for hiding the results-pane - Ctrl-R still works.
For editing DTS packages, get the feature-pack with the SQL Server 2000 DTS Designer Components.
Rob
Rob Farley LobsterPot Solutions & Adelaide SQL Server User Group Company: http://www.lobsterpot.com.au Blog: http://sqlblog.com/blogs/rob_farley
|
|
|
|
|
SSCrazy
      
Group: General Forum Members
Last Login: Today @ 1:31 AM
Points: 2,749,
Visits: 1,408
|
|
CTRL R toggels the results pane off and on just like in QA.
By the way performance is almost acceptable if you stick 2Gb in your development machine.
My dev machine is a 3GHz P4 with 2GB DD2 533MHz RAM and performance still doesn't light any fires!!!!
LinkedIn Profile
|
|
|
|