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 |
|
dmaxj
Posting Yak Master
174 Posts |
 Posted - 2010-08-05 : 15:02:30
|
| I am looking over the code for a MS system stored proc called sp_mergemetadataretentioncleanup.There is a call to another system proc called - sp_MSmerge_subbased_downloadonly_metadatacleanup.I am looking for the latter proc in the Master db, but cannot locate. I am sure that it must exist. Does anyone know where the proc is located and/or what the proc does?Regards |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dmaxj
Posting Yak Master
174 Posts |
Posted - 2010-08-05 : 15:22:25
|
| I tried to connect using DAC, but DAC is not supported. I have checked the resource db looking for an object with the proc name - still no luck. MSDB and model do not have the proc either... Regards |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-08-05 : 16:02:13
|
| it is in the resource db |
|
|
|
dmaxj
Posting Yak Master
174 Posts |
Posted - 2010-08-05 : 16:48:47
|
| Ok - I have found that the resource database files (mdf/ldf) are located in the Binn folder of the SQL instance. I have found a doc explaining how to copy and attach the resource db to SSMS. This does not mean that I have found my proc yet, but I figured that I would share my steps of a potential solution - enjoy!Thanks to Alexzander and Prashant - http://www.myitforum.com/articles/1/view.asp?id=9138 |
|
|
|
dmaxj
Posting Yak Master
174 Posts |
Posted - 2010-08-05 : 17:04:37
|
| Alright - I have found the missing proc in the System Stored Procedures node of the resource db - hopefully above info will help.Regards |
|
|
|
|
|
|
missing proc