Elliott Whitlow (12/20/2011)

---

If you want to read about real world applications of social engineering, read Ghost in the Wires by Kevin Mitnick. This guy would be considered the SUPREME...

BTW, all four finalists, please PM me your addresses.

If you haven't tried it, google "let it snow" and check out the Easter egg

Never used the assignment operator. Convention seems to be

SELECT col_A + col_B AS combined

FROM Table

or

SELECT col_A + col_B 'combined'

FROM Table

Not sure it matters, but...

Use convert:

SELECT CONVERT( Varchar(12), GetDate(),1)

Robert is correct. Just grant the db_owner role. That gives you all the privileges in the database.

If you would like to get help with the exams and...

Capt. Sigerson (12/20/2011)

---

Another issue for technical types is that we sometimes have to deal with managers who don't fully (or even partially) understand what we do or what we're even...

Sorry, the DM view: http://msdn.microsoft.com/en-us/library/ms176013.aspx

Don't use sysprocesses. It's old

What are you trying to embed in the trigger? The query from sysprocesses?

Use the value from EventData to find the machine name. I'm not sure why you are querying less...

When someone reboots a server, it sends a "stop" message to all services. They aren't killed, they are shut down. It's possible that someone might kill the SQL Server service...

Congrats to the four finalists!

Good catch. It's corrected to 2012

PaulB-TheOneAndOnly (12/17/2011)

---

For documentation purposes I would fully qualify the non-local table - that way whoever reads the code in the future will be immediately aware that the table is not...

Roy Ernest (12/19/2011)

---

You all are older than me. I am a young pup compared to some of you. 🙂 Younger than Steve 😀 So I can call Steve "Old Man"...