Re: Help with DBI to get HDD size of C drive of remote PC running MS-SQL Express 2005

2009-10-13 Thread Jenda Krynicky
From: "David Evans" > This is my Perl: > > *Begin Perl Code* > use DBIx::SQLEngine; > > $sqllist1 = "IF EXISTS (\nSELECT 1 FROM > INFORMATION_SCHEMA.ROUTINES\nWHERE ROUTINE_NAME = 'GetDriveSize'\nAND > ROUTINE_SCHEMA = 'dbo'\nAND ROUTINE_TYPE = 'FUNCTION'\n)\nBEGIN\nDROP > FUNC

Help with DBI to get HDD size of C drive of remote PC running MS-SQL Express 2005

2009-10-13 Thread David Evans
Hi Guys I hope someone can help me. I know the SQL works fine, but I can't work out how to get it to work with DBIx::SQLEngine. Cheers Dave This is the SQL I want to execute (and works from SQL Management Studio 2005): *Begin SQL Code* IF EXISTS ( SELECT 1 FROM INF