Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Management Studio with SQL Server 2000


Management Studio with SQL Server 2000

Author
Message
philcart
philcart
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2752 Visits: 1434
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
RichB
RichB
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1102 Visits: 1015

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...?)





SL10
SL10
Valued Member
Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)

Group: General Forum Members
Points: 73 Visits: 177
Also you can't hide/show query results. There is a button for that in QA.



Adam Wilbur
Adam Wilbur
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1014 Visits: 591

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
Fal
Fal
Mr or Mrs. 500
Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)Mr or Mrs. 500 (522 reputation)

Group: General Forum Members
Points: 522 Visits: 1803

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.


pmthiele
pmthiele
Valued Member
Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)

Group: General Forum Members
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.





Joel Rea
Joel Rea
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 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?
tskelley
tskelley
Valued Member
Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)Valued Member (55 reputation)

Group: General Forum Members
Points: 55 Visits: 1154
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.



Rob Farley
Rob Farley
SSC-Enthusiastic
SSC-Enthusiastic (166 reputation)SSC-Enthusiastic (166 reputation)SSC-Enthusiastic (166 reputation)SSC-Enthusiastic (166 reputation)SSC-Enthusiastic (166 reputation)SSC-Enthusiastic (166 reputation)SSC-Enthusiastic (166 reputation)SSC-Enthusiastic (166 reputation)

Group: General Forum Members
Points: 166 Visits: 375
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
David.Poole
David.Poole
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3692 Visits: 3118
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

Newbie on www.simple-talk.com
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search