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

I'd use David's technique for a quick count.

Is this something that runs often, or just an ad hoc type report? If the latter, then select count(*) from (subquery) makes sense.

Stefan Krzywicki Posted Today @ 10:55 AM

Those of you who have been talking about the first machines you used in the industry, what was it that got you to that...

You're just a kid, though since you can...

You can use a DDL trigger to capture the event. Here's a sample:

http://www.sqlteam.com/article/using-ddl-triggers-in-sql-server-2005-to-capture-schema-changes

The eventdata doesn't have the machine name, but it will have the login name

Do you have a connection to the server in any way? If you can connect as an admin, you can do a NET STOP on that machine's services.

Well, I started in '67. Breathing, that is. I was lucky enough to start playing with computers in '78 and we actually had keys to punch, and tapes to store...

The upgrade advisor isn't applicable for an OS upgrade, only a SQL one.

There shouldn't be any issues with your OS upgrade, but take backups, move them off the machine, just...