ehsan wwe
ehsan wwe

Reputation: 71

show warning before execute sql code

I do a mistake update in sqlserver and my database be clear. I want add custom warning in Microsoft SQL SERVER software when I press execute button, for example if my update code haven't any where at his line the IDE(ms sql server 2014 or any version) show warning to me

Upvotes: 1

Views: 902

Answers (2)

Jack James
Jack James

Reputation: 158

Check this I found a cool feature that can be useful. Not exactly what you are looking for but definitely very useful.

http://www.ssmsboost.com/Features/ssms-add-in-preferred-connections

Upvotes: 2

FLICKER
FLICKER

Reputation: 6693

You can't make SSMS to do that. You need to use some third party tools and add-on.

Look at SQL Prompt from RedGate or tools from ApexSQL

SQL Prompt

ApexSQL Complete

Upvotes: 5

Related Questions