Creating a recycle bin for SQL Server 2005\2008

Question

Post reply

Creating a recycle bin for SQL Server 2005\2008

Chris Goldsmith

Valued Member

Points: 72
More actions
May 19, 2009 at 11:42 pm

#204475

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

Viewing 15 posts - 1 through 15 (of 30 total)

You must be logged in to reply to this topic. Login to reply

Dugi SSCoach Points: 17998 More actions · Answer 1

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!

😎

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

SuperDBA-207096 SSCrazy Eights Points: 8176 More actions · Answer 2

SuperDBA-207096

SSCrazy Eights

Points: 8176

May 20, 2009 at 4:06 am

#997482

Good post! Interesting concept!

Duncan RAY-360676 SSC Enthusiast Points: 116 More actions · Answer 3

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

patr SSC Eights! Points: 892 More actions · Answer 4

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.............................:-)

Jurgen H. Say Hey Kid Points: 713 More actions · Answer 5

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

Florian Reischl SSC-Dedicated Points: 37301 More actions · Answer 6

Nice article, Chris!

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

(I know about auditing tables ;-))

doveb SSC Veteran Points: 224 More actions · Answer 7

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?

Mike DiRenzo SSCrazy Points: 2013 More actions · Answer 8

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

Thanks a million.

-Mike

Jack Corbett SSC Guru Points: 184394 More actions · Answer 9

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
Consultant - Straight Path Solutions
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

Jack Corbett SSC Guru Points: 184394 More actions · Answer 10

doveb (5/20/2009)
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?

You can't drop the parent table in a foreign key relationship, but you can drop the child.

You can't drop a table that has a schema-bound view associated with it.

Here's some tests:

CREATE TABLE parent

(

Id INT PRIMARY Key

)

GO

CREATE TABLE child

(

id INT,

parent_id INT REFERENCES parent(id)

)

GO

-- will not work because it is the parent table

DROP TABLE parent;

GO

-- you can drop the child table

DROP TABLE child;

GO

CREATE TABLE child

(

id INT,

parent_id INT REFERENCES parent(id)

)

GO

CREATE VIEW vw_child

WITH SCHEMABINDING

AS

SELECT id, parent_id FROM dbo.child

GO

-- can't drop the table if there is schema bound view

DROP TABLE child;

Go

Jack Corbett
Consultant - Straight Path Solutions
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

Akeel.Mughal SSChasing Mays Points: 609 More actions · Answer 11

Akeel.Mughal

SSChasing Mays

Points: 609

May 20, 2009 at 8:59 am

#997669

Fantastic idea, thanks.

IN_Sandeep SSCertifiable Points: 6259 More actions · Answer 12

"Excellent Script By Chris Kinley".

A Special Thanks goes to Steve & SQL Guru like {Gail, Jeff & others} for posting this kind of article in the forum which specify the future technologies of SQL Server.

Cheers!

Sandy.

--