InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 21:31:58 GMT20http://www.sqlservercentral.com/Forums/Topic841835-1234-1.aspxWow thank you for that. Now promising to post a follow up might not really be needed.Fri, 08 Jan 2010 12:48:12 GMTScott Abrantshttp://www.sqlservercentral.com/Forums/Topic841835-1234-1.aspxI believe that I can save you the headache. I have just published two scripts, one which can convert bound default objects to column defaults and one that converts bound rules to column check constraint.[url=http://www.sqlservercentral.com/scripts/sp_bindrule/69220/]Convert rule objects to column check constraints[/url][url=http://www.sqlservercentral.com/scripts/sp_unbindefault/69219/]Convert default objects to column defaults[/url]Actually it is pretty complicated to convert rules, because sql server stores them as transact statements. The only way I know of, are converting them by doing text parsing. Parsing these objects are pretty hard to generalize. I would appreciate feedback if you run into problems with the scriptsFri, 08 Jan 2010 10:28:53 GMTLigtornhttp://www.sqlservercentral.com/Forums/Topic841835-1234-1.aspxThanks for the article. Very useful. Looking forward for the followup.Tue, 05 Jan 2010 17:20:08 GMTGiammarco Schisanihttp://www.sqlservercentral.com/Forums/Topic841835-1234-1.aspxThank 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?Tue, 05 Jan 2010 11:11:16 GMTScott Abrantshttp://www.sqlservercentral.com/Forums/Topic841835-1234-1.aspxNice article and good info.Tue, 05 Jan 2010 10:47:20 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic841835-1234-1.aspxGood 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.Tue, 05 Jan 2010 09:07:07 GMTscunninhttp://www.sqlservercentral.com/Forums/Topic841835-1234-1.aspxAny 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!Tue, 05 Jan 2010 07:02:03 GMTScott Abrantshttp://www.sqlservercentral.com/Forums/Topic841835-1234-1.aspxThanks 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?Tue, 05 Jan 2010 06:31:37 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic841835-1234-1.aspxThank 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.Tue, 05 Jan 2010 05:36:31 GMTScott Abrantshttp://www.sqlservercentral.com/Forums/Topic841835-1234-1.aspxNice article and useful for digging out those silly artifacts.Tue, 05 Jan 2010 05:34:51 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic841835-1234-1.aspxI want to thank Jon W. and Tom W. for helping edit this article before posting.Tue, 05 Jan 2010 05:32:52 GMTScott Abrantshttp://www.sqlservercentral.com/Forums/Topic841835-1234-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Rules/68989/">Those Stubborn Database Rules - Finding Them and Scripting Them</A>[/B]Mon, 04 Jan 2010 21:23:27 GMTScott Abrants