Merge filtering HOST_NAME help

Hello
Im trying to create a merge replication.
I've a 2xSubscribers and a distributor/publisher
My published table has fieldnames describing what server this row should be published. When I create my replication a use a filter like this: ... where target_server = host_name()
I want to publish rows to different subscribers, for instance i have a server with hostname 'BOBAFETT' and another with hostname 'R2D2' and a distributor/publisher with hostname 'SKYWALKER'. When I insert a row into the publisher I cannot get it replicate
d unless i use SKYWALKER as target_server, but I will use BOBAFETT or R2D2 as target_server, thereby getting the correct row to the intended subscriber!!
Another strange thing, when I insert a row into the subscriber it gets deleted and nothing is inserted into the publishers table!!
My own thoughts is that the host_name() only applies to the publisher and not the subscriber, therefore im only able to publish tows with the publisher name as fieldvalue - That's not quite what I would expect.
Ohh btw. If I hardcode BOBAFETT in the filter where clause it gets the correct rows!!
Can anybody help me?
Kind regards
Janus, Denmark
Janus,
as SKYWALKER is your publication server, this should amalgamate all the rows. The other servers BOBAFETT and R2D2 will be restricted to having rows with their own server name in the filtering column ie on R2D2 you can add rows with R2D2 but you can't add
a record having the value SKYWALKER.
BTW, there is another way of setting it up which is less restrictive - you can use -HOSTNAME 'value' as a parameter in the merge agent's job. This means that you aren't restricted to having a column with R2D2 or BOBAFETT in it, and instead you could have
some business indicator.
HTH,
Paul Ibison, London, UK

Merge Documentation

I've been reading the documentation on merge replication in BOL and I feel
like it's too fragmented. Can anyone recommend links/books that explain it
clearly? (And no I don't mind someone plugging their own material.)
I have written a book which is being edited. I am not sure when it will be
out, but soon.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"CLM" <CLM@.discussions.microsoft.com> wrote in message
news:84EB200B-CFC1-420F-9813-4E9671B9012D@.microsoft.com...
> I've been reading the documentation on merge replication in BOL and I feel
> like it's too fragmented. Can anyone recommend links/books that explain
> it
> clearly? (And no I don't mind someone plugging their own material.)
sql

memoryleak?

Hello,
I've monitoring my sql server 2000 for awhile now and i see in the
taskmanager that the memoryusage was very high.
If nobody is doing something in the database the memory is at approx. 23 mb,
but when there are connections with sql server the memory increases to above
100mb!.
Is this normal behavior, because i can't tell. My server has w2k advanced
server as the os and has 2 processor and a gigabyte of memory.
Thnx
This should explain it:
INF: SQL Server Memory Usage
http://support.microsoft.com/default...b;en-us;321363
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Ezekil" <ezekil@.lycos.com> wrote in message
news:%23JNn1m4fEHA.3928@.TK2MSFTNGP11.phx.gbl...
Hello,
I've monitoring my sql server 2000 for awhile now and i see in the
taskmanager that the memoryusage was very high.
If nobody is doing something in the database the memory is at approx. 23 mb,
but when there are connections with sql server the memory increases to above
100mb!.
Is this normal behavior, because i can't tell. My server has w2k advanced
server as the os and has 2 processor and a gigabyte of memory.
Thnx

Memory usage on SQL Server over 2 GB

Our SQL Server was using almost all 2GB of available RAM on the machine, so
we upgraded RAM to 3GB. Since then I've noticed it's still using almost
exactly 2GB. I'm guessing this means there is some limitation on how much
memory SQL Server will make use of. Is there some switch that allows SQL to
make use of the additional memory ?
SQL Server 2000 on Windows 2000 (both standard editions)
Hi,
SQL Server 2000 Standard edition will only allow a maximum of 2GB RAM. So the rest 1 GB will be used for all the other application including OS.
SQL Server Enterprise will support 4 GB RAM.
Thanks
Hari
MCDBA
-- Richard wrote: --
Our SQL Server was using almost all 2GB of available RAM on the machine, so
we upgraded RAM to 3GB. Since then I've noticed it's still using almost
exactly 2GB. I'm guessing this means there is some limitation on how much
memory SQL Server will make use of. Is there some switch that allows SQL to
make use of the additional memory ?
SQL Server 2000 on Windows 2000 (both standard editions)

Memory Usage Exceeded Maximum Memory Configuration

Hi,
I'm running SQL Server 2000 on an NT Workstation with 1GB
of memory. I've configured the maximum memory of the SQL
Server to be 512MB, but when I check Task Manager it shows
the Memory Usage of sqlservr.exe to be more than 512MB.
(Currently at 560MB). Is it normal that sqlservr.exe will
use more than the maximum allowed?
Thanks in advance,
Alice
SQL Server Version I'm running:
Microsoft SQL Server 2000 - 8.00.534 (Intel X86)
Nov 19 2001 13:23:50
Copyright (c) 1988-2000 Microsoft Corporation
Personal Edition on Windows NT 4.0 (Build 1381:
Service Pack 6)
Maximum memory is for Physical Memory.
Task manager shows all, physical and virtual memory.
"Alice" wrote:

> Hi,
> I'm running SQL Server 2000 on an NT Workstation with 1GB
> of memory. I've configured the maximum memory of the SQL
> Server to be 512MB, but when I check Task Manager it shows
> the Memory Usage of sqlservr.exe to be more than 512MB.
> (Currently at 560MB). Is it normal that sqlservr.exe will
> use more than the maximum allowed?
> Thanks in advance,
> Alice
> SQL Server Version I'm running:
> Microsoft SQL Server 2000 - 8.00.534 (Intel X86)
> Nov 19 2001 13:23:50
> Copyright (c) 1988-2000 Microsoft Corporation
> Personal Edition on Windows NT 4.0 (Build 1381:
> Service Pack 6)
>
>
>
>
|||The Max setting is for the memory pool only. There is an area called
MemtoLeave (by default up to 256MB) that is not part of that setting so it
is possible for SQL Server to use more than the Max under certain
conditions.
Andrew J. Kelly SQL MVP
"Alice" <achan@.icescape.com> wrote in message
news:278f601c46392$73dd3b30$a401280a@.phx.gbl...
> Hi,
> I'm running SQL Server 2000 on an NT Workstation with 1GB
> of memory. I've configured the maximum memory of the SQL
> Server to be 512MB, but when I check Task Manager it shows
> the Memory Usage of sqlservr.exe to be more than 512MB.
> (Currently at 560MB). Is it normal that sqlservr.exe will
> use more than the maximum allowed?
> Thanks in advance,
> Alice
> SQL Server Version I'm running:
> Microsoft SQL Server 2000 - 8.00.534 (Intel X86)
> Nov 19 2001 13:23:50
> Copyright (c) 1988-2000 Microsoft Corporation
> Personal Edition on Windows NT 4.0 (Build 1381:
> Service Pack 6)
>
>
>
>

Memory question

I've been reading a lot of the posts about memory but I'm still unclear.
We have 3.37GB RAM - Win2003 SP1 - SQL2005 SP1.
Min Server Memory = 0
Max Server Memory=2147483647
Will SQL use more than 2GB memory with this setup. I saw note of a boot.ini
file in other posts but I couldn't find one on our server. Will SQL use 3GB
if it needs it?
Thanks.
Ron
Hi
Min and Max server memory settings are in Megabytes.
You need to set the /3GB switch in boot.ini for SQL Server to use more than
2GB RAM in your configuration.
Regards
Michel Epprecht [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:0A1CE509-ACE9-4D01-8F54-757C38074D91@.microsoft.com...
> I've been reading a lot of the posts about memory but I'm still unclear.
> We have 3.37GB RAM - Win2003 SP1 - SQL2005 SP1.
> Min Server Memory = 0
> Max Server Memory=2147483647
> Will SQL use more than 2GB memory with this setup. I saw note of a
> boot.ini
> file in other posts but I couldn't find one on our server. Will SQL use
> 3GB
> if it needs it?
> Thanks.
> Ron
>
|||Where is the boot.ini file? I search the hard drive and couldn't find it.
"Michael Epprecht [MSFT]" wrote:

> Hi
> Min and Max server memory settings are in Megabytes.
> You need to set the /3GB switch in boot.ini for SQL Server to use more than
> 2GB RAM in your configuration.
> --
> Regards
> Michel Epprecht [MSFT]
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:0A1CE509-ACE9-4D01-8F54-757C38074D91@.microsoft.com...
>