November 22, 2005 at 7:33 pm
background of probelem:
What I did I droped all the extended stored procedure and restored all the extended stored procedure but after that I am geting this error messge whenever I try to display properties of anything inside the database.
Error message:-
"Microsoft SQL-DMO (ODBC SQLState:4200)
Error0: Cannot load the DLL dll, or on of the DLLs it refrenc, reason:126(The specified module could not found).
(UserID=283791)
November 25, 2005 at 8:00 am
This was removed by the editor as SPAM
November 28, 2005 at 3:09 pm
Not to be sarcastic, but why did you drop all of the extended stored procedures ?
I'm guessing that by your statement "restored all the extended stored procedure" that you recovered the master database - is this correct ? If things do not work you may have to save backups of all of your databases then erinstall SQK Server and restore things to a state prior to the "xp" drop issue.
My guess is that there may be a 'hook' that when dropping extended stored procedures the associated dll may be deleted as well.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
November 29, 2005 at 3:34 am
thanks for ur help, i restored the master database & everthing looks fine to me.....
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply