I am new to MS SQL Server Express 2008 and have a couple of questions:
In my project - I wish to migrate my existing Access (MDB) database to SQL Server. I have tried converting it using Microsoft Access, but its telling my cannot find database or not correct security settings. Where can I go to change my password - When I installed I opted for windows authentication - I would imagine this would be windows username and password?
Secondly, I am looking for some code to create a new Sql Server database using the ADO Command object.
Finally, what is the easiest way to backup SQL Server Databases - Is there a way I can store all data within one file similar to MS Access databases?
Thanks for the help.