SQL Clone
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 Eights
SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)

Group: General Forum Members
Points: 9921 Visits: 1441
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
Hall of Fame
Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)

Group: General Forum Members
Points: 3038 Visits: 1065

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
SSC Journeyman
SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)

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



Adam Wilbur
Adam Wilbur
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2208 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
Right there with Babe
Right there with Babe (786 reputation)Right there with Babe (786 reputation)Right there with Babe (786 reputation)Right there with Babe (786 reputation)Right there with Babe (786 reputation)Right there with Babe (786 reputation)Right there with Babe (786 reputation)Right there with Babe (786 reputation)

Group: General Forum Members
Points: 786 Visits: 1809

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 (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)

Group: General Forum Members
Points: 72 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
SSC-Enthusiastic
SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)

Group: General Forum Members
Points: 105 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
Old Hand
Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)

Group: General Forum Members
Points: 361 Visits: 1187
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
Mr or Mrs. 500
Mr or Mrs. 500 (564 reputation)Mr or Mrs. 500 (564 reputation)Mr or Mrs. 500 (564 reputation)Mr or Mrs. 500 (564 reputation)Mr or Mrs. 500 (564 reputation)Mr or Mrs. 500 (564 reputation)Mr or Mrs. 500 (564 reputation)Mr or Mrs. 500 (564 reputation)

Group: General Forum Members
Points: 564 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
Dave Poole
Dave Poole
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17006 Visits: 3403
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
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