Tag Archives: SQL Prompt

Summarizing a Script with SQL Prompt

I have never used this feature, but someone was asking for feedback on Prompt, and I noticed  this in the menu: Summarize script. I had guessed that it might look at the code and give me some outline, which is … Continue reading

Posted in Blog | Tagged , , | Comments Off on Summarizing a Script with SQL Prompt

Quick NoLock with SQL Prompt

First, please, please, please, avoid NoLock. You can lose data, or get strange results, as Jason Strate demonstrates (blog | video). Before you read further or try this, read his post and look at Kendra’s video. I had a customer … Continue reading

Posted in Blog | Tagged , , | Comments Off on Quick NoLock with SQL Prompt

Color Coding a Database on All Servers with SQL Prompt

SQL Prompt has some nice color coding features, but sometimes I want a database to keep the same color, regardless of instance. I don’t know that I’d recommend this, but since I work in demo environments across versions, this is … Continue reading

Posted in Blog | Tagged , , | Comments Off on Color Coding a Database on All Servers with SQL Prompt

SQL Prompt Fixes Missing Begin End in Procs

SQL Prompt is a fantastic coding aid, but it does more than format your code and provide intellisense. Over time, the team has enhanced SQL Prompt to also guide you along and fix some bad code that your team might … Continue reading

Posted in Blog | Tagged , , | Comments Off on SQL Prompt Fixes Missing Begin End in Procs