Automatic Range Management - I give up

I have searched through this NG as well as searched BOL concerning this
process called Automatic Range Management, which is suggested as an easy way
to handle reseeding of the identity values. But I have no idea how to set up
ARM. I looked through the properties of my publications and subscriptions
and couldn't find anything for ARM. Nor do the wizards reveal any setting
for ARM.
So, howya do it?
Roger,
in the publication properties, on the articles tab, click on the elipsis
button which gives access to the article properties. There is a tab for
identities, and a checkbox at the top for automatic range management.
Assuming you haven't yet subscribed, it won't be greyed out and you can then
set the size of the range etc.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||THANK YOU!!!!!!
"Paul Ibison" wrote:

> Roger,
> in the publication properties, on the articles tab, click on the elipsis
> button which gives access to the article properties. There is a tab for
> identities, and a checkbox at the top for automatic range management.
> Assuming you haven't yet subscribed, it won't be greyed out and you can then
> set the size of the range etc.
> HTH,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>

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