Thanks for the reply. The local server is SQL 2000 SP4 and the remote (DB59) is SQL 2005 SP2

Sorry, posted before i had finished.

DB59 is a remote server but on the same LAN, we have no control over the field names (or I would have removed the damn...

Hello,

Thanks for any replies, I have found the problem. Our AD replication wasn't working so any permission changes on AD accounts weren't replicating for about 13 hours. Once they replicated...

Thanks for the replies.

I have used 2 seperate SQL cluster names in case one was corrupt, no joy. The cluster account domain admin was very temporary. I have found other...

I pruchased this book for 431, learned it, took the mock tests that are on the cd with the book and took the exam:

http://www.amazon.co.uk/MCTS-Training-Kit-Implementation-Pro-Certification/dp/073562271X/ref=sr_1_1?ie=UTF8&s=books&qid=1264770253&sr=1-1

This is the best way...

Thanks guys, I will give theses a try:-D

This is correct, I am in the middle of doing the same, I have done 431 and 443 just 444 to go. I would also recomend the Microsoft course books,...

Hello.

You need to set the memory to be dynamically managed by SQL server. In management studio right click the server and select "properties", click the memory page and on the...

There is no issue with retreiving data from a clusterered SQL server when Analysis services is installed on another server, I have recently had to do the very same thing....