There's also Jason's scripts from this article: http://www.sqlservercentral.com/articles/sp_who2/70222/

Or you might check into WhoIsActive: http://sqlblog.com/blogs/adam_machanic/archive/2009/03/30/who-is-active-v8-40-now-with-delta-power.aspx

Nice notes. We'd love this as a one page article, describing the problem, how you solved it, how it works, if you're interested.

In terms of the question, I'm not sure...

It was interesting to query things. Fortunately SSMS has that row number thing on the left to help with the counting 🙂

What do you mean it only lets you migrate to Access? Can you set this as a source in SSIS?

I would question that is has to run as "sa", but I wouldn't be surprised. The developers at MS do make shortcuts, and it could be hard coded.

However it also...

dbowlin (7/9/2010)

---

Like most of you I probably won't stop 'till I drop. Even then the bills may keep coming.

I am not sure whether to attach a 🙂 or a...

Short week.

My wife said she was glad we made it to Friday this week. Since we were in Vegas M-Thur am, I was surprised. Started to comment, decided to "smile...

Actually I can't count. But I can query.

3 times in Feb 2010, 1 time today 😛

I thought this was interesting, especially after previous auditing solutions were one way or the other (never shut down/always shut down). Good to be able to set up some audits...

You can still record the events locally on DB2. Detect them, store them in a local table on the db server, with a timestamp, and then query that from DB1....

I think Alvin has pondered that quite often. He's used "Flux Capacitor" four times this year in this thread.

I like the last suggestion. Set the column to null, only update if it's null. That will also tell you if the value has ever been updated.

inserted is a table created for a trigger with new values when you insert or update a row.

If you want the old value, you would create a trigger that actually...

I like Tara's suggestion. If you are using DB1, let that do the work. If it's down, doesn't matter if DB2 does anything.

However, I would rather have you find some...

SSIS can handle the import. The T-SQL part would deal with data once it was inside SQL Server. Basically

1. SSIS has a loop/file watcher to grab files and import them,...