Hilary's Merger Replication Book ...

In Hilary's replication book there is mention of a second volume on merge
replication. Is this available yet? Is there a target date for publication?
Thanks,
Bob Castleman
DBA Poseur
I am mid way through it. I am not sure when it will be in print. Probably
not July.
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
"Bob Castleman" <nomail@.here> wrote in message
news:OQZlb6zeFHA.228@.TK2MSFTNGP12.phx.gbl...
> In Hilary's replication book there is mention of a second volume on merge
> replication. Is this available yet? Is there a target date for
publication?
> Thanks,
> Bob Castleman
> DBA Poseur
>
|||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
"Bob Castleman" <nomail@.here> wrote in message
news:OQZlb6zeFHA.228@.TK2MSFTNGP12.phx.gbl...
> In Hilary's replication book there is mention of a second volume on merge
> replication. Is this available yet? Is there a target date for
publication?
> Thanks,
> Bob Castleman
> DBA Poseur
>

High Volume of Net Traffic coming from MSSQL

We're having a bit of an issue with network traffic being generated from one
of our MSSQL Servers.
It seems that when we launch Enterprise Manager on a remote computer
(usually at another office), the MSSQL servers start sending packets to the
EM regardless of whether we are maintaining an active connection to the
server or not. What is happening is that these packets are being lost and
reported in our firewall as 'host unreachable'. These packets are also
firing every second for each EM open across our network, so this is becoming
a bit of a pain for our poor network guys. The other odd thing is that the
firewall is only reporting one-way traffic, from the server to the client,
but the client is not sending any traffic back down unless it is actively
connected to the remote server.
Any thoughts as to why this might be happening, or better yet, a way to cull
this traffic?
We're running MSSQL 2000 SP3a on Windows 2003 servers.
Thanks in advance!
Mike,Have you applied the post-SP3a hotfix?
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Mike Schurkin" <MikeSchurkin@.discussions.microsoft.com> wrote in message
news:C948BB2C-1A9D-4B73-9BDF-72B74A1FA9A2@.microsoft.com...
We're having a bit of an issue with network traffic being generated from one
of our MSSQL Servers.
It seems that when we launch Enterprise Manager on a remote computer
(usually at another office), the MSSQL servers start sending packets to the
EM regardless of whether we are maintaining an active connection to the
server or not. What is happening is that these packets are being lost and
reported in our firewall as 'host unreachable'. These packets are also
firing every second for each EM open across our network, so this is becoming
a bit of a pain for our poor network guys. The other odd thing is that the
firewall is only reporting one-way traffic, from the server to the client,
but the client is not sending any traffic back down unless it is actively
connected to the remote server.
Any thoughts as to why this might be happening, or better yet, a way to cull
this traffic?
We're running MSSQL 2000 SP3a on Windows 2003 servers.
Thanks in advance!
Mike,|||We have the entire SP3a hotfix installed, but I am unaware of a post SP3a fix
- are you referring to SP4?
"Tom Moreau" wrote:
> Have you applied the post-SP3a hotfix?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> ..
> "Mike Schurkin" <MikeSchurkin@.discussions.microsoft.com> wrote in message
> news:C948BB2C-1A9D-4B73-9BDF-72B74A1FA9A2@.microsoft.com...
> We're having a bit of an issue with network traffic being generated from one
> of our MSSQL Servers.
> It seems that when we launch Enterprise Manager on a remote computer
> (usually at another office), the MSSQL servers start sending packets to the
> EM regardless of whether we are maintaining an active connection to the
> server or not. What is happening is that these packets are being lost and
> reported in our firewall as 'host unreachable'. These packets are also
> firing every second for each EM open across our network, so this is becoming
> a bit of a pain for our poor network guys. The other odd thing is that the
> firewall is only reporting one-way traffic, from the server to the client,
> but the client is not sending any traffic back down unless it is actively
> connected to the remote server.
> Any thoughts as to why this might be happening, or better yet, a way to cull
> this traffic?
> We're running MSSQL 2000 SP3a on Windows 2003 servers.
> Thanks in advance!
> Mike,
>|||Define "entire SP3a hotfix". There is the service pack - SP3a - and then
there is the hotfix. Are you saying that you have applied SP3a but not the
hotfix? IOW, have you applied:
http://support.microsoft.com/kb/821277
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Mike Schurkin" <MikeSchurkin@.discussions.microsoft.com> wrote in message
news:5D90B16F-7EDB-401C-8022-106365D44347@.microsoft.com...
We have the entire SP3a hotfix installed, but I am unaware of a post SP3a
fix
- are you referring to SP4?
"Tom Moreau" wrote:
> Have you applied the post-SP3a hotfix?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> ..
> "Mike Schurkin" <MikeSchurkin@.discussions.microsoft.com> wrote in message
> news:C948BB2C-1A9D-4B73-9BDF-72B74A1FA9A2@.microsoft.com...
> We're having a bit of an issue with network traffic being generated from
> one
> of our MSSQL Servers.
> It seems that when we launch Enterprise Manager on a remote computer
> (usually at another office), the MSSQL servers start sending packets to
> the
> EM regardless of whether we are maintaining an active connection to the
> server or not. What is happening is that these packets are being lost and
> reported in our firewall as 'host unreachable'. These packets are also
> firing every second for each EM open across our network, so this is
> becoming
> a bit of a pain for our poor network guys. The other odd thing is that
> the
> firewall is only reporting one-way traffic, from the server to the client,
> but the client is not sending any traffic back down unless it is actively
> connected to the remote server.
> Any thoughts as to why this might be happening, or better yet, a way to
> cull
> this traffic?
> We're running MSSQL 2000 SP3a on Windows 2003 servers.
> Thanks in advance!
> Mike,
>

High Volume of Net Traffic coming from MSSQL

We're having a bit of an issue with network traffic being generated from one
of our MSSQL Servers.
It seems that when we launch Enterprise Manager on a remote computer
(usually at another office), the MSSQL servers start sending packets to the
EM regardless of whether we are maintaining an active connection to the
server or not. What is happening is that these packets are being lost and
reported in our firewall as 'host unreachable'. These packets are also
firing every second for each EM open across our network, so this is becoming
a bit of a pain for our poor network guys. The other odd thing is that the
firewall is only reporting one-way traffic, from the server to the client,
but the client is not sending any traffic back down unless it is actively
connected to the remote server.
Any thoughts as to why this might be happening, or better yet, a way to cull
this traffic?
We're running MSSQL 2000 SP3a on Windows 2003 servers.
Thanks in advance!
Mike,Have you applied the post-SP3a hotfix?
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Mike Schurkin" <MikeSchurkin@.discussions.microsoft.com> wrote in message
news:C948BB2C-1A9D-4B73-9BDF-72B74A1FA9A2@.microsoft.com...
We're having a bit of an issue with network traffic being generated from one
of our MSSQL Servers.
It seems that when we launch Enterprise Manager on a remote computer
(usually at another office), the MSSQL servers start sending packets to the
EM regardless of whether we are maintaining an active connection to the
server or not. What is happening is that these packets are being lost and
reported in our firewall as 'host unreachable'. These packets are also
firing every second for each EM open across our network, so this is becoming
a bit of a pain for our poor network guys. The other odd thing is that the
firewall is only reporting one-way traffic, from the server to the client,
but the client is not sending any traffic back down unless it is actively
connected to the remote server.
Any thoughts as to why this might be happening, or better yet, a way to cull
this traffic?
We're running MSSQL 2000 SP3a on Windows 2003 servers.
Thanks in advance!
Mike,|||We have the entire SP3a hotfix installed, but I am unaware of a post SP3a fi
x
- are you referring to SP4?
"Tom Moreau" wrote:

> Have you applied the post-SP3a hotfix?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> ..
> "Mike Schurkin" <MikeSchurkin@.discussions.microsoft.com> wrote in message
> news:C948BB2C-1A9D-4B73-9BDF-72B74A1FA9A2@.microsoft.com...
> We're having a bit of an issue with network traffic being generated from o
ne
> of our MSSQL Servers.
> It seems that when we launch Enterprise Manager on a remote computer
> (usually at another office), the MSSQL servers start sending packets to th
e
> EM regardless of whether we are maintaining an active connection to the
> server or not. What is happening is that these packets are being lost and
> reported in our firewall as 'host unreachable'. These packets are also
> firing every second for each EM open across our network, so this is becomi
ng
> a bit of a pain for our poor network guys. The other odd thing is that th
e
> firewall is only reporting one-way traffic, from the server to the client,
> but the client is not sending any traffic back down unless it is actively
> connected to the remote server.
> Any thoughts as to why this might be happening, or better yet, a way to cu
ll
> this traffic?
> We're running MSSQL 2000 SP3a on Windows 2003 servers.
> Thanks in advance!
> Mike,
>|||Define "entire SP3a hotfix". There is the service pack - SP3a - and then
there is the hotfix. Are you saying that you have applied SP3a but not the
hotfix? IOW, have you applied:
http://support.microsoft.com/kb/821277
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Mike Schurkin" <MikeSchurkin@.discussions.microsoft.com> wrote in message
news:5D90B16F-7EDB-401C-8022-106365D44347@.microsoft.com...
We have the entire SP3a hotfix installed, but I am unaware of a post SP3a
fix
- are you referring to SP4?
"Tom Moreau" wrote:

> Have you applied the post-SP3a hotfix?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> ..
> "Mike Schurkin" <MikeSchurkin@.discussions.microsoft.com> wrote in message
> news:C948BB2C-1A9D-4B73-9BDF-72B74A1FA9A2@.microsoft.com...
> We're having a bit of an issue with network traffic being generated from
> one
> of our MSSQL Servers.
> It seems that when we launch Enterprise Manager on a remote computer
> (usually at another office), the MSSQL servers start sending packets to
> the
> EM regardless of whether we are maintaining an active connection to the
> server or not. What is happening is that these packets are being lost and
> reported in our firewall as 'host unreachable'. These packets are also
> firing every second for each EM open across our network, so this is
> becoming
> a bit of a pain for our poor network guys. The other odd thing is that
> the
> firewall is only reporting one-way traffic, from the server to the client,
> but the client is not sending any traffic back down unless it is actively
> connected to the remote server.
> Any thoughts as to why this might be happening, or better yet, a way to
> cull
> this traffic?
> We're running MSSQL 2000 SP3a on Windows 2003 servers.
> Thanks in advance!
> Mike,
>

High Volume of Net Traffic coming from MSSQL

We're having a bit of an issue with network traffic being generated from one
of our MSSQL Servers.
It seems that when we launch Enterprise Manager on a remote computer
(usually at another office), the MSSQL servers start sending packets to the
EM regardless of whether we are maintaining an active connection to the
server or not. What is happening is that these packets are being lost and
reported in our firewall as 'host unreachable'. These packets are also
firing every second for each EM open across our network, so this is becoming
a bit of a pain for our poor network guys. The other odd thing is that the
firewall is only reporting one-way traffic, from the server to the client,
but the client is not sending any traffic back down unless it is actively
connected to the remote server.
Any thoughts as to why this might be happening, or better yet, a way to cull
this traffic?
We're running MSSQL 2000 SP3a on Windows 2003 servers.
Thanks in advance!
Mike,
Have you applied the post-SP3a hotfix?
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
..
"Mike Schurkin" <MikeSchurkin@.discussions.microsoft.com> wrote in message
news:C948BB2C-1A9D-4B73-9BDF-72B74A1FA9A2@.microsoft.com...
We're having a bit of an issue with network traffic being generated from one
of our MSSQL Servers.
It seems that when we launch Enterprise Manager on a remote computer
(usually at another office), the MSSQL servers start sending packets to the
EM regardless of whether we are maintaining an active connection to the
server or not. What is happening is that these packets are being lost and
reported in our firewall as 'host unreachable'. These packets are also
firing every second for each EM open across our network, so this is becoming
a bit of a pain for our poor network guys. The other odd thing is that the
firewall is only reporting one-way traffic, from the server to the client,
but the client is not sending any traffic back down unless it is actively
connected to the remote server.
Any thoughts as to why this might be happening, or better yet, a way to cull
this traffic?
We're running MSSQL 2000 SP3a on Windows 2003 servers.
Thanks in advance!
Mike,
|||We have the entire SP3a hotfix installed, but I am unaware of a post SP3a fix
- are you referring to SP4?
"Tom Moreau" wrote:

> Have you applied the post-SP3a hotfix?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> ..
> "Mike Schurkin" <MikeSchurkin@.discussions.microsoft.com> wrote in message
> news:C948BB2C-1A9D-4B73-9BDF-72B74A1FA9A2@.microsoft.com...
> We're having a bit of an issue with network traffic being generated from one
> of our MSSQL Servers.
> It seems that when we launch Enterprise Manager on a remote computer
> (usually at another office), the MSSQL servers start sending packets to the
> EM regardless of whether we are maintaining an active connection to the
> server or not. What is happening is that these packets are being lost and
> reported in our firewall as 'host unreachable'. These packets are also
> firing every second for each EM open across our network, so this is becoming
> a bit of a pain for our poor network guys. The other odd thing is that the
> firewall is only reporting one-way traffic, from the server to the client,
> but the client is not sending any traffic back down unless it is actively
> connected to the remote server.
> Any thoughts as to why this might be happening, or better yet, a way to cull
> this traffic?
> We're running MSSQL 2000 SP3a on Windows 2003 servers.
> Thanks in advance!
> Mike,
>
|||Define "entire SP3a hotfix". There is the service pack - SP3a - and then
there is the hotfix. Are you saying that you have applied SP3a but not the
hotfix? IOW, have you applied:
http://support.microsoft.com/kb/821277
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
..
"Mike Schurkin" <MikeSchurkin@.discussions.microsoft.com> wrote in message
news:5D90B16F-7EDB-401C-8022-106365D44347@.microsoft.com...
We have the entire SP3a hotfix installed, but I am unaware of a post SP3a
fix
- are you referring to SP4?
"Tom Moreau" wrote:

> Have you applied the post-SP3a hotfix?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> ..
> "Mike Schurkin" <MikeSchurkin@.discussions.microsoft.com> wrote in message
> news:C948BB2C-1A9D-4B73-9BDF-72B74A1FA9A2@.microsoft.com...
> We're having a bit of an issue with network traffic being generated from
> one
> of our MSSQL Servers.
> It seems that when we launch Enterprise Manager on a remote computer
> (usually at another office), the MSSQL servers start sending packets to
> the
> EM regardless of whether we are maintaining an active connection to the
> server or not. What is happening is that these packets are being lost and
> reported in our firewall as 'host unreachable'. These packets are also
> firing every second for each EM open across our network, so this is
> becoming
> a bit of a pain for our poor network guys. The other odd thing is that
> the
> firewall is only reporting one-way traffic, from the server to the client,
> but the client is not sending any traffic back down unless it is actively
> connected to the remote server.
> Any thoughts as to why this might be happening, or better yet, a way to
> cull
> this traffic?
> We're running MSSQL 2000 SP3a on Windows 2003 servers.
> Thanks in advance!
> Mike,
>

High volume batch insert

Hi,
I need a SQL program to insert a record into a parent table and then up
to 200 child records, using the primary key of the parent record. Whats
the best way to structure this procedure for performance and
reliability ? e.g
INSERT INTO tblExam ( dteExam,intModule,) Values () ...
SET intExamID= @.@.IDENTITY
' Psedo-code
For each Candidate in frmExamRequest
INSERT INTO tblCandidateExam ( intExamID, intCandidateID )
Next
The data is all coming from a form on an ASP page, I could break it
into two forms but for the users a single form with exam date, and list
of candidates they can check/uncheck is much easier.
If I have 2 stored procs to insert a exam instance & candidate
instances, the latter proc will be called 200 times over an ADODB
Connection. Is it possible to have a single stored proc to do the whole
task in a transaction with unknown number of candidates ?
thanks.When the user hits "Enter" you could either collect all the candidate IDs an
d
put them in a comma delimited string and then pass that string to the stored
proc that's doing the insert.
You could perform inserts into tblCandidateExam by looping through the
candidate IDs.
I think that's probably the easy way. Hope that's helpful
Cheers,
mmm
"cc900630@.ntu.ac.uk" wrote:

> Hi,
> I need a SQL program to insert a record into a parent table and then up
> to 200 child records, using the primary key of the parent record. Whats
> the best way to structure this procedure for performance and
> reliability ? e.g
>
> INSERT INTO tblExam ( dteExam,intModule,) Values () ...
> SET intExamID= @.@.IDENTITY
> ' Psedo-code
> For each Candidate in frmExamRequest
> INSERT INTO tblCandidateExam ( intExamID, intCandidateID )
> Next
> The data is all coming from a form on an ASP page, I could break it
> into two forms but for the users a single form with exam date, and list
> of candidates they can check/uncheck is much easier.
> If I have 2 stored procs to insert a exam instance & candidate
> instances, the latter proc will be called 200 times over an ADODB
> Connection. Is it possible to have a single stored proc to do the whole
> task in a transaction with unknown number of candidates ?
> thanks.
>|||See if one of these helps:
http://www.aspfaq.com/show.asp?id=2248 Arrays & Lists
http://www.sommarskog.se/dynamic_sql.html Dynamic SQL
http://www.users.drew.edu/skass/sql...bleProc.sql.txt List to
Table script
Andrew J. Kelly SQL MVP
<cc900630@.ntu.ac.uk> wrote in message
news:1117472922.543985.50420@.g14g2000cwa.googlegroups.com...
> Hi,
> I need a SQL program to insert a record into a parent table and then up
> to 200 child records, using the primary key of the parent record. Whats
> the best way to structure this procedure for performance and
> reliability ? e.g
>
> INSERT INTO tblExam ( dteExam,intModule,) Values () ...
> SET intExamID= @.@.IDENTITY
> ' Psedo-code
> For each Candidate in frmExamRequest
> INSERT INTO tblCandidateExam ( intExamID, intCandidateID )
> Next
> The data is all coming from a form on an ASP page, I could break it
> into two forms but for the users a single form with exam date, and list
> of candidates they can check/uncheck is much easier.
> If I have 2 stored procs to insert a exam instance & candidate
> instances, the latter proc will be called 200 times over an ADODB
> Connection. Is it possible to have a single stored proc to do the whole
> task in a transaction with unknown number of candidates ?
> thanks.
>