If there aren't too many tables you can use Ent Mgr: go to table, right click, design, then use the manage relantionships button to pick a new filegroup.  Bear in...

Does the DB name have a special character in it that you wouldnt be able to use if you created a directory manually ?

Hi, if you dont get any other response or you need to fix quickly, I have had a few issues in the past with setting up log shipping and found...

Forgot to ask...What account starts the SQL Agent service and what access does it have on the server and SQL.

Are you saying you can log into the server via Ent Mgr as 'sa', but when you right click and start or stop the SQL Agent you get an error? ...

Well I've found the answer to my own probelm from the MS Support Centre site.  Apparently this is a bug and the only way to get round it is to...

Getting a liitle closer I think and have ruled out security.  If I log on to another PC with SQL2005 installed I can use activity monitor and see SQL2000 servers...

Thanks for your response guys.  I dont think its anything I need to change on the 2005 side as they are 2000 servers I'm managing so I'm guessing schemas shouldn't...

Just for info you can save the package in the same way but directly to another SQL server as well.  Just put 'SQL Server' as the location and type the...

That seems to have done the trick!!  Thanks ever so much for your persistence Jo 

Hi Jo, thanks for your help on this.

Excuse my ignorance but I dont quite understand what you mean by the first statement (ie filling the variable with a loop?)

What I'm...

Thanks for that Jo,

The problem with this is that the set @statement is creating a statement such as

select ust980101 as [Server], plunum, pludesc  etc....  Instead of swapping the @server_id for...

Thank you both for your replies. 

I had looked at sysservers but I want to run the same query on all servers from one server that has all the 'linked'...

Thanks for that Wesley

Thats just what I wanted, thanks David!