Good scripting analizer tools

Question

Are there any good script analizer tools out there?  I have a trigger that keeps giving me an error that I cannot figure out.  I'm not a seasoned programmer, just getting into adding stored procedures and triggers to my db.  I am hoping that there is a tool that would analize my scripts and give guidance on syntax, structure, etc.

Thanks for your help!

Answer 1

I think that Red-Gate has some tools that might provide some guidance...or at least point out syntax issues. 

---

will

Answer 2

You are on the best T-SQL analyzer tool in the world. T-SQL MSDN forum! Free too!

Just post your T-SQL script and related information.

---

Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com

Answer 3

You are on the best T-SQL analyzer tool in the world. T-SQL MSDN forum! Free too!

Jost post your T-SQL script and related information.

---

Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com

Kalman, I love your response. :) That's so true

---

Abdallah, PMP, ITIL, MCTS