Hi very nice article.

Only xp_cmdshell is not always enabled, because of possible security reasons. From SQL Server 2008R2 the Dynamic Management view sys.dm_os_volume_stats can be used. So I would prefer...

Jeff,

Indeed we are in the SSIS forum section 🙂 your last script does not work in SSIS expressions. But I understaind my problem and everything is working fine now. Thanks...

Hello Jeff,

Thanks for the reply, the variable also contains a datetime data type. Extracted from a SQL table.

I do the conversion because the written datetime to the table also contains...

Kory,

Thanks for you reply.

I have been showing the application programmer my findings on the database Awaiting Command Sessions.

First he pointed to the CITRIX application environment for holding the sessions.

But the...