Presents your SQL SERVER E-NEWSLETTER for February 18, 2003 <-------------------------------------------> KNOW THE LIMITATIONS OF THE GO STATEMENT The GO statement is a command recognized and interpreted by the osql and isql utilities, and by the SQL Query Analyzer--but it's not a T-SQL command. If you use the Query Analyzer as your main development tool, other languages and libraries will not interpret the GO statement as a T-SQL command. GO is an indicator to the SQL Server utilities that a batch of T-SQL commands has been issued. The utilities interpret the GO statement, but don't actually pass it to the server because SQL Server can't interpret the GO statement by itself. A T-SQL command can't reside on the same line as the GO statement, but you can add comments on the same line. If you are executing statements in the SQL Server utilities, or you're building scripts of T-SQL statements to run through the utilities, you can use the GO statement to signal the end of a batch. If you try to issue a GO statement via ODBC, OLE DB, ADO, or any other database library, you will receive an error message. If you use a third-party editor for database development, it may not interpret the GO statement. ----------------------------------------