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
Showing posts with label subscription. Show all posts
Showing posts with label subscription. Show all posts
Friday, March 30, 2012
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.Friday, March 23, 2012
MSDE pricing policy about CAL
hi
i have a right to use and deploy MSDE with my application
because i am a member of MSDN enterprise subscription..
but
1. i dont know should i buy CAL for client if my solution is server/client
architecture?
2. i dont know should i buy CAL for client if my solution is internet
architecture?
JINYou don't need CALs for use with MSDE, it's all free if you have an MSDN
subscription.
The downside of MSDE is ofcourse that the database size is limited (2GB max)
and the number of concurrent workloads as well, so not many users can
connect to it at the same time, which all makes it only usuable for small
scale applications:
For more info see:
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
Jacco Schalkwijk
SQL Server MVP
"ice" <yjwon@.geomania.com> wrote in message
news:blua3h$2a9$1@.news.hananet.net...
> hi
> i have a right to use and deploy MSDE with my application
> because i am a member of MSDN enterprise subscription..
> but
> 1. i dont know should i buy CAL for client if my solution is server/client
> architecture?
> 2. i dont know should i buy CAL for client if my solution is internet
> architecture?
> JIN
>
>|||You would only need CALs in this case, I believe, if you are going to use
SQL Server client tools (such as Enterprise Manager, Query Analyzer, etc) to
manage the database(s).
However, I am not a lawyer, and have not spent the last 8 years forensically
examining the EULA for MSDE. So don't consider this legal advice, only
practical and largely unsolicited. :-)
"ice" <yjwon@.geomania.com> wrote in message
news:blua3h$2a9$1@.news.hananet.net...
> hi
> i have a right to use and deploy MSDE with my application
> because i am a member of MSDN enterprise subscription..
> but
> 1. i dont know should i buy CAL for client if my solution is server/client
> architecture?
> 2. i dont know should i buy CAL for client if my solution is internet
> architecture?
> JIN
>
>|||Maybe it is time for microsoft.public.sqlserver.licensing? ;-)
Your answer made me think, and after some searching I now think that you
don't need CALs to use EM with MSDE, but you need a SQL Server production
license (Standard or Enterprise) to use EM, MSDN or Developer Edition won't
do. Alternatively, there are freeware tools available for use with MSDE,
search google for "MSDE tools".
--
Jacco Schalkwijk
SQL Server MVP
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:OA$n4xNjDHA.2560@.TK2MSFTNGP12.phx.gbl...
> You would only need CALs in this case, I believe, if you are going to use
> SQL Server client tools (such as Enterprise Manager, Query Analyzer, etc)
to
> manage the database(s).
> However, I am not a lawyer, and have not spent the last 8 years
forensically
> examining the EULA for MSDE. So don't consider this legal advice, only
> practical and largely unsolicited. :-)
>
>
> "ice" <yjwon@.geomania.com> wrote in message
> news:blua3h$2a9$1@.news.hananet.net...
> > hi
> >
> > i have a right to use and deploy MSDE with my application
> > because i am a member of MSDN enterprise subscription..
> >
> > but
> >
> > 1. i dont know should i buy CAL for client if my solution is
server/client
> > architecture?
> >
> > 2. i dont know should i buy CAL for client if my solution is internet
> > architecture?
> >
> > JIN
> >
> >
> >
> >
>|||> Maybe it is time for microsoft.public.sqlserver.licensing? ;-)
I agree. MS legal should be responsible for fielding questions about
licensing, because none of us can ever seem to get it straight.
> Your answer made me think, and after some searching I now think that you
> don't need CALs to use EM with MSDE, but you need a SQL Server production
> license (Standard or Enterprise) to use EM,
That might be true. I assume, though, that if you have a SQL Server
production license and are using EM against it, you either need a CAL to do
so (and in turn to use it against MSDE as well), or else you have paid for
processor license(s) (in which case you've spent enough money that, ideally,
they shouldn't hassle you for MSDE :-))))).
Again, not legal advice, of course.
> Alternatively, there are freeware tools available for use with MSDE,
> search google for "MSDE tools".
I also maintain a list: http://www.aspfaq.com/2442|||Also, this verbage is interesting, from
http://www.microsoft.com/sql/howtobuy/faq.asp :
Q. What type of license do I need if SQL Server Personal Edition or
Microsoft SQL Server Desktop Engine (MSDE) accesses SQL Server?
A. It depends on which licensing model you have for SQL Server. Here are the
guidelines:
- Processor license. You can install SQL Server Personal Edition and
MSDE on any number of devices for use with SQL Server.
- Server plus device CAL. You must have a CAL for each device on which
SQL Server Personal Edition or MSDE is installed.
- Server plus user CAL. You must have a CAL for each user accessing SQL
Server Personal Edition or MSDE.
I don't even think the web site has it right... they're lumping PE and MSDE
together, when they are clearly different beasts.
i have a right to use and deploy MSDE with my application
because i am a member of MSDN enterprise subscription..
but
1. i dont know should i buy CAL for client if my solution is server/client
architecture?
2. i dont know should i buy CAL for client if my solution is internet
architecture?
JINYou don't need CALs for use with MSDE, it's all free if you have an MSDN
subscription.
The downside of MSDE is ofcourse that the database size is limited (2GB max)
and the number of concurrent workloads as well, so not many users can
connect to it at the same time, which all makes it only usuable for small
scale applications:
For more info see:
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
Jacco Schalkwijk
SQL Server MVP
"ice" <yjwon@.geomania.com> wrote in message
news:blua3h$2a9$1@.news.hananet.net...
> hi
> i have a right to use and deploy MSDE with my application
> because i am a member of MSDN enterprise subscription..
> but
> 1. i dont know should i buy CAL for client if my solution is server/client
> architecture?
> 2. i dont know should i buy CAL for client if my solution is internet
> architecture?
> JIN
>
>|||You would only need CALs in this case, I believe, if you are going to use
SQL Server client tools (such as Enterprise Manager, Query Analyzer, etc) to
manage the database(s).
However, I am not a lawyer, and have not spent the last 8 years forensically
examining the EULA for MSDE. So don't consider this legal advice, only
practical and largely unsolicited. :-)
"ice" <yjwon@.geomania.com> wrote in message
news:blua3h$2a9$1@.news.hananet.net...
> hi
> i have a right to use and deploy MSDE with my application
> because i am a member of MSDN enterprise subscription..
> but
> 1. i dont know should i buy CAL for client if my solution is server/client
> architecture?
> 2. i dont know should i buy CAL for client if my solution is internet
> architecture?
> JIN
>
>|||Maybe it is time for microsoft.public.sqlserver.licensing? ;-)
Your answer made me think, and after some searching I now think that you
don't need CALs to use EM with MSDE, but you need a SQL Server production
license (Standard or Enterprise) to use EM, MSDN or Developer Edition won't
do. Alternatively, there are freeware tools available for use with MSDE,
search google for "MSDE tools".
--
Jacco Schalkwijk
SQL Server MVP
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:OA$n4xNjDHA.2560@.TK2MSFTNGP12.phx.gbl...
> You would only need CALs in this case, I believe, if you are going to use
> SQL Server client tools (such as Enterprise Manager, Query Analyzer, etc)
to
> manage the database(s).
> However, I am not a lawyer, and have not spent the last 8 years
forensically
> examining the EULA for MSDE. So don't consider this legal advice, only
> practical and largely unsolicited. :-)
>
>
> "ice" <yjwon@.geomania.com> wrote in message
> news:blua3h$2a9$1@.news.hananet.net...
> > hi
> >
> > i have a right to use and deploy MSDE with my application
> > because i am a member of MSDN enterprise subscription..
> >
> > but
> >
> > 1. i dont know should i buy CAL for client if my solution is
server/client
> > architecture?
> >
> > 2. i dont know should i buy CAL for client if my solution is internet
> > architecture?
> >
> > JIN
> >
> >
> >
> >
>|||> Maybe it is time for microsoft.public.sqlserver.licensing? ;-)
I agree. MS legal should be responsible for fielding questions about
licensing, because none of us can ever seem to get it straight.
> Your answer made me think, and after some searching I now think that you
> don't need CALs to use EM with MSDE, but you need a SQL Server production
> license (Standard or Enterprise) to use EM,
That might be true. I assume, though, that if you have a SQL Server
production license and are using EM against it, you either need a CAL to do
so (and in turn to use it against MSDE as well), or else you have paid for
processor license(s) (in which case you've spent enough money that, ideally,
they shouldn't hassle you for MSDE :-))))).
Again, not legal advice, of course.
> Alternatively, there are freeware tools available for use with MSDE,
> search google for "MSDE tools".
I also maintain a list: http://www.aspfaq.com/2442|||Also, this verbage is interesting, from
http://www.microsoft.com/sql/howtobuy/faq.asp :
Q. What type of license do I need if SQL Server Personal Edition or
Microsoft SQL Server Desktop Engine (MSDE) accesses SQL Server?
A. It depends on which licensing model you have for SQL Server. Here are the
guidelines:
- Processor license. You can install SQL Server Personal Edition and
MSDE on any number of devices for use with SQL Server.
- Server plus device CAL. You must have a CAL for each device on which
SQL Server Personal Edition or MSDE is installed.
- Server plus user CAL. You must have a CAL for each user accessing SQL
Server Personal Edition or MSDE.
I don't even think the web site has it right... they're lumping PE and MSDE
together, when they are clearly different beasts.
Subscribe to:
Posts (Atom)