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.
| Author |
Topic |
|
jennypretty
Yak Posting Veteran
96 Posts |
 Posted - 2005-04-22 : 11:11:51
|
| Hello friends,I created a db in EM, how do I view the db dictionary?How do I see this? CREATE DATABASE jenny ON .....Is there any way to see this?thanks,Jenny.The stupid question is the question you don't ask.www.single123.com |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-04-22 : 11:14:51
|
you want to script the db?right click on dbname in EM -> all tasks -> Generate sql scriptGo with the flow & have fun! Else fight the flow  |
 |
|
|
jennypretty
Yak Posting Veteran
96 Posts |
Posted - 2005-04-22 : 11:30:32
|
| I have about 20 mb db, this is my db script, do you think it is ok or not? 'cause I don't have much experiences about size, maxsize, filegrowth?CREATE DATABASE [jenny]ON (NAME = N'jenny_data', FILENAME = N'C:\Program Files\Microsoft...\data\jenny_log.ldf', SIZE = 6, FILEGROWTH = 10%)LOG ON (NAME = N'jenny_log', FILENAME = N'C:\Programs Files\microsoft..\data\jenny_log.ldf', SIZE = 3, FILEGROWTH = 10%)This is what saw on the script of the db. Can you please tell me is it ok for a 20 mb db. My questions:why I don't see the word 'PRIMARY' for the filegroup?why I have the letter N before data file and log file?Thanks,Jenny.The stupid question is the question you don't ask.www.single123.com |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-04-22 : 12:40:18
|
| well i don't see anything wrong with it.1. Primary is deafult so it's not there.2. N stands for unicodeGo with the flow & have fun! Else fight the flow |
|
|
|
|
|
|
|
|
db creation using EM help please