The only way that could be happening is if the ASP app is deleting from both tables. Can you find the delete statements that it's running? Use profiler if you...

With the table defs and foreign key that you've posted, that's not possible, unless there's an explicit delete been done from both tables.

-- using the definition posted above

INSERT INTO CMFP...

Seems to be continued here: http://www.sqlservercentral.com/Forums/Topic588073-146-1.aspx

Very hard to say without knowing what you're trying to do. However, as was said before (http://www.sqlservercentral.com/Forums/Topic586167-145-1.aspx), the multi-statement functions tend to perform rather badly, so do be careful with...

Duplicate post.

No replies to this please. Direct replies to:

http://www.sqlservercentral.com/Forums/Topic588085-149-1.aspx

They're used to do row-by-row processing. In general, that's a very poor way to do things in SQL, as the database engine works better on sets to rows than multiple...

What do you want to do with said trigger and why do you have to use CLR?

Um, can you maybe give a bit more info? What do the tables look like? What are the foreign key definitions? What are you deleting?

That's a combination I generally refer to as a waste of time. The shrink will cause massive fragmentation of your indexes, easily...

There definitely is a SP3 for SQL 2005 on its way

In my opinion, guest should have no rights at all in the DB. Logins that need access to the DB should be granted access and have the exact permissions they...

Doesn't matter what database it's in.

What's the question?

That's a display issue, not a data issue. That kind of thing should be done in your application/report, not in the database.

You can set the grouping levels in the report...

You may want to set the end time to be an offset of the time the script runs. Something like

SET @DateTime = DATEADD(hr,1,GETDATE())

if you want the trace to run...