Zip it with a password and unzip it trough your software installer?

Or some variation of encryption.

Look up

"Trace Events for Use with Event Notifications"

and

"Designing Event Notifications"

in Books Online.  I think you should be able to do what you want using that as a...

I too am in the camp of not liking it, at least not as a primary way of storing data.  We do use XML though in the company I now work...

Supposedly they added this functionality back in in SP2.  Haven't had time to test it yet myself though

Maybe you would do this if you had 2 different product lines, but needed to have unique product numbers between the two lines?  And the developer did not know how...

Something like this? 

Select Phone1, Phone2, Phone3 from Table

where Phone1 = Phone 2

or Phone1 = Phone3

or Phone2 = Phone3

Not sure I would use partioning for this, but then I grew up on a farm and like to keep things simple!

How about...

Have you considered using DDL triggers instead?

I use the one below, it saves any DDL statements in a table and I have a job that every morning sends me a...

I think the datatype would have to be decimal(8,0) to store enough data to do this.  Try this simpe example, maybe it can help you out.

create

AC/DC - pick any,  but Back in Black #1

Metalica - Master of Puppets

Dixie Chicks - either one, like the new one the best

Gretchen Wilson - either

Helsinki Philarmonic playing Grieg

(yes I...

Maybe to have something else happen just because there was no records affected?

Or my really quick and dirty one

select name

into #t

from syscolumns

where id = object_id('growthdetails')

create table #result (

ColName varchar(30),

NullCount int)

declare @qry varchar(500), @columnname varchar(30)

select...

Just tried this and it seems to work fine.  Here is my query:

select

datediff(mi,