model db as a staging db ?
This is a discussion on model db as a staging db ? within the Database Support forums, part of the Web Development category; Hi, Because tempdb will be re-created after each server restart, I'm thinking of using model db as a ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
04-03-2009, 02:15 AM
| |||
| |||
 model db as a staging db ? Hi, Because tempdb will be re-created after each server restart, I'm thinking of using model db as a temporary db to house 2 persistent tables. I'll also need to grant data reader, data writer and ddladmin to an sql ID which will manage these 2 tables. Will there be any risk using the model db for staging purpose ? As far as I know, creation of db goes through me. So, I'll have to take note to drop the 2 tables when I create a new database. Please advise.     |
|
#2
04-03-2009, 02:16 AM
| |||
| |||
| Re: model db as a staging db ? Hi, I certainly don't see a problem with that though you may be just as well using the master database. Although is there any reason not to just create an extra user database for the tables?
__________________ A.Rajesh Khanna |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Seven Layers of the OSI Model | vijayanand | Networking & Internet Connectivity | 2 | 09-20-2007 07:18 AM |
| what is the threading model used for ASP.Net? | mobilegeek | ASP and ASP.NET Programming | 1 | 07-21-2007 12:48 AM |
| Waterfall model,Spiral model | prasath | Software Testing | 2 | 07-17-2007 02:34 AM |
| OSI model | vadivelanvaidyanathan | Server Management | 0 | 07-15-2007 05:18 PM |
| About W-model | stephen | Software Testing | 1 | 05-16-2007 05:00 AM |
All times are GMT -7. The time now is 05:23 AM.