<div>
EXEC sp_attach_single_file_db @dbname = 'AdventureWorks', <br />
&nbsp; &nbsp;@physname = &nbsp;'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\<wbr />AdventureW<wbr />orks_Data.<wbr />mdf'<br />

</div>


EXEC sp_attach_single_file_db @dbname = 'AdventureWorks',
   @physname =  'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf'


<div>
I don't know why this worked, buit it did.<br />
Thanks,<br />
Jim Botts
</div>


I don't know why this worked, buit it did.
Thanks,
Jim Botts

<div>
<div class="content wysiwyg-content">
Experts: I am trying to attach the sample database AdventureWorks to an instance of SQL Server 2005 Express. Using the following code:<br />
USE MASTER <br />
GO<br />
<br />
CREATE DATABASE AdventureWorks<br />
ON PRIMARY (FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\<wbr />AdventureW<wbr />orks_Data.<wbr />mdf')<br />
FOR ATTACH<br />
GO<br />
<br />
I get a message:<br />
Msg 5120, Level 16, State 101, Line 2<br />
Unable to open the physical file &quot;C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\<wbr />AdventureW<wbr />orks_Data.<wbr />mdf&quot;. Operating system error 5: &quot;5(Access is denied.)&quot;.<br />
<br />
I have checked the properties of the file and it is not read only. Would appreciate your assistance.
</div>
</div>


Experts: I am trying to attach the sample database AdventureWorks to an instance of SQL Server 2005 Express. Using the following code:
USE MASTER 
GO

CREATE DATABASE AdventureWorks
ON PRIMARY (FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf')
FOR ATTACH
GO

I get a message:
Msg 5120, Level 16, State 101, Line 2
Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf". Operating system error 5: "5(Access is denied.)".

I have checked the properties of the file and it is not read only. Would appreciate your assistance.

How do I attach a database to an instance of SQL Server 2005 Express?

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.