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 |
|
harshal_in
Aged Yak Warrior
633 Posts |
 Posted - 2002-12-21 : 02:08:33
|
| hi,I had a stored procedure in the master database ,we have shifted our database server to a new server,I have the backup of the master database,can I get that stored procedure only from the back up ?I mean can I restore the backup of the master database from the previous server to some new xyz database and copy the stored proc and then delete the xyz database? will this affect the current server configuration?regards,harshal.Expect the UnExpected |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-12-21 : 11:26:58
|
| Yes you can restore master under a different name and retrieve your sp and then delete the database. If will have no effect on the server, it will be treated as any other user database.HTHJasper Smith |
 |
|
|
p2bl
Yak Posting Veteran
54 Posts |
Posted - 2002-12-22 : 23:35:13
|
| Is there any reason to create user SP in master?pls tell me========================look! |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2002-12-23 : 01:12:21
|
quote:
Is there any reason to create user SP in master?pls tell me========================look!
Actually that sp is used to create a database through a vb application which is a setup routine . to create a database through the sp which will be embedded in a setup programe ,will be using the master database so I had just created a sp and we had to change the server after that so the sp remained in the previous server which is now down.I just have the data files!Expect the UnExpected |
|
|
|
|
|
|
restore master