Connect 2 databases on 2 servers ??

Hi,

If you have 2 databases with the exact same table columns, and in the first database in a table column the indentidy seed starts at 1 and finishes at 32,000 can you attatch a second database so that the indentity starts at 32,001and carries on.

What happens if you create a site and run out of disk space and need to attach another database which is located on another server?

I am really confused about this.Hope someone can give some links to some articles about this as I can't find any information about it.

How can this be done?

Thanks

robinwilliams:

If you have 2 databases with the exact same table columns, and in the first database in a table column the indentidy seed starts at 1 and finishes at 32,000 can you attatch a second database so that the indentity starts at 32,001and carries on.

Yes, you can!
Just use DTS (in SQL Server 2000) or SSIS (in SQL Server 2005) and while trasfering the data select the "Append Data" option, but make sure the data type of the identity column in the source table is able to deal with new records (have enough size) [e.g. make it INT].

robinwilliams:

What happens if you create a site and run out of disk space and need to attach another database which is located on another server?

What do you mean by another server? Is it physically another server (e.g. using another disk)? If yes, the database files (.mdf, .ndf, .ldf) will be in that server using its disks which are diffrent than the ones have no enough space.
Once you are runing out of space, you will receive error indicating that (e.g. in Enterpise Manager or Management Studio), So always have more space than you need by 2-4GB at least.

Good luck.