Tag Archives: sp_OACreate and sp_OAGetProperty

SQL Server Operations: Monitoring Disk Space with WMI and OLE Automation Objects

Abstract This article talks about various SQL methods to fetch the disk usage details and use of T-SQL in conjunction with invoking OLE automation procedures and WMI  class libraries using SQL Windows Shell interface. The step by step  details about … Continue reading

Posted in PowerShell, SQL, T-SQL | Tagged , , , , , | 1 Comment

Determine size of the file using T-SQL/Powershell/Ole Objects

There are many ways to find the filesize. This post is all about identifing the filesize using T-SQL,Instantiating OLE Objects and PowerShell. The requirement is to retrieve the size of the specified file. The return value is going to a … Continue reading

Posted in PowerShell, SQL, T-SQL | Tagged , , , , , | Leave a comment