Viewing 15 posts - 1 through 15 (of 21 total)
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...
December 7, 2007 at 9:26 am
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...
December 7, 2007 at 8:56 am
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...
December 7, 2007 at 12:18 am
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...
December 6, 2007 at 7:57 am
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...
December 6, 2007 at 7:27 am
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...
December 5, 2007 at 8:07 am
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...
December 5, 2007 at 7:54 am
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...
December 5, 2007 at 7:15 am
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...
December 5, 2007 at 6:31 am
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...
December 5, 2007 at 5:24 am
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.
December 5, 2007 at 3:37 am
Hi,
Thank you very much.
The problem is with my output parameter.
i have resolved it.
Thanks for all your support.
MRK.
December 5, 2007 at 3:33 am
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...
December 4, 2007 at 10:27 pm
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...
December 4, 2007 at 10:18 pm
Viewing 15 posts - 1 through 15 (of 21 total)