How to track SQL server and file growth

HI, Forgive me as I try to work through my thoughts here. I am looking for
some help in creating a script that will gather drive data from 3 SQL
servers and record that to a SQL database. The data to be recorded was
originally just (DriveLetter, Size, SpaceUsed, SpaceAvailable). Now it
includes (FileNames, and Sizes) of MDF and LDF files in specific folders. I
started this yesterday and have a VBS script that pulls the original data
and saves it to a CSV file, then I created a VBA macro in an XLS file which
pulls that data in to a spreadsheet and assigns each servers data to a
different tab. But this requires a VBS file on each server and each VBS
file creates their own CSV file (on a central server where the XLS file is
located).. Anyway I would like to change what I have already done so that
there a fewer pieces, more data, and it is saved to an MDF. Can someone
help with this?I don't know how you built VBS file since you have not shown us the source
so , take a look at
http://www.sql-server-performance.c...with_dts_05.asp
"WANNABE" <breichenbach AT istate DOT com> wrote in message
news:e2d66s$2GHA.1292@.TK2MSFTNGP03.phx.gbl...
> HI, Forgive me as I try to work through my thoughts here. I am looking
> for some help in creating a script that will gather drive data from 3 SQL
> servers and record that to a SQL database. The data to be recorded was
> originally just (DriveLetter, Size, SpaceUsed, SpaceAvailable). Now it
> includes (FileNames, and Sizes) of MDF and LDF files in specific folders.
> I started this yesterday and have a VBS script that pulls the original
> data and saves it to a CSV file, then I created a VBA macro in an XLS file
> which pulls that data in to a spreadsheet and assigns each servers data to
> a different tab. But this requires a VBS file on each server and each VBS
> file creates their own CSV file (on a central server where the XLS file is
> located).. Anyway I would like to change what I have already done so that
> there a fewer pieces, more data, and it is saved to an MDF. Can someone
> help with this?
>|||Thanks!!!, that looks like it just what I need. May need a little tweaking,
but so far so good..
Thanks again
======================================
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23piXMw$2GHA.1068@.TK2MSFTNGP05.phx.gbl...
>I don't know how you built VBS file since you have not shown us the source
>so , take a look at
> http://www.sql-server-performance.c...with_dts_05.asp
>
> "WANNABE" <breichenbach AT istate DOT com> wrote in message
> news:e2d66s$2GHA.1292@.TK2MSFTNGP03.phx.gbl...
>

How to track SQL server and file growth

HI, Forgive me as I try to work through my thoughts here. I am looking for
some help in creating a script that will gather drive data from 3 SQL
servers and record that to a SQL database. The data to be recorded was
originally just (DriveLetter, Size, SpaceUsed, SpaceAvailable). Now it
includes (FileNames, and Sizes) of MDF and LDF files in specific folders. I
started this yesterday and have a VBS script that pulls the original data
and saves it to a CSV file, then I created a VBA macro in an XLS file which
pulls that data in to a spreadsheet and assigns each servers data to a
different tab. But this requires a VBS file on each server and each VBS
file creates their own CSV file (on a central server where the XLS file is
located).. Anyway I would like to change what I have already done so that
there a fewer pieces, more data, and it is saved to an MDF. Can someone
help with this?
I don't know how you built VBS file since you have not shown us the source
so , take a look at
http://www.sql-server-performance.co...ith_dts_05.asp
"WANNABE" <breichenbach AT istate DOT com> wrote in message
news:e2d66s$2GHA.1292@.TK2MSFTNGP03.phx.gbl...
> HI, Forgive me as I try to work through my thoughts here. I am looking
> for some help in creating a script that will gather drive data from 3 SQL
> servers and record that to a SQL database. The data to be recorded was
> originally just (DriveLetter, Size, SpaceUsed, SpaceAvailable). Now it
> includes (FileNames, and Sizes) of MDF and LDF files in specific folders.
> I started this yesterday and have a VBS script that pulls the original
> data and saves it to a CSV file, then I created a VBA macro in an XLS file
> which pulls that data in to a spreadsheet and assigns each servers data to
> a different tab. But this requires a VBS file on each server and each VBS
> file creates their own CSV file (on a central server where the XLS file is
> located).. Anyway I would like to change what I have already done so that
> there a fewer pieces, more data, and it is saved to an MDF. Can someone
> help with this?
>
|||Thanks!!!, that looks like it just what I need. May need a little tweaking,
but so far so good..
Thanks again
======================================
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23piXMw$2GHA.1068@.TK2MSFTNGP05.phx.gbl...
>I don't know how you built VBS file since you have not shown us the source
>so , take a look at
> http://www.sql-server-performance.co...ith_dts_05.asp
>
> "WANNABE" <breichenbach AT istate DOT com> wrote in message
> news:e2d66s$2GHA.1292@.TK2MSFTNGP03.phx.gbl...
>
sql

How to track SQL server and file growth

HI, Forgive me as I try to work through my thoughts here. I am looking for
some help in creating a script that will gather drive data from 3 SQL
servers and record that to a SQL database. The data to be recorded was
originally just (DriveLetter, Size, SpaceUsed, SpaceAvailable). Now it
includes (FileNames, and Sizes) of MDF and LDF files in specific folders. I
started this yesterday and have a VBS script that pulls the original data
and saves it to a CSV file, then I created a VBA macro in an XLS file which
pulls that data in to a spreadsheet and assigns each servers data to a
different tab. But this requires a VBS file on each server and each VBS
file creates their own CSV file (on a central server where the XLS file is
located).. Anyway I would like to change what I have already done so that
there a fewer pieces, more data, and it is saved to an MDF. Can someone
help with this?I don't know how you built VBS file since you have not shown us the source
so , take a look at
http://www.sql-server-performance.com/nn_monitor_with_dts_05.asp
"WANNABE" <breichenbach AT istate DOT com> wrote in message
news:e2d66s$2GHA.1292@.TK2MSFTNGP03.phx.gbl...
> HI, Forgive me as I try to work through my thoughts here. I am looking
> for some help in creating a script that will gather drive data from 3 SQL
> servers and record that to a SQL database. The data to be recorded was
> originally just (DriveLetter, Size, SpaceUsed, SpaceAvailable). Now it
> includes (FileNames, and Sizes) of MDF and LDF files in specific folders.
> I started this yesterday and have a VBS script that pulls the original
> data and saves it to a CSV file, then I created a VBA macro in an XLS file
> which pulls that data in to a spreadsheet and assigns each servers data to
> a different tab. But this requires a VBS file on each server and each VBS
> file creates their own CSV file (on a central server where the XLS file is
> located).. Anyway I would like to change what I have already done so that
> there a fewer pieces, more data, and it is saved to an MDF. Can someone
> help with this?
>|||Thanks!!!, that looks like it just what I need. May need a little tweaking,
but so far so good..
Thanks again
======================================"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23piXMw$2GHA.1068@.TK2MSFTNGP05.phx.gbl...
>I don't know how you built VBS file since you have not shown us the source
>so , take a look at
> http://www.sql-server-performance.com/nn_monitor_with_dts_05.asp
>
> "WANNABE" <breichenbach AT istate DOT com> wrote in message
> news:e2d66s$2GHA.1292@.TK2MSFTNGP03.phx.gbl...
>> HI, Forgive me as I try to work through my thoughts here. I am looking
>> for some help in creating a script that will gather drive data from 3 SQL
>> servers and record that to a SQL database. The data to be recorded was
>> originally just (DriveLetter, Size, SpaceUsed, SpaceAvailable). Now it
>> includes (FileNames, and Sizes) of MDF and LDF files in specific folders.
>> I started this yesterday and have a VBS script that pulls the original
>> data and saves it to a CSV file, then I created a VBA macro in an XLS
>> file which pulls that data in to a spreadsheet and assigns each servers
>> data to a different tab. But this requires a VBS file on each server and
>> each VBS file creates their own CSV file (on a central server where the
>> XLS file is located).. Anyway I would like to change what I have already
>> done so that there a fewer pieces, more data, and it is saved to an MDF.
>> Can someone help with this?
>

How to store image (in the folder) that linked by staffno?

Hi..
I have a folder which store staff picture in my C drive. Is it possible for me to link that staff picture into my report? It linked by staffno..something like this..
"C:\picture\" + {tblStaff.StaffNo} + ".jpg"
but..where do i put this code? any idea? thanx in advance..;)Try looking in Crystal's Help under Images (dynamic)...