Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Those Stubborn Database Rules - Finding Them and Scripting Them Expand / Collapse
Author
Message
Posted Monday, January 4, 2010 9:23 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 11:58 AM
Points: 46, Visits: 340
Comments posted to this topic are about the item Those Stubborn Database Rules - Finding Them and Scripting Them
Post #841835
Posted Tuesday, January 5, 2010 5:32 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 11:58 AM
Points: 46, Visits: 340
I want to thank Jon W. and Tom W. for helping edit this article before posting.
Post #841990
Posted Tuesday, January 5, 2010 5:34 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 7:32 PM
Points: 15,517, Visits: 27,895
Nice article and useful for digging out those silly artifacts.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #841993
Posted Tuesday, January 5, 2010 5:36 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 11:58 AM
Points: 46, Visits: 340
Thank you Grant. I look forward to your presentation at Data Camp 2.0! Keep up the great work you do for the SQL Server community.
Post #841994
Posted Tuesday, January 5, 2010 6:31 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 7:32 PM
Points: 15,517, Visits: 27,895
Thanks Scott. I'm looking forward to your presentation at Data Camp 2.0 as well. You need to keep up your work for the community also.

Now, I happen to be closely acquainted with the person setting up the schedule and I know that he's bribable. When did you want to put your presentation on? Was yours at the end of the day or right after lunch, I forget?


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #842022
Posted Tuesday, January 5, 2010 7:02 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 11:58 AM
Points: 46, Visits: 340
Any time slot is good as long as it is not the same time as yours because I am sure everyone will be at that one and the others will be empty. Very nice job on your latest book!
Post #842056
Posted Tuesday, January 5, 2010 9:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 7:03 AM
Points: 1, Visits: 147
Good find. I believe you just saved me from a significant amount of future stress. I suspect that discovering the lack of support for rules on a future release would have been a painful experience.

Thanks.



Post #842169
Posted Tuesday, January 5, 2010 10:47 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 11:51 AM
Points: 21,209, Visits: 14,894
Nice article and good info.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #842248
Posted Tuesday, January 5, 2010 11:11 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 11:58 AM
Points: 46, Visits: 340
Thank you for the feedback. My intention is to write a follow up that will actually take the defined bindrules and script out proper constraints. What is interesting is how I ran into these in the first place. This issue came up because this database was created before I entered the picture and a non sql server resource defined the database. I think this is something we all have come across and knowing where the gotchas are is very important. I am planning on giving some of that back story in the follow up. Sound useful?
Post #842267
Posted Tuesday, January 5, 2010 5:20 PM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 8, 2010 5:40 PM
Points: 3, Visits: 12
Thanks for the article. Very useful. Looking forward for the followup.

_______________________
Giammarco Schisani
Volpet Software - Table Diff
Post #842503
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse