MSmerge_agents table

Merge replication on SQL Server 2000 sp3 and Win 2000
Pull subscription with MSDE.
The subscribers need info on replication status.
I query MSmerge_history and MSmerge_agents with a join on agent ID.
I would like to filter by subscriber_name, but this field is empty for each
subscriber.
I've tried to drop a pull subsriptions many times. But this field stays
empty.
The field subscriber_id has a correct value and everything with replication
looks OK.
I think this should be the only one table with both fields subscriber_id and
subscriber_name together. So maybe the only way to know the ID of the
subscriber with his name.
1. Do I have another way to know pair subscriber_id <-> subscriber_name. So
I don't filter with subscriber_name, but with subscriber_id.
2. Can I without risk to update manually MSmerge_agents table after pull
subscription to fill correctly subscriber_name.
3. I've made something wrong during merge replication installation?
4. Bug (I can correct) ...
Thanks for help
Olivier
May be I was not so clear... Shorter version:
Is it normal to have null value in field subscriber_name
(distribution-MS_merge_agents) ?
Can I manually enter the correct value? I'm not used to do changes in system
tables without help of SP.
Thanks for help
Olivier
sql

MSDN Subscription SQL Server 2000

If we purchase a new MSDN Professional subscription, does it come with SQL Server 2000 developer license?Hi,

SQL Server is only not included in the MSDN Operation System and library subscriptions. For the rest a SQL Server Developer version is included, since now I am able to see 2005, 2000 and 6.5 in the download area.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||Thanks a lot.

MSDN Subscription Level for latest Yukon CTP

I'm working on some research that requires me to have access to the
latest CTP of Yukon, and I know it's available via MSDN subscription.
Can anyone tell me the minimum subscription level required to have
download access to the CTP?
Thanks
AllenSearch for SQL ServerT 2005 within
http://msdn.microsoft.com/subscript...ackinglist.aspx
It looks like it is included with MSDN Professional.
Keith
"Allen White" <amwhite@.oco.net> wrote in message
news:825fv05697ud46c5iqrm63r9gl8fhep73e@.
4ax.com...
> I'm working on some research that requires me to have access to the
> latest CTP of Yukon, and I know it's available via MSDN subscription.
> Can anyone tell me the minimum subscription level required to have
> download access to the CTP?
> Thanks
> Allen|||Thanks, Kieth, but in the shipment lists in all levels it only shows
Beta 2 of SQL Server 2005, and I know that the CTP (Beta 3, currently)
is available for download on the web site at least at the Universal
level. I'm looking to find out the minimum level at which it's
available.
Allen
On Wed, 26 Jan 2005 07:12:38 -0600, "Keith Kratochvil"
<sqlguy.back2u@.comcast.net> wrote:

>Search for SQL ServerT 2005 within
>http://msdn.microsoft.com/subscript...ackinglist.aspx
>It looks like it is included with MSDN Professional.|||My point is:
If it ships with version x of the MSDN Subscription then it should be
available via the download center.
Keith
"Allen White" <amwhite@.oco.net> wrote in message
news:lm6fv0h1d1r4mdjmjeiedsro5g2nbe9jnp@.
4ax.com...
> Thanks, Kieth, but in the shipment lists in all levels it only shows
> Beta 2 of SQL Server 2005, and I know that the CTP (Beta 3, currently)
> is available for download on the web site at least at the Universal
> level. I'm looking to find out the minimum level at which it's
> available.
> Allen
> On Wed, 26 Jan 2005 07:12:38 -0600, "Keith Kratochvil"
> <sqlguy.back2u@.comcast.net> wrote:
>
>|||Keith Kratochvil wrote:

>My point is:
>If it ships with version x of the MSDN Subscription then it should be
>available via the download center.
>
>
Yes, but the converse is not true. The download center provides much more
than what is shipped. The CTP builds of SQL Server, not the Beta releases,
are what the poster asked about, and they are not included in any MSDN
shipments, so the shipment lists won't help answer the question.
I believe the two CTP builds released so far are available to all
MSDN subscribers, regardless of subscription level. At least that's
what it says at
http://www.microsoft.com/presspass/...erLowCostPR.asp
I haven't heard anyone complain that they are an MSDN
subscriber but couldn't get the CTP, either. For the record,
the December CTP of the Express version (the SQL engine
with some limitations and no tools) is available to anyone,
MSDN subscriber or not, here:
http://lab.msdn.microsoft.com/express/sql/
Steve Kass
Drew University|||Thanks
Keith|||Thanks, Steve. That linked helped a lot.
Allen
On Wed, 26 Jan 2005 09:35:31 -0500, Steve Kass <skass@.drew.edu> wrote:

>
>Keith Kratochvil wrote:
>
>Yes, but the converse is not true. The download center provides much more
>than what is shipped. The CTP builds of SQL Server, not the Beta releases,
>are what the poster asked about, and they are not included in any MSDN
>shipments, so the shipment lists won't help answer the question.
>I believe the two CTP builds released so far are available to all
>MSDN subscribers, regardless of subscription level. At least that's
>what it says at
>http://www.microsoft.com/presspass/...om/express/sql/
>Steve Kass
>Drew University

MSDN Subscription Level for latest Yukon CTP

I'm working on some research that requires me to have access to the
latest CTP of Yukon, and I know it's available via MSDN subscription.
Can anyone tell me the minimum subscription level required to have
download access to the CTP?
Thanks
Allen
Search for SQL ServerT 2005 within
http://msdn.microsoft.com/subscripti...ckinglist.aspx
It looks like it is included with MSDN Professional.
Keith
"Allen White" <amwhite@.oco.net> wrote in message
news:825fv05697ud46c5iqrm63r9gl8fhep73e@.4ax.com...
> I'm working on some research that requires me to have access to the
> latest CTP of Yukon, and I know it's available via MSDN subscription.
> Can anyone tell me the minimum subscription level required to have
> download access to the CTP?
> Thanks
> Allen
|||Thanks, Kieth, but in the shipment lists in all levels it only shows
Beta 2 of SQL Server 2005, and I know that the CTP (Beta 3, currently)
is available for download on the web site at least at the Universal
level. I'm looking to find out the minimum level at which it's
available.
Allen
On Wed, 26 Jan 2005 07:12:38 -0600, "Keith Kratochvil"
<sqlguy.back2u@.comcast.net> wrote:

>Search for SQL ServerT 2005 within
>http://msdn.microsoft.com/subscripti...ckinglist.aspx
>It looks like it is included with MSDN Professional.
|||My point is:
If it ships with version x of the MSDN Subscription then it should be
available via the download center.
Keith
"Allen White" <amwhite@.oco.net> wrote in message
news:lm6fv0h1d1r4mdjmjeiedsro5g2nbe9jnp@.4ax.com...
> Thanks, Kieth, but in the shipment lists in all levels it only shows
> Beta 2 of SQL Server 2005, and I know that the CTP (Beta 3, currently)
> is available for download on the web site at least at the Universal
> level. I'm looking to find out the minimum level at which it's
> available.
> Allen
> On Wed, 26 Jan 2005 07:12:38 -0600, "Keith Kratochvil"
> <sqlguy.back2u@.comcast.net> wrote:
>
|||Keith Kratochvil wrote:

>My point is:
>If it ships with version x of the MSDN Subscription then it should be
>available via the download center.
>
>
Yes, but the converse is not true. The download center provides much more
than what is shipped. The CTP builds of SQL Server, not the Beta releases,
are what the poster asked about, and they are not included in any MSDN
shipments, so the shipment lists won't help answer the question.
I believe the two CTP builds released so far are available to all
MSDN subscribers, regardless of subscription level. At least that's
what it says at
http://www.microsoft.com/presspass/p...rLowCostPR.asp
I haven't heard anyone complain that they are an MSDN
subscriber but couldn't get the CTP, either. For the record,
the December CTP of the Express version (the SQL engine
with some limitations and no tools) is available to anyone,
MSDN subscriber or not, here:
http://lab.msdn.microsoft.com/express/sql/
Steve Kass
Drew University
|||Thanks
Keith
|||Thanks, Steve. That linked helped a lot.
Allen
On Wed, 26 Jan 2005 09:35:31 -0500, Steve Kass <skass@.drew.edu> wrote:

>
>Keith Kratochvil wrote:
>Yes, but the converse is not true. The download center provides much more
>than what is shipped. The CTP builds of SQL Server, not the Beta releases,
>are what the poster asked about, and they are not included in any MSDN
>shipments, so the shipment lists won't help answer the question.
>I believe the two CTP builds released so far are available to all
>MSDN subscribers, regardless of subscription level. At least that's
>what it says at
>http://www.microsoft.com/presspass/p...rLowCostPR.asp
>I haven't heard anyone complain that they are an MSDN
>subscriber but couldn't get the CTP, either. For the record,
>the December CTP of the Express version (the SQL engine
>with some limitations and no tools) is available to anyone,
>MSDN subscriber or not, here:
>http://lab.msdn.microsoft.com/express/sql/
>Steve Kass
>Drew University

MSDN Subscription Level for latest Yukon CTP

I'm working on some research that requires me to have access to the
latest CTP of Yukon, and I know it's available via MSDN subscription.
Can anyone tell me the minimum subscription level required to have
download access to the CTP?
Thanks
AllenSearch for SQL ServerT 2005 within
http://msdn.microsoft.com/subscriptions/index/packinglist.aspx
It looks like it is included with MSDN Professional.
--
Keith
"Allen White" <amwhite@.oco.net> wrote in message
news:825fv05697ud46c5iqrm63r9gl8fhep73e@.4ax.com...
> I'm working on some research that requires me to have access to the
> latest CTP of Yukon, and I know it's available via MSDN subscription.
> Can anyone tell me the minimum subscription level required to have
> download access to the CTP?
> Thanks
> Allen|||Thanks, Kieth, but in the shipment lists in all levels it only shows
Beta 2 of SQL Server 2005, and I know that the CTP (Beta 3, currently)
is available for download on the web site at least at the Universal
level. I'm looking to find out the minimum level at which it's
available.
Allen
On Wed, 26 Jan 2005 07:12:38 -0600, "Keith Kratochvil"
<sqlguy.back2u@.comcast.net> wrote:
>Search for SQL ServerT 2005 within
>http://msdn.microsoft.com/subscriptions/index/packinglist.aspx
>It looks like it is included with MSDN Professional.|||My point is:
If it ships with version x of the MSDN Subscription then it should be
available via the download center.
--
Keith
"Allen White" <amwhite@.oco.net> wrote in message
news:lm6fv0h1d1r4mdjmjeiedsro5g2nbe9jnp@.4ax.com...
> Thanks, Kieth, but in the shipment lists in all levels it only shows
> Beta 2 of SQL Server 2005, and I know that the CTP (Beta 3, currently)
> is available for download on the web site at least at the Universal
> level. I'm looking to find out the minimum level at which it's
> available.
> Allen
> On Wed, 26 Jan 2005 07:12:38 -0600, "Keith Kratochvil"
> <sqlguy.back2u@.comcast.net> wrote:
> >Search for SQL ServerT 2005 within
> >http://msdn.microsoft.com/subscriptions/index/packinglist.aspx
> >It looks like it is included with MSDN Professional.
>|||Keith Kratochvil wrote:
>My point is:
>If it ships with version x of the MSDN Subscription then it should be
>available via the download center.
>
>
Yes, but the converse is not true. The download center provides much more
than what is shipped. The CTP builds of SQL Server, not the Beta releases,
are what the poster asked about, and they are not included in any MSDN
shipments, so the shipment lists won't help answer the question.
I believe the two CTP builds released so far are available to all
MSDN subscribers, regardless of subscription level. At least that's
what it says at
http://www.microsoft.com/presspass/press/2004/dec04/12-03ServerLowCostPR.asp
I haven't heard anyone complain that they are an MSDN
subscriber but couldn't get the CTP, either. For the record,
the December CTP of the Express version (the SQL engine
with some limitations and no tools) is available to anyone,
MSDN subscriber or not, here:
http://lab.msdn.microsoft.com/express/sql/
Steve Kass
Drew University|||Thanks
--
Keith|||Thanks, Steve. That linked helped a lot.
Allen
On Wed, 26 Jan 2005 09:35:31 -0500, Steve Kass <skass@.drew.edu> wrote:
>
>Keith Kratochvil wrote:
>>My point is:
>>If it ships with version x of the MSDN Subscription then it should be
>>available via the download center.
>>
>Yes, but the converse is not true. The download center provides much more
>than what is shipped. The CTP builds of SQL Server, not the Beta releases,
>are what the poster asked about, and they are not included in any MSDN
>shipments, so the shipment lists won't help answer the question.
>I believe the two CTP builds released so far are available to all
>MSDN subscribers, regardless of subscription level. At least that's
>what it says at
>http://www.microsoft.com/presspass/press/2004/dec04/12-03ServerLowCostPR.asp
>I haven't heard anyone complain that they are an MSDN
>subscriber but couldn't get the CTP, either. For the record,
>the December CTP of the Express version (the SQL engine
>with some limitations and no tools) is available to anyone,
>MSDN subscriber or not, here:
>http://lab.msdn.microsoft.com/express/sql/
>Steve Kass
>Drew University

MSDN SQL 2k Enterprise CD

Anybody know if the SQL 2k Enterprise Edition that comes on the MSDN DVD/CD
subscription is crippled in any way? I am wondering if there is a processor
limit, memory limit, concurrent user connection limit, etc. Thanks. Want
to run it on a duplicate data center.
EricAs long as it isn't actually the developer edition you should be OK but for
what it sounds like your doing requires an actual license.
--
Andrew J. Kelly
SQL Server MVP
"Eric Sabine" <mopar41@.hhhotmail.com> wrote in message
news:3f099700$0$845$39cecf19@.news.twtelecom.net...
> Anybody know if the SQL 2k Enterprise Edition that comes on the MSDN
DVD/CD
> subscription is crippled in any way? I am wondering if there is a
processor
> limit, memory limit, concurrent user connection limit, etc. Thanks. Want
> to run it on a duplicate data center.
> Eric
>|||This sounds like a licensing issue, not a functionality issue. I don't
think what you're planning on doing is legal... the license that comes with
MSDN is for development and testing only, not for redundancy / clustering /
load balancing...
"Eric Sabine" <mopar41@.hhhotmail.com> wrote in message
news:3f099700$0$845$39cecf19@.news.twtelecom.net...
> Anybody know if the SQL 2k Enterprise Edition that comes on the MSDN
DVD/CD
> subscription is crippled in any way? I am wondering if there is a
processor
> limit, memory limit, concurrent user connection limit, etc. Thanks. Want
> to run it on a duplicate data center.
> Eric
>|||Sorry for not being clear. This is not how you interpreted it, it was my
fault. We have 2 data centers. One live one, one for testing, attacking,
alternate deployment schemas, etc. That second installation of sql2k is for
an upcoming load test under various raid configs. The plan is to have
numerous clients in a test environment network hammer the server. I was
wondering if the install from the MSDN disks had limitations and thus would
not yield legitimate results.
Do you and Aaron believe this type of testing requires a license too? That
is important to know.
Thanks!
Eric
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eQeLckKRDHA.3144@.tk2msftngp13.phx.gbl...
> As long as it isn't actually the developer edition you should be OK but
for
> what it sounds like your doing requires an actual license.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "Eric Sabine" <mopar41@.hhhotmail.com> wrote in message
> news:3f099700$0$845$39cecf19@.news.twtelecom.net...
> > Anybody know if the SQL 2k Enterprise Edition that comes on the MSDN
> DVD/CD
> > subscription is crippled in any way? I am wondering if there is a
> processor
> > limit, memory limit, concurrent user connection limit, etc. Thanks.
Want
> > to run it on a duplicate data center.
> >
> > Eric
> >
> >
>|||That sounds like the MSDN version should be fine without the need for a
license other than the MSDN one. There should not be any limitations that
you have to worry about, it is just like the fully licensed version.
--
Andrew J. Kelly
SQL Server MVP
"Eric Sabine" <mopar41@.microsoft's hot mail . com> wrote in message
news:oMjOa.177401$_w.7595224@.twister.southeast.rr.com...
> Sorry for not being clear. This is not how you interpreted it, it was my
> fault. We have 2 data centers. One live one, one for testing, attacking,
> alternate deployment schemas, etc. That second installation of sql2k is
for
> an upcoming load test under various raid configs. The plan is to have
> numerous clients in a test environment network hammer the server. I was
> wondering if the install from the MSDN disks had limitations and thus
would
> not yield legitimate results.
> Do you and Aaron believe this type of testing requires a license too?
That
> is important to know.
> Thanks!
> Eric
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:eQeLckKRDHA.3144@.tk2msftngp13.phx.gbl...
> > As long as it isn't actually the developer edition you should be OK but
> for
> > what it sounds like your doing requires an actual license.
> >
> > --
> >
> > Andrew J. Kelly
> > SQL Server MVP
> >
> >
> > "Eric Sabine" <mopar41@.hhhotmail.com> wrote in message
> > news:3f099700$0$845$39cecf19@.news.twtelecom.net...
> > > Anybody know if the SQL 2k Enterprise Edition that comes on the MSDN
> > DVD/CD
> > > subscription is crippled in any way? I am wondering if there is a
> > processor
> > > limit, memory limit, concurrent user connection limit, etc. Thanks.
> Want
> > > to run it on a duplicate data center.
> > >
> > > Eric
> > >
> > >
> >
> >
>