Actually, the Sql Server 2008 DM Add-ins for Office 2007 solve this problem. The documentation is not great, but from messing around I've figured out that you can browse...

Unfortunately that didn't help. I can't find any information on how to use Data Mining Models with SSRS. Everything is about using OLAP cubes with SSRS, not data...

Maybe it is. I didn't know you could use Reporting Services to report from a Data Mining model. I'll look into that. Thanks.

Any other suggestions?

As a broad overview of all the ways to use SQL Server as part of a Business Intelligence solution I really like the book "Practical Business Intelligence with SQL Server...

All in good time.

Eventually we probably will move these into SSIS or, if that won't work for us, rewrite all the scripts to a higher coding standard. For now,...

Alrighty, then.

Thanks for the help. Guess we'll use GETDATE().:crazy:

- Cindy

This is a data warehouse database that feeds an analysis cube. The data loads are often millions of rows, and we don't want to use triggers.

We would certainly prefer to not use triggers, even if they worked.

I guess, if we have to rewrite the scripts we'll rewrite them. The two ways I've worked...

See my explanation above as to why I am remoting in. As to moving them to the same drive, it's not actually the same drive. I was simplifying...

Great idea. Thanks. I'll discuss that with the team. And thanks for the link.

- Cindy

Good question. I work from home, connecting to my company through a VPN, and there is a SIGNIFICANT speed difference when working on my laptop with the client vs....

Well, thank you very much for your help.

- Cindy

Sweet! That did the trick. Thank you.

I need to find some documentation of this issue for our server admin folks. Specifically documentation regarding this as a database...

OK, there was a large temp file in C:\Documents and Settings\myusername\Local Settings\Temp\15. When I closed the query window that went down to 0.

Any idea where that comes from and...

I had RDC'd to the server itself and was running some ad-hoc queries in SQL Server Management Studio.

And the exact error message was:

"An error occurred while executing batch. Error message...