SQL Server Performance Forum – Threads Archive
vbscript code execute with stored proc
I have some vb script codeex:
strcomputer="."
set OFSO=createobject("scripting.filesystemobject")
outputfile="D:foldersize.txt"
set ofile=ofso.createtextfile(outputfile,true)
set objwmiservice=getobject("winmgmts:\" & strcomputer & "
ootcimv2")
set colfolders=objwmiservice.execquery("select * from win32_directory")
set filesys=createobjects("scripting.filesystemobject")
for each objfolder in colfolders
ofile.writeline "name is: " & objfilefolder.name
set folder=filesys.getfolder(objfolder.name)
ofile.writeline "size is: " & folder.name next
but i want to execute this code with sql server 2000 stoted procedure code
is it possible or not
pls provide me some info.
i know one way to do this in 2000.
Create a DTS and include ur vbscript in activex script task.
then call that dts from stored procedure which will load all folder names in text file with size. Anyways you can wait for others reply till then.
Why not you run the same steps using TSQL?
That way you can call the SP using VB script from your application. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>