Triggers and audit tables are the usual way to deal with this problem.

Is there a specific reason why you're asking or is this a general question?

I've added this, since I am not interested in those procedures. It's not actually needed. If you don't use it, you'll get the same result as Dinesh.

Something along these lines should work:

select * from information_schema.routines

where

objectproperty(object_id(routine_name),'IsMSShipped')=0

and routine_name not like 'r_%'

Some links

http://support.microsoft.com/default.aspx?scid=kb;EN-US;195565

http://www.microsoft.com/sql/techinfo/tips/development/queryopstats.asp

http://support.microsoft.com/default.aspx?scid=kb;EN-US;325024

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/statquery.asp

To expand Mike's post a bit. Whenever you create a new db, SQL Server copies the model db behind the scenes. When you have freshly installed SQL Server, a newly...

Remi,

interesting thread. Look like a one-man show here. Wasn't there recently a remark on posting multiple times when none or one time is enough? 

OBJECTPROPERTY and OBJECT_ID

USE PUBS

SELECT

 OBJECTPROPERTY(OBJECT_ID('authors'),'IsMSShipped')

When you examine the execution plan for this, you'll see nothing but Constant Scans. Those should be damn fast. I believe those values to be in...

Something like this?

SELECT CONVERT(varchar(10), ProgramLOIAcknowledged ,101) AS [Letter of Intent Acknowledged]

Yes, I did the translation. Hm, that reminds me that I finally need to add the additions Tibor made.

I also use generally your...

Not sure if I understand correctly, but see if this helps:

DECLARE @stmt nvarchar(4000)

DECLARE @rowcount int

DECLARE @table nvarchar(255)

SET @table = 'authors'

SELECT @stmt = 'SELECT @count = COUNT(*) FROM ' + @table

EXEC...

What function?

Hm, you should really do so!

Well, actually I don't know of a way to suppress some messages and others not. Maybe someone else...

The only acceptable way to compare dates is something like the following:

WHERE datecol >= @startdate AND datecol < @enddate

Not quite, I think!

use northwind

select * from orders where orderdate >='19960704'...

Hm, given the example you've posted. Have you actually read the message? I'd say it's a fairly important and interesting one you really should be concerned about.

Yes, and subtract those that are off-topic and you'll get a negative post count