Some solutions dont'stand in any book, but are also known by experienced people, such as Brian and you probably. So thanks to the ones that share their wisdom!

The suggestions I...

It is very important for me to know exactly if there would be the possibility to make updates to one department without stopping the others, and how it could be...

Hi Brian,

you say in some cases I have the possibility to take a department off-line while others continue to function. This is the matter! We were not sure it could...

Thanks a lot, Michael and Dik.

in which case and why would I lose DRI? in the split case? why? The data managed in global and specialistic database would be different,...

The databases involved would be on the same server, so there's no need to replicate data or to use linked servers. Joins could be made between databases in the same...

I didn't specify the real server name instead of generic 'server1' in the sql. Now it works!

Now I woul like to gather informations from all my ssql servers, and put...

Thanks a lot for your reply, I will try today.

For sure it will be useful!:P