Yes, create a trigger on the "users" table for insert, so when a row is inserted then it sends a mail via sp_send_dbmail

If you need to create the index, you can either drop the procedure and ensure you have a backup to hand to recreate it. That will prevent anyone running...

There isn't a 64bit version of the Jet driver, you will need to run the package in 32bit mode.

http://sqlblog.com/blogs/john_paul_cook/archive/2010/03/24/running-32-bit-ssis-in-a-64-bit-environment.aspx

You would need to put a trace on your database for a considerable amount of time to gather what queries are run against it, then you will have a rough...

Unless your tracing all your queries you wont know about deletes, for drops if your quick enough you could look inside the default trace, but that gets overwritten quite quickly...

Just like you would any other trace.

Put a filter on the logon column for the logon in question

Does this do what you need?

SELECT DISTINCT TOP (100) PERCENT Date

FROM dbo.RMMarketPrice

WHERE Date BETWEEN dateadd(mm, datediff(mm, 0, @date),...

Just return null? No other data needs to be returned?

What is the expected outcome when it is the 1st of the month?

msdb.dbo.backupmediafamily contains the list of .bak / .trn files that have been created.

Check out Ola's scripts, link in my signature. Might seem daunting at first as its looks complex, but Ola does provide examples on how to use his maintenance tools.

I'd put a caveat on step 5 as it depends on your backup routines. If your doing daily full's then doing a diff wont help if you have waited...

Crude way, but 8 input parameters, 7 IF statements

create proc InsertClassDays (@class char(1), @sun bit = 0, @mon bit = 0, @tue bit = 0, @wed bit = 0, @thur...

Can you give an example of a file path and how you want it to look as a result set?

Your ToDate is 0014, that's outside the scope of datetime