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


SQL 2000 to SQL 2005: Where have all the old features gone?


SQL 2000 to SQL 2005: Where have all the old features gone?

Author
Message
J.T. Shyman
J.T. Shyman
Old Hand
Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)

Group: General Forum Members
Points: 316 Visits: 4
If this really were true then most of the backwards compatiblity would be gone. You can connect to SQL 2000 servers using SSMS and, by and large, manage them pretty well. If this were a new product that wouldn't exist.

Then again, Microsoft would lose a lot of marketshare if they did that.

Yes, it is a new product but part of me believes the team for SQL2005 made some design decisions in a vacuum.

-- J.T.

"I may not always know what I'm talking about, and you may not either."

icata
icata
SSC Veteran
SSC Veteran (238 reputation)SSC Veteran (238 reputation)SSC Veteran (238 reputation)SSC Veteran (238 reputation)SSC Veteran (238 reputation)SSC Veteran (238 reputation)SSC Veteran (238 reputation)SSC Veteran (238 reputation)

Group: General Forum Members
Points: 238 Visits: 295
I couldn't find a way to right click on a database, back it up and in the same time schedule that backup. It helped me a lot in 2k to schedule databases backup.



Paul Paiva
Paul Paiva
Right there with Babe
Right there with Babe (737 reputation)Right there with Babe (737 reputation)Right there with Babe (737 reputation)Right there with Babe (737 reputation)Right there with Babe (737 reputation)Right there with Babe (737 reputation)Right there with Babe (737 reputation)Right there with Babe (737 reputation)

Group: General Forum Members
Points: 737 Visits: 265
I miss the ability to play a given .wav file when a query finishes. In SSMS we only have the option to play the Windows default beep.

- Paul

http://paulpaivasql.blogspot.com/
Kostas Stefanou
Kostas Stefanou
Grasshopper
Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)

Group: General Forum Members
Points: 22 Visits: 59
Very interesting subject.
I have a couple of questions.
1. I am wondering what happened to the feature that you could select multiple objects to script and select the output to one file per object.
2. When I choose windows ANSI format in sql2k, comments in greek were scripted OK. In SSMS are not.
Is there any fix?
slsmithstone
slsmithstone
SSC Journeyman
SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)

Group: General Forum Members
Points: 77 Visits: 115

Very interesting article.

I too miss the ability to copy stored procedures! One has to wonder if they simply forgot about it . . .

I am somewhat surprised no one is mentioning how screwed up Diagrams are. Why didn't they just leave them alone???

To the person complaining about 2005 being too slow -- I put more memory in one of my PCs and that perked it up a bit.


dma333
dma333
Valued Member
Valued Member (74 reputation)Valued Member (74 reputation)Valued Member (74 reputation)Valued Member (74 reputation)Valued Member (74 reputation)Valued Member (74 reputation)Valued Member (74 reputation)Valued Member (74 reputation)

Group: General Forum Members
Points: 74 Visits: 27
Well intended, but remember we're...we're not supposed to query those good old sys tables anymore (sysfiles)! There's another sys. view that replaced that, but I'll have to find that and post again.



James Hebben
James Hebben
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 11

Given that SSMS is a rework of the Visual Studio, why oh why did MS turn off all the good stuff? Specifically, all the Addin and extensibility bits. If they had left this in then, as a community, I am sure we could put all the "missing features" back in.

RedGate seem to have hacked addins into SSMS so perhaps there is hope for us yet...


Phil Factor
Phil Factor
Right there with Babe
Right there with Babe (754 reputation)Right there with Babe (754 reputation)Right there with Babe (754 reputation)Right there with Babe (754 reputation)Right there with Babe (754 reputation)Right there with Babe (754 reputation)Right there with Babe (754 reputation)Right there with Babe (754 reputation)

Group: General Forum Members
Points: 754 Visits: 2949
It is in SSMS Express that Microsoft took out the addins and extensibility. One can only guess that Microsoft saw it as an easy way of differentiating the two products, in the hope that you'll want to upgrade. It makes it more awkward for any provider of Add-ins like SQL Refactorer because of the need to explain to customers, and those trying them out, why the product won't work on certain versions of SSMS.


Best wishes,

Phil Factor
Simple Talk
David McKinney
David McKinney
Right there with Babe
Right there with Babe (771 reputation)Right there with Babe (771 reputation)Right there with Babe (771 reputation)Right there with Babe (771 reputation)Right there with Babe (771 reputation)Right there with Babe (771 reputation)Right there with Babe (771 reputation)Right there with Babe (771 reputation)

Group: General Forum Members
Points: 771 Visits: 2090

Where have all the new articles gone?

It's a good article and an interesting subject....but it's a repeat!

Also, since its original publication, we've had SP2, so some of the comments (notably about scripting) are no longer valid.

Shouldn't this be in the One Year Ago section? (Or is it too old for that?)


Markus
Markus
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1587 Visits: 3680

I have a list of complaints about Mgt. Studio vs. Ent. Manager, ones that people have not addressed...

Can no longer grant a user access to a list of tables in one GUI screen. Each table grant is a seperate task.

I really miss taskpad. I liked the mdf/ldf allocated and used in your face so you can see what part of the logspace is being used and not used.

Simple easy naviation is gone.

Query tool install as a stanalone product. Some developers only need to query a table from time to time. Why do I have to install ALL of this bulky stuff and give them a lesson on how to simply log in and be able to run one select statement. Why can't I simply install a Query Analyzer on a persons PC that only needs to run a query once in a while. We have tons of these type situations here.

Why is using the import / export wizard to simply move data from a table so bulky. After the package is created it is not easily viewable and understandable what that package does.

Granted, there are some improvements in Mgt. Studio, however, I have never see so many features removed for a product upgrade.





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