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...

Use the create code and change to be "drop table xxx"

Remove all the column stuff

The beta exams are scheduled for Nov/early Dec. From my own publishing experience, this would mean that the live exams should release in Jan/Feb and at that time everyone will...

you could use a modulus 24 if need be with the math to "round" it back down, but you'd need to handle the math for the carry yourself as well.

Use...

I think I agree with Vinny

Do you mean different privleges "granted" for theses functions? Rights are setup by the administrator, not based on code in a function

Try these:

http://www.databasejournal.com/features/mssql/article.php/3489111

http://www.sqlservercentral.com/columnists/ckempster/sendingalertsviaacustomsmtpprocedure.asp

Peter's answers look good. As far as the heap. If memory serves, the pages are linked in extents and each extent that contained data would need to be scanned. These...