The trigger is part of the update. The update is not complete, and locks cannot be released, until the trigger completes. A Waitfor is a horrible idea in the trigger.

Jason's...

SanDroid (4/1/2011)

---

lol...

The second I saw Big Table I knew.

No offense Steve, but they are tight with that technology and something tells me this is not something they...

TravisDBA (3/31/2011)

---

I was not just referring to small mom and pop shops, I was referring to large geographically distributed IT enterprises as well, and it does happens more than you...

ROFL, that is outstanding! 😀

Can...

Craig Farrell (3/31/2011)

---

Tom Bakerman (3/31/2011)

---

This seems like rehashing old news. I have vague memories from a database class I took in the 80s where we talked about an airlines...

April Fools! Everything is a joke today. We'll be back to normal on Monday.

If you don't have experience and you have a cert, it makes me think that you are motivated to get a job, but won't necessarily have any talent. If you...

Glad you liked it. I'll edit it tomorrow to add "April Fools" at the top, but it's a good one for today.

I will look at this later and likely clean up the points. However from my reading, the view is created. There are no indexes on it, so the only...

I also fail to see why an identity in the primary table doesn't work. In the audit table, would it not be the identity plus a datetime?

Have you tried uninstalling and reinstalling the tools? Perhaps there is something corrupted in the installation?

I assume you are logging on as an admin, correct?

You haven't asked a question, nor explained what you are trying to do and what is happening. Reconfiguring log shipping isn't detailed enough, and "timing out" doesn't clue us in...

To follow on from the Ninja, the SQL Server database engine service account must have permissions to read/write in the new folder. Your account permissions do not matter. When you...

Have you verified that you are sysadmin at the time you run this? What does this give you?

SELECT IS_SRVROLEMEMBER('sysadmin');

from http://blog.sqlauthority.com/2009/04/14/sql-server-check-if-current-login-is-part-of-server-role-member/

Or this?

SELECT * FROM fn_my_permissions(NULL, 'SERVER');

http://msdn.microsoft.com/en-us/library/ms176097.aspx

With mirroring, you cannot access the Mirror. With Enterprise, you can create snapshots, but updating those requires them to be dropped and recreated. There is no "freezing" of the connections....