MS SQL 2k in both environments. I am a beginner at SQL but don't wish to delve too far into it as it is not really my focus. We backed up a database and tried to restore it onto a new SQL Svr but it can't find the originating domain accounts so it no likee.
I just want to focus on the data itself now and export it to a file and then import it into the new database so we can move on with our task. What is a "flat file" and is that the method we should use? I need a quick step by step and know it can't be that hard to do. Please help. Thanks experts!