News
Quick T/SQL Tip: Parsing Drive and File Information in SQL Server
SQL ServerQuick T/SQL Tip: Parsing Drive and File Information in SQL ServerQuick T/SQL Tip: Parsing Drive and File Information in SQL Server
Parsing full physical file names for information is one of those tasks a Database Administrator finds they do on a semi-frequent basis; from looking up SQL Agent Job output paths or reviewing database file metadata. Recently,I found myselfupdating a SQL Server Reporting Services reportwhich provides SQL Agent Job failure history to the DBA Team. I was adding functionality that would include the output file for any job hitting the report. This allows the DBA to troubleshoot the failure details without having to navigate to the job on the instance and pull
byTim Ford
.jpg?width=100&auto=webp&quality=80&disable=upscale "Picture of Richard Hay")
_0_0.png?width=300&auto=webp&quality=80&disable=upscale "Unboxing & Hands On : Nuvision TM800W610L 8-Inch Windows 10 Tablet")
.png?width=100&auto=webp&quality=80&disable=upscale "Picture of John Savill")
Editor's Choice
Featured Technical Explainers
Recent What Is
.jpg?width=700&auto=webp&quality=80&disable=upscale)
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.