I need a hand converting my SQL Server 2000 DB into a SQL Express 2005 DB. I would do it by creating a backup from my current server and restoring it onto Express... The problem is, I need to use this DB from ASPNET.
I know you can have an APP_DATA folder and store your DB in it. That's what I'd like to do... I just don't know how to connect to that file from within SQL Server Management.