Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Merging different Sort orders, help needed?

Status
Not open for further replies.
tdoma

tdoma

IS-IT--Management
Aug 13, 2003
94
US
I am fairly new to this.
We have 2 SQL Server 7.0 boxes that have 2 DBs with different sort orders. We would like to consolidate the 2 DBs onto one server. It is my understanding that if we were to upgrade to SQL2k we can change the sort orders to match. Is this correct? Or would it be possible to run the 2 DBs on the same SQL2K server using the 2 different sort orders as they stand now? If we were to make the sort orders the same do we need to rebuild the Master DB?
Thank U in adavance.
 
Status
Not open for further replies.

Similar threads

awaria
  • Locked
  • Question
Automate nightly database data transfer between SQL environments on different servers
Replies
3
Views
118
fredericofonseca
fredericofonseca
basball
  • Locked
  • Question
re: can't see mssql.1 in dos window on 2008r2 - help : (
Replies
5
Views
161
philhege
philhege
bfordz
  • Locked
  • Question
sql server newbie, needs help, sqlagent won't stay running
Replies
14
Views
439
SQLBill
SQLBill
TheBugSlayer
  • Locked
  • Question
Moving SSISDB from C:\ to a different drive. Advice needed.
Replies
1
Views
212
TheBugSlayer
TheBugSlayer
OLAPanalyst
  • Locked
  • Question
Need help - deleted did not detach database
Replies
2
Views
89
SQLBill
SQLBill

Part and Inventory Search

Sponsor

Back
Top