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

Retrieve locking block-chain Expand / Collapse
Author
Message
Posted Sunday, July 13, 2008 6:18 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, September 13, 2014 2:11 AM
Points: 310, Visits: 361
Comments posted to this topic are about the item Retrieve locking block-chain
Post #533119
Posted Tuesday, September 2, 2008 3:35 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 1:45 PM
Points: 12, Visits: 285
Nice code brah, but gives me an error message:

Msg 319, Level 15, State 1, Procedure fn_GetLockChainSubTree, Line 11
Incorrect 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 4
Incorrect syntax near ' '.
Post #562274
Posted Tuesday, September 2, 2008 7:06 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, September 13, 2014 2:11 AM
Points: 310, Visits: 361
I 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.
Post #562365
Posted Wednesday, September 3, 2008 3:47 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 1:45 PM
Points: 12, Visits: 285
Afraid 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.

- Savage
Post #562894
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse