InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 04:25:13 GMT20http://www.sqlservercentral.com/Forums/Topic533119-1072-1.aspxAfraid not, man. I personally prefer code samples which can be directly copied into SQA for evaluation, rather than making cosmetic changes outside of SQA which require manual manipulation in order to make the code operable. Any chance you could post corrected code? I like your concept, but the tab / quote suggestion didn't resolve the error.Peace.- SavageWed, 03 Sep 2008 03:47:52 GMTNbleSavage-393985http://www.sqlservercentral.com/Forums/Topic533119-1072-1.aspxI have used tab to format the script for easy reading. If you copy and past the script into QA, you may receive some error message. Replace ' ' with ' ' should resolve the error.Tue, 02 Sep 2008 07:06:03 GMTJohn.Liuhttp://www.sqlservercentral.com/Forums/Topic533119-1072-1.aspxNice code brah, but gives me an error message:Msg 319, Level 15, State 1, Procedure fn_GetLockChainSubTree, Line 11Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.Msg 102, Level 15, State 1, Line 4Incorrect syntax near ' '.Tue, 02 Sep 2008 03:35:28 GMTNbleSavage-393985http://www.sqlservercentral.com/Forums/Topic533119-1072-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Locking/63648/">Retrieve locking block-chain</A>[/B]Sun, 13 Jul 2008 06:18:48 GMTJohn.Liu