All of which are why I suggest a trace.

And don't worry too much about a server-side trace (the kind I'm talking about) taking a lot of server resources and slowing...

Glad I could help.

In my opinion, the negatives for SQL Server are far outweighed by the positive aspects. It's simply that perfection is unattainable, so taking something great, you can always find...

Have you thought about using replication, and setting up SQL Express on the laptops? It's going to be easier than constantly creating and synching Access databases.

If you have to...

Yeah, it was something in that range. I don't have access to that database any more (since it was for a company that no longer exists), but it was...

Since it's timing out on the login, I suspect that it's not being passed a password and/or username, and it expects one. Might need to be part of your...

The first thing that comes to mind is why select from the target table joined to "inserted", when you can just select from "inserted"?

The next thing is that you could...

It generally won't do 20 scans in that case. The optimizer is usually smart enough to figure out that one scan will do it. The only times I've...

Have to agree with you on that Joe. Just want to be sure that people who follow standards understand that doing so will not be a panacea, and will...

Don't run profiler for the traces. Create them separately. Search for "trace" in Books Online, and it will come up with "Introducing SQL Trace". Specifically, you're going...

To clarify:

I set the output to Text, created a couple of triggers, and ran the query. Here's what I got:

create trigger Numbers_NoDel on dbo.Numbers

instead of delete

as

rollback;

go

create trigger Numbers_NoUpd on...

If you want one file per trigger, you can do that from scripting the database. Right-click on the database in Management Studio, select Tasks, Generate Scripts, and then pick...

bbaley (1/23/2009)

---

Just to beat the dead horse deader.......

Since we were talking about logic on the application side vs. logic on the db side...

seems I always end up in some...

There's a Copy Files and Folders option on that. Just use that. It's pretty straightforward.

How about something like:

select definition

from sys.sql_modules

inner join sys.triggers

on sql_modules.object_id = triggers.object_id

Does that give you what you need?