sql server msde: 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.

[quoted text, click to view]
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.googlegroups.com...
[quoted text, click to view]

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/microsoft.public.sqlserver.replication/browse_thread/thread/2c5cbcb76e41432d/59899b6eb4ce9f3a?lnk=st&q=subscription+expiration&rnum=2#59899b6eb4ce9f3a

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/microsoft.public.sqlserver.replication/browse_thread/thread/2c5cbcb76e41432d/59899b6eb4ce9f3a?lnk=st&q=subscription+expiration&rnum=2#59899b6eb4ce9f3a

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/default.asp?url=/library/en-us/replsql/replmon_92ge.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_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

[quoted text, click to view]

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

Hello? Anyone home?

Sorry, we do sleep over here sometimes. I'm not competent to fill in all
the values for you. You might try the replication newsgroup.

--
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

[quoted text, click to view]

[quoted text, click to view]

Is there anyone out there who can help me with this?