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 |
|
xhuso
Starting Member
2 Posts |
 Posted - 2011-08-14 : 07:03:48
|
| Hello, I would like to know, if it's possible somehow to set up SQL Management studio express automatically.I have to do the installations of SQL Server and configuration automatically, clicking just buttons (C#). The purpose is that the user could install and set everything just cliking an installation software(c#).The procces I have to follow in SQL server Management Studio Express the next one: 1)Connect to the data base2)Attach the database to the database folder3)In "attach database windows" Add a file.mdf4)Once database is added go to the "properties" of this database5)In "Properties" go to the Tab Files and change the owner of the database (go to the Browse and add user [sa])6)Confirm setingsI could show show the Screenshots of the different steps. Any help, idea, suggestion would be well recieved(I hope u can understand what I'm try to ask)Thanks |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-08-14 : 07:17:41
|
you don't use Management Studio to do this.use the sqlcmd Utility to do it
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
xhuso
Starting Member
2 Posts |
Posted - 2011-08-16 : 02:57:43
|
quote:
Originally posted by khtan
you don't use Management Studio to do this.use the sqlcmd Utility to do it
KH[spoiler]Time is always against us[/spoiler]
Thanks for the answer, How could I do it with sqlcmd?.To connect with the deafult user the command is the next on:>sqlcmd -S (local)\SQLEXPRESS -U sabut then to set those steps I want, I don't know how to do it. I'm starting with SQL and I am a bit lost.:S |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-08-16 : 03:25:27
|
read the link that i posted. Refer to the example & tutorials in there
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
Unattended set SQLserver Management Studio Express