In SQL, the trigger fires once per transacitons. So if you have a multi-row update, you get one trigger firing. The inserted and deleted contain all the affected rows.

Steve Jones

steve@dkranch.net

Some good ideas. 🙂 Personally, I avoid the phone, though I think I'll start letting my 3yr old answer.

Steve Jones

steve@dkranch.net

Wow, thanks for the responses and sorry for being so late in getting to them. Here's a few thoughts.

I got a message from one person expressing this was not a...

Not sure what you mean? What's in tabletest? You should get the datetimes from the table. Getdate is the server date. Not related.

Steve Jones

steve@dkranch.net

Agree with Antares. Avoid using owners other than dbo in SQL Server. Not sure about Oracle, but it's more headache than it's worth in SQL Server, IMHO.

Steve Jones

steve@dkranch.net

Just a thought. If you are doing this anyway, I'd create a view in each DB that points to the other db. Easier than rewriting lots of queries of the...

Glad we could help. Thanks for the followup, but pls post in the original thread.

Steve Jones

steve@dkranch.net

Not sure MS likes this, but an intersting workaround. Thanks

Steve Jones

steve@dkranch.net

Not sure what you mean? Which records added by the user? In sysusers?

Steve Jones

steve@dkranch.net

If you read my series on Version Control, you will see that I have everything in flight. If a developer is testing something and hasn't scripted it or let me...

Yes and no. In v6.5, it is easier to work with the system tables, but it can be tricky. Is there a reason you don't do a restore?

You can...

Not a bad idea. One I hadn't thought of, especially since most databases only have a single target app. Might be easier to find them that way, though they'd be...

Views tend to be across tables, so a prefix doesn't matter. Personally, I like having the names of the objects associated with the table, next to the table in an...

You msy indeed have to set it twice, but you only do that when you code. The time to set this in code is pretty small. You could also write...

disageee with Andy on this one, but if you choose the DB, make it a separate DB from the data. Easier to backup and manage. Like the filesystem since you...