Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

fn_getfiledetails - a replacement for xp_getfiledetails Expand / Collapse
Author
Message
Posted Friday, May 07, 2010 4:15 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 9:26 AM
Points: 475, Visits: 1,690
Comments posted to this topic are about the item fn_getfiledetails - a replacement for xp_getfiledetails

Best regards
karl
Post #918410
Posted Monday, June 14, 2010 6:37 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, June 14, 2013 7:11 AM
Points: 94, Visits: 1,360
This link may be helpful here:

http://www.simple-talk.com/code/OLEvsCLR/xp_getfiledetails.txt
Post #936782
Posted Thursday, June 17, 2010 7:52 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, September 15, 2012 7:21 AM
Points: 11, Visits: 59
I agree with the SSC Rookie's post. sp_OAGetProperty is very soon to get deprecated. We shall replace such codes with CLR functions.

Thanks for the article though.
Post #939322
Posted Friday, October 22, 2010 6:54 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:18 AM
Points: 33,112, Visits: 27,038
SQLKnight (6/17/2010)
I agree with the SSC Rookie's post. sp_OAGetProperty is very soon to get deprecated. We shall replace such codes with CLR functions.

Thanks for the article though.


Heh... Microsoft continues to shoot people in the face with their deprecation policy.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1009146
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse