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.
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.