Your check constraint is being evaluated after the data is put into the table, so the function is returning 1 because you have added the record. Make the function...

You will probably get a lot of conflicting information on this topic. MS does not seem to want to put anything into this argument other than to say that...

That looks ok to me. I would still take the time to look at a couple of finance systems. A few years back, I worked for a company...

Your InvoicePayments table has an InvoiceID in it suggesting that a payment record could not be for more than one invoice. It could just be that I don't have...

I would suggest you look at a couple of accounts payable systems. They will often be designed poorly, but you should be able to get a feel for the...

Unfortunately, the OUTPUT clause will always return the data from your action, not the trigger. If you have a primary key or something that uniquely identifies your records (which...

That would lean me more toward the variable. Each time you loop, increment the variable (instead of just setting it to 1). When you leave the loop container,...

Yup - we have all worked for the cheap company that refuses to pony up the coin for the correct edition of SQL.

I hope they don't ask you to create...

You can actually do this through reporting services directly. The data-driven subscriptions allow you to specify a list of recipients (and other options such as parameter values) through a...

I would suggest that you create a variable, set the variable initial value to 0, set the value to 1 inside the foreach loop container (it will set it to...

If you wait a few months, SQL 2008 has some system stored procedures designed for change tracking that include both schema and data changes.

You could try pulling the procedures from...

You can run the migration wizard and it will "probably" work, but you will end up with a lot of garbage.  Because of the structural differences in AS2005, you really...

You can set a job agent job to run "whenever the CPUs become idle".  Somewhere I am sure there is information on what exactly that means.  I think you have...

If you have cross-database ownership chaining on, you add some security overhead.  If you are like most and have simply given access to all of the objects in both databases,...

Apparently, the squeaky wheel really does get the grease.