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 |
|
Adam West
Constraint Violating Yak Guru
261 Posts |
 Posted - 2009-07-30 : 09:30:44
|
| What do I do to create this small database that will hold the developers mods or tables? So that during an upgrade to other databases, this custom database remains untouched? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Adam West
Constraint Violating Yak Guru
261 Posts |
Posted - 2009-08-03 : 09:11:00
|
| This is true but I am not the one doing the refresh.I would simply like to create a small database for mods made by developers be it tables, stored procs,etc.How do you go about doing this? |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Adam West
Constraint Violating Yak Guru
261 Posts |
Posted - 2009-08-03 : 11:00:11
|
| Yes a separate database, How does one create this? |
|
|
|
Adam West
Constraint Violating Yak Guru
261 Posts |
Posted - 2009-08-03 : 13:20:49
|
| I located these instructions on Microsoft web site but I am stuck at the first one. How to "Expand that instance" ? To create a database In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance.Right-click Databases, and then click New Database.In New Database, enter a database name.To create the database by accepting all default values, click OK; otherwise, continue with the following optional steps.To change the owner name, click (…) to select another owner. |
|
|
|
Adam West
Constraint Violating Yak Guru
261 Posts |
Posted - 2009-08-03 : 15:10:14
|
| OK I created the database. I copies an existing Stored Procedure and pasted it to a new query, and executed this successfully, however I cannot locate this stored procedure in the new database. In the area of Stored Procedures, under Programmability, there are only SYSTEM Stored procedures. Any idea why this is so or where it got placed? |
|
|
|
Adam West
Constraint Violating Yak Guru
261 Posts |
Posted - 2009-08-03 : 15:21:52
|
| OK It appears now. I needed to save /close etc.My next step is to use this mods database in a report. |
|
|
|
|
|
|
|
|
Create small custom database