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

It is an interesting idea. Perhaps a specialized operator like this, adding in more choices for how to solve a particular set of problems is not enough of a boost...

If you have a process now and want to automate it, you'll need to learn to program a bit. I wouldn't do this in .NET, but rather use SSIS. Some...