Hi,

Thanks for youre response. I have already looked into that script. But im looking for a single query which returns the freespace of a disk drive.

I need a single MS...

HI,

How to use the XP_fixeddrives effectively?

my requirement is, i need to find the freespace of a diskdrive.

Im looking for a query to achieve this functionality.

Can any one help me?

Thanks in...

HI,

How to use the XP_diskdrives effectively?

my requirement is, i need to find the freespace of a diskdrive.

Im looking for a query to achieve this functionality.

Can any one help me?

Thanks in...

Hi,

Thank you very much. Its working fine.

Do you have any SQL for finding the freespace of Disk drive?

Thanks in Advance,

MRK

Hi,

This query is not working. because i have to use SYSFILES instead of sys.databasefiles it seems.

Pls give me another MS SQL query or a Stored Procedure to find the freespace...

Hi,

I can use the stored procedure. but Im trying to implement That stored procedure in DTS package. The Execution of the stored procedure is not returning a resultset... Im not...