Did you ever find a PBM way to do this.

I have been unable to find any facet that looks at code.

The facet Multipart Name only looks at the name...

The presense of an index is not necessarly a problem even if the index is not used. In your article you failed to state what problem you were trying to...

A simple example of using a table valued parameter from C#.

USE AdventureWorks;

go

CREATE SCHEMA Demo;

GO

IF EXISTS(SELECT 1 FROM sys.types WHERE name = 'PersonTable' AND is_table_type = 1 AND SCHEMA_ID('Demo') = schema_id)

DROP...

With SQL2008 you do have the option of a table variable. I was using XML and found that the table variable provided all the flexibility but was much faster.

Convert also works with Sybase. How do I format a date with CAST as I can with convert.

Good Article.

I want to save information when I find certain conditions for active sessions. I have considdered Service Broker for starting and stopping this activity. I even have the code written...

Both 2005 and 2008 allow seconds. I have always satisfied this type of requirement with a loop in the past but I am interested to hear if there is a...

You said nothing about checking security. I still find SQL servers with a default blank password. Everybody who ever worked there has full access to the server.

Tom Groszko