Look at the properties of the server in analysis services view and check to see if a server timeout value has been specified on the processing tab.

You may need...

Thanks. I did think about that but we have a flaky change control system here at best and I want to keep all the dts packages on the production database...

This is usually true of 99% of threads relating to your transaction log problem.

To reduce the size of the transaction log backup, switch to bulk logged mode before you start...

You need to transform the data before it is imported in by using an active x script.

In case you do not know, click on the transformation tab and select new....

nyulg is quite correct. There is no way the optimiser can use an index to search for a string begining with a % sign.

If you are getting users performing these...

You will probababy find your code is generating the tablename without single quotes.

Script below will work for you and is quicker to run for tables with large counts.

/* declare variables...

There is no reason why you cannot use reporting services by coding in asp.net right now. Also, from what I have read .net will be a major factor in sql...

You need to write an mdx statement to achieve this in analysis services.

Here is a link to a site that should be able to help you out. Look under the...

Try this out. You have to declare the sum total as a decimal as it will not work as an integer for some reason.

create table test_prods

(name varchar(20), amount int)

insert into...

Out of curiosity, why do you need the test database to be so up to date?

If users are looking to work on real live records that they worked on the...

If you really want to run DBREINDEX and keep transaction logging to a minimum switch to bulk log mode first. It does save you quite a bit of space (30%...

I think that the issue of third party front end tools is practically irrelevant because all the major BI Tools out there are platform independant nowadays. I accept that Microsoft...

Have a look at Embarcadero Change Manager.

Excellent to use and very easy to set up.

Go to this page and look under the heading 'Migration Facility'; you can peform multi-target migration,...

I've never looked into using partitioned views, so that may be the way to go.

However, to get this thread started, I suggest you have a look at Microsoft Message Queue...

Never looked into any scripts for this particular job personally.

I use enterprise manager by right clicking on the database and selecting ALL TASKS/ GENERATE SCRIPTS and then picking from the...