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 «««123

Delete files older than n-days via T-SQL Expand / Collapse
Author
Message
Posted Thursday, May 31, 2012 7:24 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 7:48 AM
Points: 28, Visits: 193
somehow I think its on my end in my cursor. Not sure why. If I run the proc manually on a lot of files it is very quick. I think I could avoid the cursor by doing it set based to execute but i am unsure if this will make it faster...

Michael B
Data Architect
MCT, MCITP(SQL DBA 2005/2008),MCTS, MCP,MCDBA
Post #1308974
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse