Search

Allow User objects to be deprecated by way0utwest

Closed
as Won't Fix Help for as Won't Fix

17
0
Sign in
 to vote
Type: Suggestion
ID: 490420
Opened: 9/17/2009 7:35:17 AM
Access Restriction: Public
0
Workaround(s)
One of the issues that we often find in mature databases is old code. Often people are unwilling to remove objects at a point in time because of the possibility that they might be used in the future. However this becomes an issue in keeping track of items.

It would be good for users to be able to somehow manage these objects that might need to be pruned from the system.
Details (expand)
Product Language
English

Category

SQL Engine

Proposed Solution

What I would suggest is the ability for users to mark objects (tables or code objects) as deprecated. If any of these objects is then accessed, a note is included in the error log or an event raised.

I also would suggest that there be an instance, database, and/or object level retention period for deprecated objects, similar to the collation granularity, that would allow the instacne to remove these objects after xx time. Perhaps an automatic backup of the object (script and BCP out) could be performed as well.

Benefits

Improved Administration
Improved Security
Improved Performance

Other Benefits

 
File Attachments
0 attachments
Sign in to post a comment.
Posted by Microsoft on 3/24/2011 at 4:34 PM
Hello,

Thank you for submitting this suggestion, but given its priority relative to the many other items in our queue, it is unlikely that we will actually complete it. As such, we are closing this suggestion as “won’t fix”. If you feel that this is worth reconsidering, feel free to respond to this message and we will take another look.

Jan
SQL Server Engine
Posted by Kevin Wagner on 1/16/2010 at 5:52 PM
Interesting, would need to update some of the .net objects to understand object depreciation. Could be at design time as well to alert the developer of the pending depreciation. It would also mean new exception objects/classes to elegantly handle the "missing" database objects.
Posted by PuzzledDBA on 10/8/2009 at 12:57 PM
This would be a Godsend. Being able to say once and for all that a DB object was no-longer used would be invaluable.

Some of our legacy databases have thousands of objects and no-one is willing to trawl through the millions of lines of legacy spaghetti code to identify whether or not they are used. Short of running a trace over an extended period of time (not feasible in our production systems) it is virtually impossible to deprecate anything.
Posted by Tim Mitchell on 10/8/2009 at 8:24 AM
Good idea. This would be a useful addition to the SQL Server feature set.
Posted by Microsoft on 9/21/2009 at 2:08 PM
Hello,

This is indeed an interesting idea, and it dovetails nicely with some thoughts we've been having around managing the surface area of database apps. No promises for this release, but it is definitely something we will consider.

Thanks,
-Isaac
Posted by Adam Machanic on 9/17/2009 at 9:47 AM
That's a very cool idea! Although it could just as easily be hand-rolled using SQL Audit.
Sign in to post a workaround.
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement