It depends on the logging options you use. If, for example, you just do a heap-dump (all-column-insert) from "inserted" in triggers, you get really fast, really simple logging. ...

Run a trace (or Profiler, I guess), and find out what query or queries are causing the long waits.

You might also take a look at the growth options on the...

You can change that in the connection options in Access. File -> Connection

Jack Corbett (7/22/2008)

---

GSquared (7/22/2008)

---

I recommend against messing around with the code in msdb. Don't change the trigger, don't add one.

Manually modifying that kind of stuff in system databases always...

I recommend against messing around with the code in msdb. Don't change the trigger, don't add one.

Manually modifying that kind of stuff in system databases always bothers me.

I believe you can set up a trace to track that kind of thing.

CrazyMan (7/22/2008)

---

Sorry i dint mention , i am passing 2 parameters to the table,

the View has to check on this 2 conditions and then return the 2 values and...

If there's a trigger-based audit log, that's the place to check. It's not a standard feature, you'll have to find out how it's set up in your particular database.

Otherwise,...

With the little you've given, all I can really say is "make sure you have enough drive space".

The first one looks like it needs a Sum() function in it. Look up aggregate functions, and "SUM" specifically, in Books Online. That should give you what you...

Do you mean you want to have a different reply-to e-mail when you fire off sp_send_dbmail than the one in the profile? If so, I don't think you can...

As a side comment, from the original post on this thread, don't name your procs with "sp_" at the start of the name. Reduces database performance, because that makes...

Since you're not passing any parameters to the proc/view, it should be possible with a view.

I don't have your tables, so here's a generic version:

create view RowExists

as

select (cast 1 as...

You can add a column to the final select with an inline count of the CTE's rows. But if you're doing anything that complex, temp tables is probably a...

Thank you for the compliment on my posts. I try to do my best on them.

No matter how one exposes a server, or what software it's running, if it's...