I would like to know what's the best tool for administering my local Microsoft SQL Server. Currently I'm using the Database Explorer which is integrated into Visual Web Developer 2005 Express and a seperate program, Microsoft SQL Server Management Studio Express. However I had some problems:
1) I could not figure out how to insert a new line into a dataset. (Pressing enter moves the cursor down to the next row, other combinations like Ctrl+Enter, Shift+Enter don't work either)
2) I want to be able to export/import data (for example CSV or XML files), but could not find such a function.