Nevermind. I finally figured out how to make the stupid Conditional Operator work correctly. It kept complaining that I couldn't use a LEN() function in conjunction with a string. a...

My thought on this issue is that the server still thinks something's wrong.

Announce to your users that you'll be taking the server down for maintenance on X date at...

And don't forget to check the size of Model too. TempDB is created off the settings on Model (all databases are) and if Model was changed, than all dbs will...

Hee.

Thanks, Steve. I appreciate the support.

Brad,

I too am a fictional writer, so I understand the pains you're going through. However, most people who publish code solutions on the internet usually do so with the expectation...

Ahh. Okay. That makes more sense. @=)

????

SQL Server shouldn't require SSIS in order to use database mail. SSIS SMTP mail should be completely separate from the database engine SMTP mail.

You should report this to Microsoft. Those...

I didn't even think about that. You're probably right. @=)

That tells me the issue is with the mail server, not SQL.

Ah. Okay. I think I'm getting it. But here's a sanitized version of the main summary (Fact) table:

Create MyTable (ReportType tinyint, BeginDate datetime, EndDate datetime, PayType varchar(20), BatchNumber int, PayeeID...

Taking FULL backups of your main server should not interupt the log shipping process. So long as you continue to restore the logs to the LS server *in order*. EDIT...

There's no good answer to that. It depends on your hardware, your server configuration, and how much parallell threading you allow the server to do.

If you absolutely need a number,...

Not quite sure what you...

Have you checked the mail server name? If the SMTP mail server isn't working, then SQL Server would queue the emails and not realize anything is wrong.

Also, it could be...

I'm not missing detail values so much as the details are even aggregated. I know that sounds odd, but that's the way it is. Say you have an order with...