[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3645
  • Last Modified:

Could not find stored procedure 'master.dbo.xp_getfiledetails'.

Is this gone in v2008 ?
0
dbaSQL
Asked:
dbaSQL
  • 6
1 Solution
 
chapmandewCommented:
yes, its gone, but you can replace it:

http://forums.databasejournal.com/showthread.php?t=44193
0
 
dbaSQLAuthor Commented:
excellent, chap.  thank you.   i'm half way there....

Msg 15281, Level 16, State 1, Procedure sp_OACreate, Line 1
SQL Server blocked access to procedure 'sys.sp_OACreate' of component 'Ole Automation Procedures' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Ole Automation Procedures' by using sp_configure. For more information about enabling 'Ole Automation Procedures', see "Surface Area Configuration" in SQL Server Books Online.
0
 
dbaSQLAuthor Commented:
All good now.  Thank you, sir.
0
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
dbaSQLAuthor Commented:
almost... i thought i was there, but

Msg 17750, Sev 16, State 1, Line 1 : Could not load the DLL xpsmtp80.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [SQLSTATE 42000]
0
 
dbaSQLAuthor Commented:
xpsmtp80.dll is 32bit, this is a 64x box.  not sure exactly how to get around this yet
0
 
dbaSQLAuthor Commented:
chap, i'd be happy to open another inquiry. i  think i see the reason for this, but i'm not yet sure how to best work around it.  i have another procedure which is run from varied jobs, via sql agent, it sends the  the procedure results embedded into the body of emails.  i believe this is the call on xpsmtp80.dll.  do you have a moment to review?
0
 
dbaSQLAuthor Commented:
i got it.  thank you anyway, chap
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now