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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-30 : 07:16:23
|
| Hesham writes "im student at the graduate year , and my project is client server database , so i ask :If can i write all sql statements that involved creating database, all procedures , views , and etc .. on asingle file as atemplate as i can seprate it to my supervisor ..please reply me .. and told me how .." |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2004-06-30 : 07:33:17
|
| Yes, you can do nearly everything that needs to be done with databases in Query Analyzer by running scripts. And yes, you can also create all the objects in a database from a single file, however, you need to be a little careful to script objects in the right order, i.e. certain objects depend upon others, so those will need to be created before the dependent objects or else your script will fail. If you like a sample of how this done, right click on the database in Enterprise Manager -> All Tasks -> Generate SQL Script.OS |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-30 : 08:39:05
|
| You can also download sample databases from Microsoft and www.asp.net for examples.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
|
|
can create DB completely using query analyzer