I need to transfer an SQL database from our old server to a new one and was wondering what the most reliable method of doing this is. I’m not sure what/if there are complications with the sa password in SQL 2000?
Any help would be most appreciated.