|
|
|
Old Hand
      
Group: General Forum Members
Last Login: Tuesday, January 25, 2011 9:16 AM
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."
|
|
|
|
|
SSC Veteran
      
Group: General Forum Members
Last Login: Thursday, May 16, 2013 8:07 AM
Points: 229,
Visits: 257
|
|
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.
|
|
|
|
|
Right there with Babe
      
Group: General Forum Members
Last Login: Monday, January 21, 2013 1:19 PM
Points: 727,
Visits: 264
|
|
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/
|
|
|
|
|
Grasshopper
      
Group: General Forum Members
Last Login: Saturday, November 13, 2010 2:53 AM
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?
|
|
|
|
|
Valued Member
      
Group: General Forum Members
Last Login: Sunday, February 17, 2013 6:22 PM
Points: 52,
Visits: 77
|
|
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.
|
|
|
|
|
Valued Member
      
Group: General Forum Members
Last Login: Tuesday, July 20, 2010 8:22 AM
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.
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Monday, October 19, 2009 3:16 AM
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...
|
|
|
|
|
Mr or Mrs. 500
      
Group: General Forum Members
Last Login: Sunday, May 19, 2013 4:00 AM
Points: 533,
Visits: 2,285
|
|
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
|
|
|
|
|
Mr or Mrs. 500
      
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 12:43 AM
Points: 582,
Visits: 1,601
|
|
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?) 
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: Today @ 2:16 PM
Points: 1,048,
Visits: 2,215
|
|
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.
|
|
|
|