31 มีนาคม 2552 19:07I downloaded the Northwind and Pub examples, after having installed SQL 2008 Express, and with respect to Northwind there is no problem but I can't connect with the Pub database. With respect to Nortnwind there is both an mfd and an ldf file, but as to Pub there is no ldf file. I understand that this may be the problem. I have installed the download three times but with the same result. I hope someone can tell me how I can resolve the problem.
1 เมษายน 2552 5:01ผู้ดูแลHi Ernie,
If you create the database using the CREATE DATABASE....FOR ATTCH method, you will be able to attach a single-file pubs database.
Let me know how it works out for you.
Aaron Alton | thehobt.blogspot.com
1 เมษายน 2552 19:07Thanks for the advice Aaron. I discovered that there was a pubs.ldf file after all, but it somehow was put into a different folder. When I transferred it to the right folder I was able to attache the database with no trouble. As a result, I did not have to try your interesting suggestion to create the database.