Time for some overkill with the new stuff   I mixed some XQuery with an UNPIVOT

-- Prep the sample data
DECLARE...

  The 'check existing' setting on constraint creation is not stored anywhere, afaik.  Once you create the constraint, there's no need to track the value.   

  You can determine the...

SET

NOEXEC ON

GO

Insert that at the top of your script and execute it.  It will...

> http://msdn.microsoft.com/vstudio/teamsystem/products/dbpro/

It's seriously exciting, provided your organization is willing to drop $5,500 per developer/architect/tester/db pro for any single VS Team Edition (architect, developer, or tester; DB pro...

What are you using now?  If you've never taken any certification exams, then your first one should be on material with which you are most comfortable.

The 2005 certification exams cover...

For an effective source control solution, it helps to go through and uninstall Enterprise Manager from anyone who will be touching your systems.  Otherwise, you get folks who use it...

Have you tried loading up a SqlTypes.SqlXml variable with your document and passing that as a parameter to a stored procedure? 

The procedure:

CREATE PROC...

I see you're using the templates.  Note that they are just samples, and there's plenty of room for you to modify them for your needs.  This stored procedure template sets...

Red Gate's SQL Data Compare can reduce that pain:

http://www.red-gate.com/products/SQL_Data_Compare/index.htm

(If you buy, tell them an MCT sent you )

As for any aspiring developers reading...

SQL Server has no hand in the management of connection pooling.

Connection pooling is similar to a bank of phones used by a research department.  One guy calls the library (dials...

This sounds like a homework problem.

What have you tried?

I'm guessing you're running this in Query Analyzer.

Your actual output is the full length, but QA is cutting it off.  From the menu, choose Tools -> Options and look for...

> then do I still need two SQL Server licences or just the one as I'm not going to need SQL Server installed on the box in the DMZ?

http://www.microsoft.com/sql/howtobuy/default.mspx

There's...

> is this the right way to implement the reporting services ?

Blocking anonymous access is the correct part, yes.

Remember there are three steps to running reports from an application:

1. ...

UNPIVOT is the key, here:

DECLARE @test table(id int, math int, bio