Modeling tools give you that option!! You specify your schema in the Model, all the definitions and all the constraints then all necessary information is already there.

If you need...

OK let's change your perspective a little.

What would the xp do if is is called?

Does it need the updated DATA?

is the XP re-entrant?

if Fundamentally all you need is that...

The Problem with this question is that is trying the INVERSE Approach. Only using Modeling tools you can get that information but then again you are pusching the Model to...

Very Good!  ... just a minor slip

Select col1, col2 from dbo.Employees E inner join dbo.Customers C on E.FirstName like '%' + LEFT(C.ContactName, 3) + '%' and LEFT(C.ContactName, 2)...

I think that to start a job from a trigger is BAD!!!!  SQL Server Jobs are NOT re-entrant. Yes, they execute asynchronuosly and in a different process but if the...

Not sure what is exactly your question.

1. You Know on the server side what error message is going to be generated because you know the Error Code (specially for numbers...

I agree 100000% (not a typo!) with the author of IS XML THE ANSWER ?

You can get a point of view there and read the extensive discussions underneath it

Good...

All along, I thought that SQL couldn't have been the culprit!

It has been my experience that it is the DB the first one to get blamed, though 

David,

Not too sure about the nitty-gritty of the command but I have found it to be very usefull when performing BIG deletes !! (Trying to avoid GHOST PROCESS)

In simple recovery...

1) Keeps current day

2) Differentials will speed up the recovery eventhough you can use just the logs

3) If you are doing this from EM it will disregard the log activity...

Denise,

I have to admit this is very unconventional (sending the mdf/ldf to the vendor) but if on top of that you are expecting viruses from them I think you have...

I didn't even look at the trigger code! You are absolutely correct.

Don't mean to bash anyone but I have lost the count of people that code ther triggers for...

are you doing this?

SET XACT_ABORT ON

BEGIN DISTRIBUTED TRANSACTION

-- Your queries in here

 .....

---

COMMIT TRANSACTION

SET XACT_ABORT OFF

You need ALL that. If you are not declaring...

Perfectly Ok! 

The main problem is that you are mixing two syntaxes you need to stick to one.

ex:

select 

         Lplannum As "Plan Number"

       , Loan_Num as "Loan Number"

       , Branchd as "Branch"

      ...