I created a SQL Server 2008 Express database about a month ago. I did a heck of a lot of work setting it up, populating it with ~100 tables, SP's, etc. At the time I created it to only use Windows authetnication. Eventually I want to write
a WPF app to use this database, but for now I wanted to write a simple app that would just open a single table and return all of the rows from the table, using VS 2010. I've had a really hard time doing that (as in it was imposible). So I changed
the database mode to allow for both Windows authentication and SQL authentication, and then I created a couple fo SQL logins/users, and gave them access to the SQL Express database. That is as far as I've been able to get to it, due to work loads/demands,
I've not been able to work on this project for several weeks.
Now I'm trying to get back to this and work on it. My first thought is to get into SSMS (I have SQL Server 2008 R2 Developer Edition ins ...
Go to the complete details ...