SQL Server enables you to create constraints or triggers to define business
rules. Check BOL for more details
This posting is provided "AS IS" with no warranties, and confers no rights.
| Subject: Re: query plan statistics : found the answer, but ...
| Date: Wed, 17 Apr 2002 11:37:38 -0400
| Lines: 32
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
| Newsgroups: microsoft.public.sqlserver.programming
| NNTP-Posting-Host: 66-163-6-102.ip.tor.radiant.net 220.127.116.11
| Path: cpmsftngxa08!cpmsftngxa09!tkmsftngp01!tkmsftngp02
| Xref: cpmsftngxa08 microsoft.public.sqlserver.programming:251174
| X-Tomcat-NG: microsoft.public.sqlserver.programming
| Found it...
| SET SHOWPLAN_ALL ON
| But, now I want to do something a little more complicated. I would like
| power to filter all T-SQL commands directed at my db, apply business rules
| on whether or not statements will be run, queued, or denied based on my
| criteria, and finally either return the results as requested or
| Anyone know how you may run a filter (maybe much like an ISAPI filter for
| IIS) within MS SQL ?
| > Hi All,
| > I'm wondering if anyone can suggest a way to return a T-SQL result set
| > statistics of a query plan for a query without actually running the
| > itself. Again, I would like to be able to access it in a result set so
| > Query Analyzer's 'Show Execution Plan' is not really what I'm looking
| > Also, can SQL provide realtime performance statistics in a resultset?
| > Rein Petersen