you should be able to just install report services on your new server, and then go into reports configuration manager on that new server and under the database...

No its not possible,

you can do this in Log-shipping though

Date dimension should be fairly easy going for you as the Hierachies are a lot more natural.

If you are able to i would recomend downloading the AdventureWorks cube from Codeplex...

Working 50 - 60 hours a week must be tough though, how do you find time to do anything else?

Absolutley,

back to this weekend however my predictions are;

NZ v AUS = NZ

WAL v FRA = FRA

Fantastic, glad that it is all sorted..

Don't let this put you off building cubes as they are really useful when it comes to reporting.

I know these things can be frustrating, though it does seem like you are close to having it working.

I don't have any time at the moment to look...

Naked Ape (10/12/2011)

Hailing from the rugby (union) mad country of New Zealand I can...

have at a look at;

http://msdn.microsoft.com/en-us/library/ms179314.aspx"> http://msdn.microsoft.com/en-us/library/ms179314.aspx

you could use the 'undocumented' command sp_foreachTable to loop through

but in my opinion the 'easiest' way for me would be to use this code

select 'select * from ' + ...

you dont need to get rid of the data items, just make them not visible..

does your hierachy go from

SchooId -->LEA_CODE --> Phase_desc --> SCH_DFEE

I dont think you...

This thread is almost Two years old, probably best to start a new one with your questions

yes very easy

select table_name from INFORMATION_SCHEMA.COLUMNS

where COLUMN_NAME = 'Companyid'

use

Restore Database DBNAME with Recovery

Sorry I should have included this in my initial repsonse.

its because you used the norecovery option which is used for tail log backups where you intend to restore further logs into you database.