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
Bikeman
Bikeman
SSC-Enthusiastic
SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)

Group: General Forum Members
Points: 125 Visits: 4
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bBaliner/sql2000tosql2005wherehavealltheoldfeaturesgone.asp
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: 3698 Visits: 3121
Never mind the features, why is SQL Management Studio so pathetically slow!

Even if you put the -nosplash switch on the SQLWB.EXE it takes an age to load.

There are bits I like, or there would be if I could get to them before the next ice age.

How the hell do you show the contents of a system stored procedure? I know sp_helptext but there MUST be a better way than that!

LinkedIn Profile

Newbie on www.simple-talk.com
G.R.Prithiviraj Kulasingham
G.R.Prithiviraj Kulasingham
SSC-Addicted
SSC-Addicted (427 reputation)SSC-Addicted (427 reputation)SSC-Addicted (427 reputation)SSC-Addicted (427 reputation)SSC-Addicted (427 reputation)SSC-Addicted (427 reputation)SSC-Addicted (427 reputation)SSC-Addicted (427 reputation)

Group: General Forum Members
Points: 427 Visits: 367
It is a great surpise to see that in sql2k5 we have lost the fucntionality to script a set of objects based on the settings i want. In sql2k, I can select a few objects (based on name, owner, created data or even randomly) and create the script. then i will be presented with the option of what to script (whether to have drop and create, script indexes, permissions etc) It is no more there.

Cheers,
Prithiviraj Kulasingham

http://preethiviraj.blogspot.com/
richardd
richardd
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3089 Visits: 642

Some other problems using SSMS with a SQL 2000 instance:

  • You can't view or modify multi-statement TVFs. If you try, you get an error message indicating that you don't have permission to access the object, even if you are the dbo.
  • You can't view or modify full-text indexing properties. This produces a very similar error message.
  • You no longer have the option to see a list of permissions for a user. Instead, you have to select the specific objects, and then select each object in the list to see the associated permissions.

The first two are apparently fixed in SP1, but there doesn't seem to be any indication of when we can expect to see it. The only current workaround is to re-install the SQL 2000 tools.

To work around the third problem, you can use the sp_helprotect procedure. However, this doesn't provide any simple way to see the list of objects which a user doesn't have access to.





Ryan-209402
Ryan-209402
SSC-Enthusiastic
SSC-Enthusiastic (121 reputation)SSC-Enthusiastic (121 reputation)SSC-Enthusiastic (121 reputation)SSC-Enthusiastic (121 reputation)SSC-Enthusiastic (121 reputation)SSC-Enthusiastic (121 reputation)SSC-Enthusiastic (121 reputation)SSC-Enthusiastic (121 reputation)

Group: General Forum Members
Points: 121 Visits: 101

Great article. I'm glad that I am not the only one who is missing these features. I especially miss the ability to DTS objects, such as SPs, from one db to another. That feature is now completely gone in SSIS! I don't see any reason why MS should not add it back in sp1.

Please MS, give us an easy way to script or copy stored procedures because some organizations rely on low tech admins to perform such tasks. It used to be available in the SQL 2000 DTS wizard and was called "Copy Objects and Data Between Servers" but now that functionality is completely gone in SSIS. It supposedly can still be done by creating a SSIS project in Visual Studio but that is too much for your average admin.

You're right, I think Advil's stock is going to go up as a direct result of this.


Bryant McClellan
Bryant McClellan
SSC Eights!
SSC Eights! (881 reputation)SSC Eights! (881 reputation)SSC Eights! (881 reputation)SSC Eights! (881 reputation)SSC Eights! (881 reputation)SSC Eights! (881 reputation)SSC Eights! (881 reputation)SSC Eights! (881 reputation)

Group: General Forum Members
Points: 881 Visits: 537
This one is pretty minor, but since the thread is managing SQL2K with SQL2005 tools...

When you look at legacy maintenance plan history, SQL2005 cannot sort the history records by date. It implies that it can because clicking on the End Date heading changes the display, but the date is sorted as text! Consequently, 10 March is after 1 March but BEFORE 2 March. Hey Microsoft, this makes sense because...?

------------
Buy the ticket, take the ride. -- Hunter S. Thompson
Alex Grinberg-230981
Alex Grinberg-230981
SSC Rookie
SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)

Group: General Forum Members
Points: 38 Visits: 402

I would like to emphasis that SQL 2005 is another product versus just another version of SQL 2000. On the surface it may seem some of the features have disappeared in the product, but in actuality, it provides the DBAs with more flexibility. For instance, there is an extended stored procedure facility that allows DBAs to write his own sprocs that would enhance the current xp_fixeddrives routine currently provided by today's version of SQL. SQL 2005 also has the additional benefit of allowing the programmer or DBA wrote routines using VB.NET or C#.

In case to replace xp_fixeddrives just use scripting runtime library class Drive, which has property FreeSpace.


TDuffy
TDuffy
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1326 Visits: 57

Some good new features, some missing old friends...what can you do. Do register your comments with MS and maybe somethings will be restored.

You will be upgraded. Resistance is futile. (Bill Gates)





noeld
noeld
SSCertifiable
SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)

Group: General Forum Members
Points: 6324 Visits: 2048

How the hell do you show the contents of a system stored procedure? I know sp_helptext but there MUST be a better way than that!

SELECT OBJECT_DEFINITION (OBJECT_ID ('sys.sp_help') )

I suffered this one too

Cheers,




* Noel
Loner
Loner
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2918 Visits: 3332

Alex

I agreed with you. SQL Server 2005 is another product. I feel liked I have to learn SQL Server all over again.


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