You could also use EXECUTE AS OWNER or specify another login. I use a generic "auditor" login who owns the Audit database. That will allow it to create...

In case you decide to go the Event Notification route, here's a generic sample of how to implement it. All this does is maintain a table of logins and...

I'm not using logon triggers, but I did deploy login auditing using Event Notifications and Service Broker. I liked that it was asynchronous and wouldn't impact the end user...

If all you're doing is updates, you can so this with an update trigger and a single update statement:

The trigger:

ALTER TRIGGER upd_PayrollEmployee

ON Payroll_employees

AFTER update

AS

IF COLUMNS_UPDATED() & 2 = 2

INSERT mylog...

Have you tried enabling MARS?

http://social.msdn.microsoft.com/forums/en-US/sqldataaccess/thread/1647d29f-1007-4d25-9f0d-1457e7c630a1/

Probably not the best solution, but you could create 2 jobs, scheduled to alternate every 2 minutes. Curious to see what others say as far as an explanation.

Hopefully this question is resolved by now, but just in case (and for future reference) I've found the percent complete column of Adam Mechanic's sp_whoisactive to be extremely helpful in...

What version of Management Studio are you using and what version of SQL Server are you running Activity Monitor against? I ask because that's not the same query I...

Thanks, Elliott.

This is a SQL Login. Unfortunately, even securityadmin isn't enough to view database users.

No, and you'll have to forgive me, I'm not very knowledgeable about Reporting Services. I create very basic reports, but I create a lot of them. I end...

Thanks for the ideas. I think I've got a solution that works:

$s=Get-WMIObject -query "select * from Win32_ComputerSystem" -ComputerName $server | select name

if ($s -ne $server) {

Write-Output "$server is clustered"

}...

I park in a lot that's about a 15 minute walk from my building. Why? Because I'm cheap and it's only $20 a month. Within that lot...

Thanks. I saw that, but it didn't really clarify anything for me. 🙂

We're not using LOBs in this database. Can you explain what, exactly, that first sentence...

Thanks Dan. I have perfmon collecting a number of stats right now, as the users plan on running some more tests overnight, so I'll have a better look at...

I just wanted to post a followup to this for anyone looking to do the same thing. I went with the log shipping option and did the rename and...