Thanks for the advice.

It looks like switching the order of the code allowed me to write to the log table. See the code below. I also added a ROLLBACK statement.

When...

Lowell (7/9/2013)

---

you can get the IP address for connections, if that helps;

compare this to sp_who2, and see if it helps you any:

select

conns.client_net_address,

conns.auth_scheme,

sess.* from sys.dm_exec_sessions sess

LEFT OUTER JOIN sys.dm_exec_connections conns...

Thanks. Some of them are system SPIDs, but I see several where the...

Thanks, everyone, for the prompt replies.

Just so I understand correctly, does a dot mean that the connection in question is being made from the current SQL Server itself? How would...

I just tried this question and picked B (correct answer was D, it says).

Even though I see the point of the issues with the question wording, I want to praise...

david.wright-948385 (7/2/2013)

---

+1

Also, the width of the original would scale...

Yes, thanks to Hugo for the detailed explanation. I agree with those who say that the Microsoft documentation could use Hugo's addition!

I think the following queries show the switchover point...

opc.three (6/28/2013)

---

Yep. For oft used snap-ins you can edit your Profile so they are...

Thanks for your response!

When I run this command in a new session:

Get-Command -commandtype cmdlet | select PSSnapin -Unique

I get this:

PSSnapIn

--------

Microsoft.PowerShell.Core

PS C:\Windows\system32>

Maybe I just need to manually load whatever snap-ins I...

Thanks - really cool question.

- webrunner

marcia.j.wilson (6/20/2013)

---

webrunner (6/20/2013)

---

... I guess it comes down to whether computerization is truly a unique industry/business entity or can be put in line with other industries such as mechanical...

As technology industries move further and further into areas where lives can be lost (as in pharmaceuticals and construction), I think we will see that things have to mature or...

Ola Hallengren (6/11/2013)

---

I calculate the cleanup time before I start backing up the database. The reason for that is to protect against a scenario where you delete a backup that...

This is a fantastic set of scripts. Thanks to Ola Hallengren for them!

I do have one question, though. I have tried setting the CleanupTime for the backup script to 24...

Great question. I was close but got it wrong. Still, a great teaching question.