SQL Build Script Creation
8/22/2006 1:30:47 PM
Just finished with a huge SQL build script for a project I`ve been working on. To most of you I`m sure it`s a pretty small build script; only about 5,500 lines of T-SQL! Any tips on troubleshooting or streamlining the SQL build process? I found that adding a print line right before each task was helpful in stepping through any errors. This took me back to the ASP Response.Write days of debugging.
Are there any `best practices` when it comes to creating build scripts or is it just another one of those tedious tasks that takes patience and persistence?
The only "error" I am getting now is telling me that the user already has select permissions on a certain table. In my opinion this really isn`t an error.
Database,
SQL
