July 20, 2004 05:20 PM

Back Doors with a View

Some back doors lead to danger--take a look inside first
Rating: (0)
SQL Server Magazine
InstantDoc ID #42971
Back doors are undocumented features of an application that let you do things the application wasn't intended to support. With this article, I conclude my series on T-SQL back doors by discussing three back doors to SQL Server views: rolling your own INFORMATION_SCHEMA views, creating sorted updateable views, and circumventing update limitations that views impose. I also tell you which undocumented techniques I think could be useful for T-SQL programmers if SQL Server supported them.

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

Outstanding article. I think the most important statement you made in the entire article was your last: "Although using back doors can be dangerous, you need to be able to recognize them when you run across them in your production databases and be able to provide alternatives". This is the primary key when you starting using back doors of any kind. If you are not careful with them it is a good way to get your foot slammed in them! They do have their downsides and you do have to know what you are doing when you use them. I would 't experiment on a production system with them until you are well familiar with their benefits as well as their possible nasty side-affects.

Travis8/17/2004 2:47:45 PM


You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS