MSDE subscription expiration

Hi,
I need help on changing the subscription expiration using MSDE, i would
like to know how can i do this, im not familiar with OSQL commands.
Thanks
Is there anyone out there who knows this? i know this is simple for
those who already knows how, all i need is a simple parameter commands
on how to set the subscription expiration on the MSDE. If only the
requirement is SQL enterprise manager then i wont be here on the first
place. Please help.
Thanks
|||Since this is the SQL Server MSDE group then guys here should know at
least what im talking about.
|||> Since this is the SQL Server MSDE group then guys here should know at
> least what im talking about.
And i demand an answer right now?
MSDE can be downloaded for free and no subscription is needed So what are
you talking about?
Cheers,
Erik
"Angelo" <oracle_sigma@.yahoo.com> schreef in bericht
news:1138340405.295057.256040@.g43g2000cwa.googlegr oups.com...
> Since this is the SQL Server MSDE group then guys here should know at
> least what im talking about.
>
|||Hi Erik,
Thanks for the reply, what i need is a command parameters on how to set
the subscription expiration on MSDE, cause everytime when we didnt
synchronize our handhelds let say 3 weeks, it occurs a subscription
expiration. Could you tell me how can i set this just using the MSDE
osql commands?
really appreciate for your help
|||Hi Erik,
To clarify it more, please click on the link or copy and paste
http://groups.google.com.ph/group/mi...899b6eb4ce9f3a
All they are talking about is how to set USING enterprise manager, the
question is how can i set it using MSDE?
Thanks,
Angelo
|||Hi Erik,
To clarify it more, please copy and paste
http://groups.google.com.ph/group/mi...899b6eb4ce9f3a
All they are talking about is how to set USING enterprise manager, the
question is how can i set it using MSDE?
Thanks,
Angelo
|||See if these two articles help
http://msdn.microsoft.com/library/de...plmon_92ge.asp
http://msdn.microsoft.com/library/de..._repl_9b5a.asp
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Angelo" <oracle_sigma@.yahoo.com> wrote in message
news:1138590558.961274.264570@.g49g2000cwa.googlegr oups.com...
> Hi Erik,
> To clarify it more, please click on the link or copy and paste
> http://groups.google.com.ph/group/mi...899b6eb4ce9f3a
> All they are talking about is how to set USING enterprise manager, the
> question is how can i set it using MSDE?
> Thanks,
> Angelo
>
|||Hi Roger,
Many thanks for the info, yes it help me in some ways also. Can you
take a look on the scripts below if this is the one that i have to do?
Can you specifically key in all the necessary things?
************************************************** *******
DECLARE @.publication AS sysname
SET @.publication = N'[my_publication]'
USE [my_database]
EXEC sp_changepublication @.publication = @.publication,
@.property = N'retention',
@.value = [my_value]
GO
************************************************** ************
now the requirement is
Database Name = ServerDB
Publication Name = Pubserver1
Days required = at least 30 days
************************************************** ************
Actually someone gave me this instructions and i have to run this
scripts using osql -E -XXX.sql
Thanks,
Angelo
|||Hi Roger,
Can you help me put all the names to its proper place also?
When you have MSDE, is it 336 hours its default retention period
subscription expiration? or it depends on the service pack that it is
currently installed?
Thanks
Angelo

MSDE subscription expiration

Hi Guys,

We have an application that uses MSDE and Handheld devices. The problem is some users forgot to synch their handhelds for almost a month now.

I'm using MSDE and could someone help me how to change or set the subscription expiration using the OSQL command parameters?

I assume that the default hours of expiration of the subscription is 336 hours since it is the default of SQL enterprise which anyway it doesnt count since my requirement is MSDE. Actually my requirement is i want to set it to 720 hours.

I'm not sure also of what is the default subscription expiration on the MSDE side using the latest service pack 4. Could you please help me also on how to view the subscription expiration?

I've been looking for a solution in the microsoft website and i don't have any luck finding one.

Thanks,

Angelo

Is there someone here who knows this? i already got a 100+ viewers and still no replies. Can anyone tell me instead where should i ask about this issue.