Creating a recycle bin for SQL Server 2005\2008

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Chris Kinley » Creating a recycle bin for SQL Server...

31 posts, Page 1 of 4

1 2 3 4 »»»

Creating a recycle bin for SQL Server 2005\2008

Rate Topic

Display Mode

Topic Options

Author

Message

Chris Goldsmith

Posted Tuesday, May 19, 2009 11:42 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, January 03, 2013 7:50 AM
Points: 6, Visits: 125

Comments posted to this topic are about the item Creating a recycle bin for SQL Server 2005\2008

Post #720299

Dugi

Posted Wednesday, May 20, 2009 3:01 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, April 02, 2013 1:48 AM
Points: 1,252, Visits: 3,367

Yea great idea, and very nice post here Chris!

This one is enable in Oracle from 10g version if I'm not wrong!

Anyway, thanks for the script and explanation!

Cool

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/

Post #720393

SuperDBA-207096

Posted Wednesday, May 20, 2009 4:06 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, January 02, 2013 12:15 PM
Points: 1,443, Visits: 711

Good post! Interesting concept!

Post #720419

Duncan RAY-360676

Posted Wednesday, May 20, 2009 4:22 AM

Valued Member

Group: General Forum Members
Last Login: Monday, April 08, 2013 3:54 AM
Points: 61, Visits: 41

Chris,

This is the reason I subscribe to the forums. One becomes a "panner for gold" or a "hunter of diamonds". And, this is a find that I think I will have to frame somewhere amongst my piles of debris left over from my adventures surfing the net.

I must send you a million thanks. This article and associated code have introduced a much needed breath of fresh air in my cubicle.

Thanks,
Duncan

Post #720422

patr

Posted Wednesday, May 20, 2009 4:45 AM

Valued Member

Group: General Forum Members
Last Login: Monday, June 08, 2009 4:43 AM
Points: 60, Visits: 149

very good post....this is the thing i was really expected when i was beginner in sql 2005..........anyway a good idea and i appreciate to share this valuable information to everyone............................. Smile

Post #720428

Jurgen H.

Posted Wednesday, May 20, 2009 5:12 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 22, 2013 2:09 AM
Points: 148, Visits: 72

Interesting, but what if someone renames a procedure, object or view ?

Post #720436

Florian Reischl

Posted Wednesday, May 20, 2009 7:49 AM

SSCrazy

Group: General Forum Members
Last Login: Sunday, November 04, 2012 12:23 PM
Points: 2,087, Visits: 3,932

Nice article, Chris!

Now we have an un-drop. Last things we need are un-delete and un-update. BigGrin

(I know about auditing tables Wink

)

The more I learn, the more I know what I do not know
Blog: Things about Software Architecture, .NET development and T-SQL

How to Post Data/Code to get the best Help How to Post Performance Problems

Post #720555

doveb

Posted Wednesday, May 20, 2009 8:11 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, February 12, 2013 8:59 AM
Points: 20, Visits: 55

What a great idea. Thank you for the tip. I did have one question. Are there any additional considerations for items that are schema bound or have foreign keys associated to them?

Post #720579

Mike DiRenzo

Posted Wednesday, May 20, 2009 8:18 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 12:11 PM
Points: 143, Visits: 183

Duncan Ray could not have said it better.... "gold", "diamonds", "debris", " breath of fresh air".

Thanks a million.

-Mike

Post #720585

Jack Corbett

Posted Wednesday, May 20, 2009 8:23 AM

SSChampion

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:22 PM
Points: 10,571, Visits: 11,871

Interesting article and great concept. I've always relied on backups if an object gets dropped accidentally but this would be an interesting concept. I'm wondering why you didn't do it as database instead of schemas? A little more work, but I think it would work also.

Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2

Post #720587

« Prev Topic | Next Topic »

31 posts, Page 1 of 4

1 2 3 4 »»»

Permissions