Thread: Testing SQL Statements

Im working with a SQL Server that i have limited access to. Is there a program (freeware preferred) that i can use to run my DDL against to verify it will process correctly when run on the SQL Server? Thanks.

http://www.microsoft.com/Sqlserver/2...s/express.aspx

Run the query in a transaction, and then roll it back.

Or, a much weaker method, ask for an estimated query plan. This will only verify syntax and that it can be compiled against a schema, not that the code is valid for the data itself (that the script will run without error).

thanks for the info.