Forum Replies Created

Viewing 15 posts - 1 through 15 (of 21 total)

  • RE: Global Variable not getting updated automatically?

    Hi,

    I have looked into the URL you specified.

    But it looks different.. May be its different version.

    We are using SQL server 2000.

    If possible pls provide A query to find the freespace...

  • RE: Global Variable not getting updated automatically?

    Hi,

    Please clarify my doubt.

    Here i explained my steps.

    If you open Execute SQL Task, There is a button called "Parameters".

    If you click on that it will open a pop-up window. In...

  • RE: Global Variable not getting updated automatically?

    Hi,

    Here im trying to find the freespace of the diskdrive.

    Im passing the Drive letter "k" as input for my procedure like,

    EXECUTE @rc = Size_DiskDrive 'K'

    and returning the freepspace...

  • RE: Finding Database Free space using DTS

    Hi,

    Im using this procedure

    ALTER procedure Size_DiskDrive

    @driveletter char(1)

    AS

    DECLARE @flag int

    DECLARE @dbsize Decimal(15,2),

    @TBexist int

    BEGIN

    select @TBexist = count(*) from sysobjects where type = 'U' and name = 'Test1'

    if (@TBexist = 0)

    BEGIN

    CREATE TABLE...

  • RE: Global Variable not getting updated automatically?

    HI,

    Im using this code,

    Create procedure Size_DiskDrive

    @driveletter char(1)

    AS

    DECLARE @flag int

    DECLARE @dbsize Decimal(15,2),

    @TBexist int

    BEGIN

    select @TBexist = count(*) from sysobjects where type = 'U' and name = 'Test1'

    if (@TBexist = 0)

    BEGIN

    CREATE TABLE...

  • RE: Finding Database Free space using DTS

    Hi,

    When im Testing with "K" drive the value is coming and the global variable is getting updated and displayed the value 9722

    Next when i test with "D" drive the global...

  • RE: To find freespace of Database using a query

    Hi,

    I have implemented that Procedure using DTS Package.

    I returned the freespace from the Procedure.

    In DTS Package i got the returned value as Global Parameter.

    But im facing a problem here that...

  • RE: Finding Database Free space using DTS

    Hi,

    Its working fine in SQL Analyser.

    Showing the K Drive freespace properly.

    K Drive is a proper drive only not another server.

    But When i implement in DTS Package, the output globalvariable value...

  • RE: Finding Database Free space using DTS

    Hi,

    Yes, I recreated the procedure with a 'K' in the WHERE clause instead of a 'D'.

    Whatever it may be it should return the correct value but only the previous value...

  • RE: Finding Database Free space using DTS

    HI,

    Im facing a trouble here.

    For "D" drive i executed Procedure.

    The out put parameter is Diskspace.

    The Global variable is also Diskspace and the value 755 got stored in that.

    And the output...

  • RE: To find freespace of Database using a query

    Hi,

    Thank you very much.

    I have my procedure DiskSpace_Size in DTS Package.

    The problem is with my output parameter.

    I have resolved it.

    Thanks for all your support and information.

    MRK.

  • RE: Finding Database Free space using DTS

    Hi,

    Thank you very much.

    The problem is with my output parameter.

    i have resolved it.

    Thanks for all your support.

    MRK.

  • RE: To find freespace of Database using a query

    Hi,

    When i Try to execute

    DECLARE @drive TINYINT,

    @sql VARCHAR(100)

    SET @drive = 97

    -- Setup Staging Area

    DECLARE @Drives TABLE

    (

    Drive CHAR(1),

    Info VARCHAR(80)

    )

    WHILE @drive <= 122

    BEGIN

    SET...

  • RE: Finding Database Free space using DTS

    HI,

    Im trying to execute the below procedure. But we are facing some techincal problem in this while implementing it into the DTS Package.

    CREATE procedure DiskSpace_Size

    AS

    SET NOCOUNT ON

    DECLARE @disksize Decimal(15,2)

    SET NOCOUNT...

  • RE: To find freespace of Database using a query

    HI,

    I know that the above procedure is correct. But we are facing some techincal problem in this while implementing it into the DTS Package.

    CREATE procedure DiskSpace_Size

    AS

    SET NOCOUNT ON

    DECLARE @disksize Decimal(15,2)

    SET...

Viewing 15 posts - 1 through 15 (of 21 total)