I am manually partitioning my database according to the Domain model of the business (Users, Accounts, Shows, etc).
Anyway, at first all these databases will live on the same server. Eventually, they will be broken out onto their own servers. I'd like to avoid using dynamic SQL for all my stored procedures and I'd also like to avoid having to go back and recode all the stored procedures in order to add the linked servers. My idea was to set up recursive linked server connections which will eventually be updated and pointed to the separate DB servers.
1) is this possible?
2) is there a better way to do this?