AUTOCLOSE

It has been suggested to me by one of my vendors that I
need to have AUTOCLOSE turned on for my SQL Server 2000
backups to be reliable. I have never heard this before.
Does anyone feel AUTOCLOSE needs to be set to True for
Enterprise Manager/Agent/Jobs backups to be reliable?
Please explain.
ThanksThat is complete rubbish. :-)
Your vendor apparently think that you do backup through nicking the database
files at the file system level...
Even if you did, autoclose is not, AFAIK, documented to work for this. I nev
er recommend to do backup of the
database files, but if someone would do that, you need to shutdown SQL Serve
r.
(And convincing me of the opposite requires a BOL topic or a KB article ;-).
Such may very well exists, and I
may just have missed it, of course.)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Johnny Kennedy" <jkennedy@.pcmh.com> wrote in message news:12a7a01c411b6$f56bf6b0$a401280a@.
phx.gbl...
> It has been suggested to me by one of my vendors that I
> need to have AUTOCLOSE turned on for my SQL Server 2000
> backups to be reliable. I have never heard this before.
> Does anyone feel AUTOCLOSE needs to be set to True for
> Enterprise Manager/Agent/Jobs backups to be reliable?
> Please explain.
> Thanks

Auto generate multiple pdfs

Hi,

I have a sales report that includes sales information for different vendors. I have vendor as a dropdown parameter, which includes the option "All vendors".

What I want to do now, is to generate one pdf for each vendor, keeping the date parameters for each. It's of course too time consuming to produce one pdf at a time by going through all the vendors (there are ~150 vendors), and splitting the pdf generated by choosing "All vendors" is difficult because the length of the report for each vendor differ.

Can I use SSIS to solve this? Any help is greatly appreciated.

Btw, I'm using SQL Server 2005

Regards,

Kremfjes

As the adage goes "when life gets tough, the programmer writes a program". I'd write a small app to call down to the Report Server Render API to meet this requirement. Alternatively, you can set up a data-driven subscription to generate the reports and send them to a file share or e-mail.