What's the delimeter?

You can always add a value at the end of your view

SELECT DISTINCT

...

I don't think there's an easy way to do this in T-SQL. Not sure there's a great way. I typically definite defaults and then assign them, that way they can...

Quite a few of the backup scripts in the script library on this site do this.

You need to open ports on the DMZ firewall. Not sure what they are for 6.5, but your firewall people should be able to log attempts from the db server...

if exists( select top 1 * from table)

will return true if there is data.

Agree with that. Management often doesn't know who is qualified and who isn't. Heck, in many companies the DBA is alone and no one is qualified to interview them!!!!

Here's my list. I have to say that #7 is new from when I first did this about 8 years ago. These aren't in any particular order.

1. Hitler - World War...

Interesting thoughts. I'd argue, however, that if Reagan wasn't here or Mao or some of the others, that some other politician might have done made the impact.

There were lots of...

What client is this? Are you using ODBC, OLEDB? Something else?

When does this occur?

Maybe stop should not have been included because you could be stopping the SQL Server, but allowing the OS to run. To me it has always referred to quieting activity...

Used to be a German car guy, I've owned a couple VWs, a Mercedes, and now a Porsche 914. Still want a Thing and am looking

First of all move the PK.

Then, Protegrity has a fairly seemless system, albeit $$$ (http://www.protegrity.com/)

Netlib has something as well: http://www.netlib.com/sql-server-encryption.shtml

Once you jump to PAE, there is a need to get lots of RAM for the OS to switch in and out of. I thought that at 8GB, you needed...

Well done!?!?!!

Might as well eat charcoal.

Slap it on the rear and singe it with a brand on the way through the kitchen, please.

Apologies. The editor for the question keeps changing the brackets back from the HTML code so it kept moving my changes. I missed the close slash at some point because...