Freeing up SQL Server in VS 2005
I'm running XP, VS 2005, and have SQL Server 2005 installed, specifically SQL Server Express database in a test project that I am using. I keep running into the problem where I get build errors because it can't copy the database over. I delete the reference in VS, I ensure SQL Server doesn't have an instance running, pretty much trying to kill any reference that I know about it. But, no matter what, I still get that error.
To free that up, what I've been doing is going into task manager, and looking for the sqlserver.exe process that is running under my user account, not the system account ones of course. Once I do that, it builds successfully. Even longer builds that took a while run much, much faster leading me to think that I really didn't realize that it may be a problem for a few things like that.
Hopefully, this helps someone else out.