• natalie.ignatieva (10/27/2010)


    Management studio shows me this script mostly in black meaning there is something wrong in the script even if it's completed successfully.

    The color coding is actually correct. The first [ character starts a table name that only ends at the final ], so everything in between them is part of the table name. Black is the default color used for (a.o.) table names.

    Please read the rest of the discussion for a more comprehensive explanation (and for many people agreeing with our dislike of the question)


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/