You shouldn't be using QUOTENAME on the disk location. Just enclose it in single quotes.

You aren't passing any of your parameters to the EXECUTE sp_send_dbmail statement.

Thanks.

What is IFI?

It seems like maybe what you really need is an appointments table. You can figure out the open time slots using the gaps and islands logic. In other words, if...

I would think it would be multiple doctors, each of whom works a different schedule on different days of the week. Then they'd have their own appointments of varying...

Your database is 1/2 TB in size and you have less than 1% unused. I don't see a problem.

An point worth considering here is that sp_send_dbmail is a system stored procedure provided by MS with the product. Customizing it may result in your functionality "just going away"...

First, I would just refer to a temp table by its name and not fully qualify it.

Second, it you're in a loop, you may not need to create and drop...

I really like batch files and I've used them for quite a few years. They can accomplish a lot and are quite a useful tool to have in your...

The database mail system itself has proven itself to be quite reliable to me. We send lots of outgoing mail and it does a pretty good job. The...

I'm pretty sure JKG has done this before. 😀

Grant is right. You can fire UPDATE STATISTICS commands from within a stored procedure. They'll execute and then subsequent statements will get the benefits of having fresh and...

As a word of caution, I believe you can do online index rebuild only with the Enterprise Edition of SQL Server. If you have EE, great. If not,...

That last post makes me think of indexes. Since you changed the code to make things simpler and the database isn't maintained, check to see if the procedure is...