Automating Capacity planning of the disks

I will like to write a short code to automate the
procedure of checking the total space available on the
disks on the server toavoid running out of space and to
avoid manual intervention. Any help please.See if this helps: http://www.sqldbatips.com/showcode.asp?ID=4
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Aboki" <hcokoli@.yahoo.com> wrote in message
news:c24301c47a34$4a90d3f0$a301280a@.phx.gbl...
I will like to write a short code to automate the
procedure of checking the total space available on the
disks on the server toavoid running out of space and to
avoid manual intervention. Any help please.

automate report export

I have a report that has a parameter for each agency that I deal with (500
total agencies). I was just told that I have to run this report for each of
the 500 agencies and export the results to a PDF file or files. After getting
back up on my chair, I started to research how I may automate this and have
come up empty handed.
Does anyone know of a script that I may use to pass in a parameter from an
array or sql cursor to my report and export the results?
Thank you in advance!!!Open the report in the Report manager.
Go To the "Subscriptions" Option
Select "New Data_Driven Subscription"
This is a good place to start with.
--
THANKS & PLEASE RATE THE POSTING.
--RAVI--
"Carl Henthorn" wrote:
> I have a report that has a parameter for each agency that I deal with (500
> total agencies). I was just told that I have to run this report for each of
> the 500 agencies and export the results to a PDF file or files. After getting
> back up on my chair, I started to research how I may automate this and have
> come up empty handed.
> Does anyone know of a script that I may use to pass in a parameter from an
> array or sql cursor to my report and export the results?
> Thank you in advance!!!|||thanks! that doesnt work for me since I am not storing my access credentials
locally. I am looking into passing in parameters via URL. That looks
promissing, if I can just figure out the whole Rendering thing.
thanks!
"Ravi" wrote:
> Open the report in the Report manager.
> Go To the "Subscriptions" Option
> Select "New Data_Driven Subscription"
> This is a good place to start with.
> --
> THANKS & PLEASE RATE THE POSTING.
> --RAVI--
>
> "Carl Henthorn" wrote:
> > I have a report that has a parameter for each agency that I deal with (500
> > total agencies). I was just told that I have to run this report for each of
> > the 500 agencies and export the results to a PDF file or files. After getting
> > back up on my chair, I started to research how I may automate this and have
> > come up empty handed.
> >
> > Does anyone know of a script that I may use to pass in a parameter from an
> > array or sql cursor to my report and export the results?
> >
> > Thank you in advance!!!|||Carl, if you still need this, we are doing it.
let me know via here and I will send you what we have.
"Carl Henthorn" wrote:
> thanks! that doesnt work for me since I am not storing my access credentials
> locally. I am looking into passing in parameters via URL. That looks
> promissing, if I can just figure out the whole Rendering thing.
> thanks!
> "Ravi" wrote:
> > Open the report in the Report manager.
> > Go To the "Subscriptions" Option
> > Select "New Data_Driven Subscription"
> >
> > This is a good place to start with.
> > --
> > THANKS & PLEASE RATE THE POSTING.
> > --RAVI--
> >
> >
> > "Carl Henthorn" wrote:
> >
> > > I have a report that has a parameter for each agency that I deal with (500
> > > total agencies). I was just told that I have to run this report for each of
> > > the 500 agencies and export the results to a PDF file or files. After getting
> > > back up on my chair, I started to research how I may automate this and have
> > > come up empty handed.
> > >
> > > Does anyone know of a script that I may use to pass in a parameter from an
> > > array or sql cursor to my report and export the results?
> > >
> > > Thank you in advance!!!|||Hi Jeff,
We have created a process to automatically render reports to PDF on a
monthly basis as well. Our issue is timing. Have you had any issues
concerning the amount of time it takes to render a large number of reports?
We took one report with an average of 10 pages and ran it for 600 clients.
The process took 1 hour. We have a total of 30 reports and 1600 clients.
This will take weeks to create all of them.
Any help is greatly appreciated.
Thank you
Scott Torres
"Jeff Ericson" wrote:
> Carl, if you still need this, we are doing it.
> let me know via here and I will send you what we have.
> "Carl Henthorn" wrote:
> > thanks! that doesnt work for me since I am not storing my access credentials
> > locally. I am looking into passing in parameters via URL. That looks
> > promissing, if I can just figure out the whole Rendering thing.
> > thanks!
> >
> > "Ravi" wrote:
> >
> > > Open the report in the Report manager.
> > > Go To the "Subscriptions" Option
> > > Select "New Data_Driven Subscription"
> > >
> > > This is a good place to start with.
> > > --
> > > THANKS & PLEASE RATE THE POSTING.
> > > --RAVI--
> > >
> > >
> > > "Carl Henthorn" wrote:
> > >
> > > > I have a report that has a parameter for each agency that I deal with (500
> > > > total agencies). I was just told that I have to run this report for each of
> > > > the 500 agencies and export the results to a PDF file or files. After getting
> > > > back up on my chair, I started to research how I may automate this and have
> > > > come up empty handed.
> > > >
> > > > Does anyone know of a script that I may use to pass in a parameter from an
> > > > array or sql cursor to my report and export the results?
> > > >
> > > > Thank you in advance!!!

Auto-increment fields when moving a base from Access to SQL server

Hello all,

I'm a total newbie with SQL Server 2000 and I have a little problem when
moving a database form Access 2000 to SQL Server 2000.
In the Access database, each table has an auto-increment field.
After importing the tables in SQL Server, all the auto-increment fields
are turned into "int" type fields.
Does anybody have an explanation for that mystery?

Thanks in advance,
YanYou might want to change the field type from int to identity. The identity
field type in SQL Server is analogous to the Autonumber field type in
Access.

good luck

CJ

"Yan Roosens" <yan.roosens@.skynet.be> wrote in message
news:3F7C4258.6C6B428E@.skynet.be...
> Hello all,
> I'm a total newbie with SQL Server 2000 and I have a little problem when
> moving a database form Access 2000 to SQL Server 2000.
> In the Access database, each table has an auto-increment field.
> After importing the tables in SQL Server, all the auto-increment fields
> are turned into "int" type fields.
> Does anybody have an explanation for that mystery?
> Thanks in advance,
> Yan|||Hi CJ,

> You might want to change the field type from int to identity. The identity
> field type in SQL Server is analogous to the Autonumber field type in
> Access.

Thank you, the error message related to that problem is no longer displayed, I
will now care about the next one :-(

Yan|||On Thu, 02 Oct 2003 17:20:57 +0200, Yan Roosens
<yan.roosens@.skynet.be> wrote:

>Hello all,
>I'm a total newbie with SQL Server 2000 and I have a little problem when
>moving a database form Access 2000 to SQL Server 2000.
>In the Access database, each table has an auto-increment field.
>After importing the tables in SQL Server, all the auto-increment fields
>are turned into "int" type fields.
>Does anybody have an explanation for that mystery?
>Thanks in advance,
>Yan
Because that isn't a data type. Look up identity for an explanation of
how sql server can provide that sort of functionality.