Alright Jeff....you're making my brain hurt.

I'm humbled by your formula....would you be so kind as to 'splain it to me?

Now that's genius. I knew there would be a way to do this without a function, but time constratints kept me from persuing one.

Thanks Jeff!

That is a valid scenario where you'd consider shrinking the file. You want your log file to be sized appropriately to be able to handle your normal daily processing...

This would be very easy if you had a dates table in your database. Another option would be to use a UDF to find the last day of the...

You mean include the Row Count inside the email message....yes. You'll need to use the expression builder to build out the message body property (MessageSource, I think) and include...

Future

Verbose

That would be a good compliment to me...

This should work, but I'd recommend adding a Primary Key constraint on your table and correcting whatever INSERT process is creating the dupes.

DELETEst

FROMstudent_test st

INNER JOIN(

SELECTstudent_test_id

FROMstudent_test

GROUP BYstudent_test_id

HAVINGCOUNT(*) > 1

) t2 ON...

You can't send the mail from the data flow. Just populate the variable and then use an expression in the precedence constraint to evaluate the variable and envoke the...

Red

You should be able to capture the events via SQL Profiler.

In addition to Craig's....

It makes database changes and tuning so much easier. From a DBA's perspective, you need to maintain the ability to make DB schema changes for performance,...

Well, they say the 2 best ways to learn are mistakes and mentors. Here at SSC, you'll find both. I will have to say though that it is...

I don't think you'll find that anywhere. Why don't you just put some data logic into the SP around the VERIFY command?