SQL Server Comments and ColdFusion MX 7

This problem (and solution) comes from my good friend Will Spurgeon of Tech-It-Easy. He has long been using SQL comments when developing for SQL Server. The advantage of this approach is that you can see these comments when reviewing transactions in SQL Server Profiler. It can really help in a lot of trouble-shooting situations.

For example:

[More]

Comments (Comment Moderation is enabled. Your comment will not appear until approved.)
Thank-you, just ran into this problem perparing to move to a new server ( rule: always leave LOTS of days when transferring to new server before actual switch over - lot less stressful LOL )

Guy Who is Losing More Hair Everyday!
# Posted By John Skrotzki | 12/18/06 3:01 AM
BlogCFC was created by Raymond Camden. This blog is running version 5.8.001.