Duplicate post.

All replies to

http://www.sqlservercentral.com/Forums/Topic786154-146-1.aspx

Please dont post multiple time, you have posted 5 times.

All replies to this post please

havent we got enough of those already:-P, although any new MVP's are always welcome.

if you do sp_helptext and mention the extended stored procedure name you will get the DLL name as long as it isnt an internal extended stored procedure.

sp_helptext ExtendedStoredProcedure

llokshin (9/10/2009)

---

Hi, we tried to restore a database and it failed with this error

This operation failed with errors.

Restoring RP02P (database) from:

H:\MSSQL\backup\rp01p\rp01p_db_200909090500.sqb

SQL Server error

SQL error 9003: SQL error 9003: The...

You will not be able to see the code for these, unless someone has kindly disassembled the DLL that they are in, and placed them on the net.

If anyone has...

John Marcuz (9/10/2009)

---

When I tried to execute 'sp_OAMethod' procedure in SQL 2005, i got the error as '[SQL-DMO] This cache contains no result sets, or the current result set contains...

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/c0a2e17e-a944-4190-b2cd-3a9aaefd4103

http://www.eggheadcafe.com/forumarchives/SQLServersetup/Jan2006/post25072107.asp

that is all i could find :unsure:, it does imply that you cannot, but I know it is pretty weak.

You dont mention which version(s) of sql server that you work with, but in your position I would be tempted to go for the microsoft certification that focuses on BI...

jabba (9/10/2009)

---

A support analyst need to be able to send email via the sp_send_dbmail command. When he attempts to run a script using his existing permissions he receives this...

ramyours2003 (9/10/2009)

---

can any one send me the script likefinding dbname ,db owner,date created,size, space avaialble ,dboptions, no.of users, last backup, last diff backup, tran backup, maint.plans, space allocated by...

If you have recreated everything exactly the same. I would check connectivity to the other server.

can you ping it from the server you are having trouble with. sometimes network glitches...

Filipe Miranda (9/10/2009)

---

Hi,

As part of our MP in one of our instances we have a transaction log backup that runs every hour on the hour. That job runs fine almost...

Matt Cherwin (9/10/2009)

---

One of the instances I maintain is a SQL 2005 (Standard, 64-bit, SP2) installation on a 2-node Windows 2003 R2 (Enterprise) cluster, using SAN disk for storage. We're...

hmmm, interesting, looks like the checkcatalog part of the dbcc checkdb has reported catalogue dependency errors, against system objects.

Really need someone else to confirm...

but I think using sp_refreshsqlmodule might help,...