This is storing one field for one purpose, in fact it's a much more specialized purpose than defining a binary field in the table.

And how do these fit in to...

And that is where I would use 'old fashioned rows' of data.

Why not simply store it in a VARBINARY(MAX))?

The job of a DBMS is to preserve the integrity of the database. The only way it can do that is to 'know'...

The problem with this approach is that we would be using a relational DBMS (not truly relational, but still) for storing the data, but for some reason not using the...

Yes, xp_smtp_sendmail accepts multiple recipients using comma as separator. So do something like:

SELECT @email = COALESCE(@email, '') + emailaddresscolumn + ','

FROM sometable

SET @email = LEFT(@email, LEN(@email) - 1)

exec @rc =...

Is it a 64-bit program (the xproc)?

I am not quite sure what you mean, but I think you are looking to script an index. Right? I think you could use sysindexkeys for that information.

This type of example is exactly the reason why I and many more or 'scared' (or at least concerned) about the CLR Integration in SQL Server 2005. I see absolutely...

Any idea how to change the way Query Analyzer displays these things?

Tools/Options/Connections. Check 'Use regional settings when displaying currency, number, dates and times' to make QA use whatever you have...

It's a little bit difficult to understand all that happens since some code is missing, but it seems to me you are creating an instance of the class in the...

Same here, we moved our slightly smaller 200GB backups using Robocopy. Can't say exactly how much it affected performance, but as I remember it we did not have any CPU...

is there any query based solution for this type of a situation which retrieves selective fields

I can't think of any. This is normally an issue that should be solved by...

As far as I am concerned, PASS is the best SQL Server conference to spend your money on. Whether or not you will find it beneficial is of course impossible...

Aha, now that I re-read the question (after reading noeld's reply) I see where the error is made.

faizjmc: I think you have misunderstood how model is used. All databases...

Eh, and when my mind got around to finishing that thought (damn those write-ahead threads in my head):

SELECT CONVERT(VARCHAR(10), CAST('20050802' AS DATETIME), 120)