Home Forums SQL Server 2008 SQL Server 2008 - General Use cursor to run dynamic SQL to find special characters used in database RE: Use cursor to run dynamic SQL to find special characters used in database

  • Cursoring through the tables is fine, but you should process all columns in a single table in one pass (scan), not a separate pass for each column.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.