View Complete Post
I am using VS 2010 Professional with SQL Server 2008 Developer. I right click on the App_Data folder in solution explorer and add an existing item, then navigate to the correct database. However, I receive a pop up that Access is Denied. How do I fix this?
In Server Management Studio, I am attempting to attach a database. After selecting the database in the wizard
I receive an error: This file is in use, Enter a new name or close the file that's open in another program.
I don't have SSMS open, and have restarted the computer to make sure the memory is cleared. Not sure what to try next. Any ideas?
I used C# Linq to Sql to create a database. I look on the hard drive and the database .mdf and .ldf files are there. I open Server Management Studio 2008, attach to SQL express and the database is not there unless I actually attach the database.
First, is this correct behavior?
Second, is it possible to create a Sql Express database that is automatically registered(?) in Management Studio? If so, please give pointer.
Thanks very much.
When I try to attach a database using SQL server 2008 express version, it gives me an error message. it says
"Msg 18456, Level 14, State 1, Server LINDA\SQLEXPRESS, Line 1
Login failed for user 'LINDA\Linda'"
How can I fix this error?
I have a group of developers that are creating stored procedures, in them they are dropping a table and re-creating the table and then continuing with the processing. My question is if there is any difference between the effect of dropping a table
and truncating the table on database fragmentatiom.