Hello,

I am unable to get Sql Server 2008 and Visual Studio 2008 to add the diarydb from the source download. I have created the db and associated tables, however, I still need the stored procedures. I'm wondering if the source code for these are available before I recreate the wheel from the program code.

Tom

__________________
Thomas G Magaro

Hi there,

I don't think the code for the stored procedures is available separately. However, you can retrieve them from the database if you can attach it to SQL Server, like this:

1. Create a folder called C:\Databases and copy the DiaryDB.mdf into this folder
2. Using Windows Explorer open the Properties for this folder and on the Security tab provide full control to the Everyone account. This isn't a best practice but works well for this task.
3. Start SQL Server Management Studio and log in
4. Right-click the Databases node of your server and choose Attach
5. Browse to C:\Databases\DiaryDB.mdf
6. In the list of files at the bottom, click the row for the Log file and then click Remove. This way, the LDF will be ignored and the MDF gets attached.

That should do the trick and you should now be able to look at the procedures.

Let me know if this doesn't work for you.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

Hi Imar,

Once again, you have come through. This helps with several books where I recreated the databases for.

Many thanks,


Tom

__________________
Thomas G Magaro