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: Tuesday, August 12, 2014 11:44 AM
Points: 46, Visits: 341
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: Tuesday, August 12, 2014 11:44 AM
Points: 46, Visits: 341
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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 6:53 AM
Points: 13,890, Visits: 28,285
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 Query Performance Tuning
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: Tuesday, August 12, 2014 11:44 AM
Points: 46, Visits: 341
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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 6:53 AM
Points: 13,890, Visits: 28,285
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 Query Performance Tuning
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: Tuesday, August 12, 2014 11:44 AM
Points: 46, Visits: 341
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: Friday, October 10, 2014 8:20 AM
Points: 1, Visits: 155
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 12:11 AM
Points: 17,823, Visits: 15,754
Nice article and good info.



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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
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: Tuesday, August 12, 2014 11:44 AM
Points: 46, Visits: 341
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