Hello Rashidjilani,

Albeit I still think it might be impossible to find a tool that gives you value for your money or for the time you have to spend configuring it...

Thanx, I had read that

Well, say that user myDom\Joe does a SELECT col1,col2,SUM(col3) FROM BigTable GROUP BY col1,col2 in a OLAP environment (query...

Okay, can it be that with SP2 your computer cannot register it's name with the entity that responds to your SQL Server Request Broadcast (Opening the drop down list. I do...

That is true, I have read the same somewhere in BOL.

But if I recall correctly, that info concerned earlier versions then SQL Server 2000 and from my testing it would...

Sreejith had a very good pointer!

I would add that your DSS table Dates would serve you well (yet again!)

Is the SP deterministic? (Does it always return the same data?)

I never got an answer if it always takes more then one hour to run, if you only tested once...

Mike has good suggestions!

I would come with a follow up question; why would you like to create these files of 'only' 5 GB? If you want to spread fles over...

How much data is returned? Do you try to view the ASP page from another server (maybe the data result set is huge and takes long time to return over...

Does the call from ASP consistently take more then an hour to run? If not maybe you have severe blocking problems.

Are you actually running your stored procedure from ASP and...

Hello,

I have not heard of any similar tool and I cannot really see that an efficient one can exist. Since the data in the tables can be interpreted in so...

Or if there is only one connection modifying the table; you could create an application lock, uphold it until you have done your updates and have your notifications that way.

I.e...

Have you tried to 'ping' it? Could it be some WINS problem?

...and if you actually look at the 'Correct Answer' on the same page as the result you can see the correct answer there and NOT the answer that gave points...

The easiest answer would be:

Read up on RDBMS and how they work and design your tables from there. If performance is a problem denormalize a little...

Then if you want to...

Have you tried to change the RowDelimiter?