Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 how to view DB architecture in sql 2005??

Author  Topic 

mojpro
Starting Member

15 Posts

Posted - 2007-04-17 : 01:11:20
Hi Guys,
I am new in SQL server 2005, I got Vista and installed Express editiion 2005... how can I see the DB architecture, how can I edit my DB???? I do not see that option in SQL server config mamager? Please advice...
Thanks billions...

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-04-17 : 01:15:23
did you install SSMS Express? it's a free GUI that you can use to manage SQL Server Express. with that you can create tables, etc using a gui.


www.elsasoft.org
Go to Top of Page

mojpro
Starting Member

15 Posts

Posted - 2007-04-17 : 01:18:27
Thanks much,
I installed express edition it is GUI, but it doe snot show any option to modify db structure or to view it...
it just shows if the service has started or not...
Go to Top of Page

mojpro
Starting Member

15 Posts

Posted - 2007-04-17 : 01:19:55
I just want to be able to create a DB and mainatain it through vista..
Go to Top of Page

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-04-17 : 01:52:38
You can do more with SSMS express that just stop and start the service. you can create tables, execute queries, etc. probably you didn't install it. get it here:

http://msdn.microsoft.com/vstudio/express/sql/download/


www.elsasoft.org
Go to Top of Page

mojpro
Starting Member

15 Posts

Posted - 2007-04-17 : 01:55:08
You are so sweet,
I realy do not know to how to appreciate it... :)

Thanks billions again..
Go to Top of Page

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-04-17 : 02:00:54
wow. are you coming on to me?




www.elsasoft.org
Go to Top of Page

mojpro
Starting Member

15 Posts

Posted - 2007-04-17 : 02:02:19
I just installed it and you have to see a big smile on my face, .. ha ha... :)
Go to Top of Page

mojpro
Starting Member

15 Posts

Posted - 2007-04-17 : 02:32:04
Just wanted to let you know that you really helped me big time,
It was driving me crazy...
Hope you have a great night..


More questions to follow :)

Go to Top of Page
   

- Advertisement -