Resource Pool (250 Sharing Links with new SQL server)

[ABW]

I need assistance with my new Resource Pool.

I have approx. 250 Shared links in a Resouce Pool that should now point to a
new SQL server name. So far, I've broken all links by opening my Resource
Pool and using Tools, Resource Sharing, Share Resources and selecting all
projects and I used the "Break Link" option.

Now I need to re-create all 250 links by opening each individual Project and
use Tools, Resource Sharing, Share Resources and choose "use own resources'
and then choose the new Resource Pool from the drop down menu...for EVERY
project!

There must be a faster way to re-create all links when changing servers,
right? Is there a utility or script available to make life easier?

btw, I'm running MS Project 2k3 (Standard edition), with an SQL 2000 database.

Thanks for any suggestions.

ABW

 

[Jonathan B]

I'm confused. In an enterprise resource pool, you typically just list
enterprise resorces. What are the shared links? Do you have tasks in the
resource pool?

 

[Gary L. Chefetz \(MVP\)]

Johathan:

The poster states that he's not using Project Server. Does that help
eliminate the confusion?

--

Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project

-