Its been about three years or so since I worked with my website design and SqlExpress. I can't remember how I used to open my databases and look at my tables. Can someone refresh my memory? I have ASP.Net 2008 and SQL Server 2008. I'm not sure if I'm supposed
to open the Sql management program and "Attach" the database or something else.
Thanks. I finally figured out how to do that. I just wasn't sure when I went into the Sql studio, if I clicked "attach" or not. But that work to allow me to look at my tables. The data was all encrypted tho so I didn't learn anything there.
RaeKC
Member
101 Points
366 Posts
I forgot how to do this!?
Dec 04, 2011 06:48 PM|LINK
Its been about three years or so since I worked with my website design and SqlExpress. I can't remember how I used to open my databases and look at my tables. Can someone refresh my memory? I have ASP.Net 2008 and SQL Server 2008. I'm not sure if I'm supposed to open the Sql management program and "Attach" the database or something else.
snsprint
Member
39 Points
25 Posts
Re: I forgot how to do this!?
Dec 05, 2011 02:44 AM|LINK
You can use the SQL Managment Studio program, but the easiest method is to use the 'Database Explorer' in VWDE to open your DB.
jassi_singh
Participant
1713 Points
419 Posts
Re: I forgot how to do this!?
Dec 05, 2011 03:58 AM|LINK
Hello,
You can use SSMS to connect to your databse and explore it.
RaeKC
Member
101 Points
366 Posts
Re: I forgot how to do this!?
Dec 05, 2011 01:08 PM|LINK
Thanks. What does VWDE stand for?
RaeKC
Member
101 Points
366 Posts
Re: I forgot how to do this!?
Dec 05, 2011 01:09 PM|LINK
Thanks. I finally figured out how to do that. I just wasn't sure when I went into the Sql studio, if I clicked "attach" or not. But that work to allow me to look at my tables. The data was all encrypted tho so I didn't learn anything there.
snsprint
Member
39 Points
25 Posts
Re: I forgot how to do this!?
Dec 05, 2011 01:43 PM|LINK
VWDE (Visual Web Developer Express) is the free version of the web developer that is included with Visual Studio.
Banwari
Member
44 Points
106 Posts
Re: I forgot how to do this!?
Feb 01, 2013 02:03 PM|LINK
Go to sqlserver 2008, figure out sql server managment studio.
Set database and right click for attaching other data select from specific destination and go ahead.