It's important to log into the machine as the account that starts SQL Server before you configure any mail.

Also, there used to be an issue with NT and SQL Server...

I do BI for a living and I agree with bnordber. The users are the best source of naming conventions for BI deliverables. I've also found that different user groups...

How about a cursor-driven "SELECT TOP 1000 * INTO..." statement. You could script the source DB, remove the CREATE TABLE statements, run the cursor code then use the script to...

There's a small book from Cognos called "The Multidimensional Manager" that give a good, non-technical overview of OLAP. The book is really a sales tool (I'm a Cognos partner), but...

Sometimes the decision is made for you. If you need to track Type 2 slowly changing dimensions, then surrogate keys are required. To get "current" data, create and index on...

I recommend Cognos products to my clients if they don't want to deal with Crystal. The whole report development/distribution process is much more intuitive.

Don

http://www.biadvantage.com

Saari,

From what I can tell here, personal attacks and name calling are normally frowned upon. We all come here to share information, and hopefully learn something.

I'm currently evaluating Crystal as...

Scorpion, thanks for the great explanation. I also have converted DTS packages to BCP. Not only is it a little faster, but I hate the "black box" of DTS.

You mentioned...

Is Active Reports the software produced by Data Dynamics? If so, it looks like something worth checking out.

Don

Don

http://www.biadvantage.com

As an aside, can anyone explain why someone would require a stored procedure when it's so easy to use DTS? Could it be portability?

Don

I'm a little prejudiced as a reseller, but Cognos has two tools that report well off of SQL Server. One is an OLAP tool called PowerPlay. The other, called Impromptu,...

Check out "Disconnected Edit" in Enterprise Manager. I haven't used it, but many properties are exposed.

Don

Thanks Clive. I'll toy with this code for a while.

Don

That sounds like a good idea. I'm a little weak in VBScript, though. Can you give an example?

Don

That sounds like a good idea. I'm a little weak in VBScript, though. Can you give an example?

Don