Most of your questions are answered here:

http://www.pinaldave.com/sql-download/DataWarehousingInterviewQuestionsAnswers.pdf

Regards,

Manish

I have a comparison chart of Enterproise and Standard edition which also says that the number of instances supported are 50 and 16 respectively. 🙂

Who can confirm this?

Images are available now. Thanks!!!

The article mentions that using script task is simpler if the required mail functionality is complex.

Example: I need to send to 100 recipients one by one with different messages and...

I have resubmitted the article with images to contribution center.How will it be updated?

I posted the images also with the article.

What should I do now? Shall I post the article again to contribution center.

Yes. while sending mail, you can store sent datetime and To address in database or log it in a text file using variables used for these field values.

Thanks Grant!!!

Thanks Jack!!!

Actually I need to build a dynamic query where number of WHERE statements in CASE will depend upon number of records in a given table.Do having a large number...

Thanks Michaela!!

I wanted the history of the SP which is already modified few times during last 2-3 weeks.But this will help me to track it in future.Thanks for your great...

Thanks Tracey! But that shows history for around 10-11 days only.I need around one month history.Can you plz help me with this?

Thanks David

In stored proc we place the Go only at the end of the procedure.

Go marks the end of batch and sends the part from last started transaction point upto this...

The recording of these sessions should be posted on SSC so that those who cannot enroll or attend these session can go thru them when they can.

Are you on production server?

Else you can delete the log files as these files do generally take a huge space over the period of time.