Showing posts with label causing. Show all posts
Showing posts with label causing. Show all posts

Sunday, March 11, 2012

Double inserts during snapshot posting of transactional replication

Hi,
So, I have setup transactional replication, uses the initial snapshot. When
the snapshot is being posted, it runs the same command, and causing it to
fail on the primary key constraint.
Has anyone seen this before?
Gary,
please can you post up the error message.
Also, are you doing a nosync subscription or is it a full initialization?
Regards,
Paul Ibison

Wednesday, March 7, 2012

Don't use virtual directory name as part of namespace

Hi. Is it possible to configure SQLXML so that the virtual directory name is
not integrated in to the schema namespace? This is causing us problems at
deployment time. We want to deploy our SQLXML stored procedures to different
virtual directories on the same server to support separate testing
environments. But changing the virtual directory name changes the schema
namespace which means that the clients that use the stored procedures break.
McGeeky
http://mcgeeky.blogspot.com
I should add this is on SQL Server 2000!
McGeeky
http://mcgeeky.blogspot.com
"McGeeky" <anon@.anon.com> wrote in message
news:ed%23GiEq7GHA.3812@.TK2MSFTNGP02.phx.gbl...
> Hi. Is it possible to configure SQLXML so that the virtual directory name
> is not integrated in to the schema namespace? This is causing us problems
> at deployment time. We want to deploy our SQLXML stored procedures to
> different virtual directories on the same server to support separate
> testing environments. But changing the virtual directory name changes the
> schema namespace which means that the clients that use the stored
> procedures break.
> --
> McGeeky
> http://mcgeeky.blogspot.com
>
>
|||What schema namespace? Database schema, XML Schema? Some other schema?
Thanks
Michael
"McGeeky" <anon@.anon.com> wrote in message
news:upraaQq7GHA.2384@.TK2MSFTNGP04.phx.gbl...
>I should add this is on SQL Server 2000!
> --
> McGeeky
> http://mcgeeky.blogspot.com
>
> "McGeeky" <anon@.anon.com> wrote in message
> news:ed%23GiEq7GHA.3812@.TK2MSFTNGP02.phx.gbl...
>

Don't use virtual directory name as part of namespace

Hi. Is it possible to configure SQLXML so that the virtual directory name is
not integrated in to the schema namespace? This is causing us problems at
deployment time. We want to deploy our SQLXML stored procedures to different
virtual directories on the same server to support separate testing
environments. But changing the virtual directory name changes the schema
namespace which means that the clients that use the stored procedures break.
McGy
[url]http://mcgy.blogspot.com[/url]I should add this is on SQL Server 2000!
McGy
[url]http://mcgy.blogspot.com[/url]
"McGy" <anon@.anon.com> wrote in message
news:ed%23GiEq7GHA.3812@.TK2MSFTNGP02.phx.gbl...
> Hi. Is it possible to configure SQLXML so that the virtual directory name
> is not integrated in to the schema namespace? This is causing us problems
> at deployment time. We want to deploy our SQLXML stored procedures to
> different virtual directories on the same server to support separate
> testing environments. But changing the virtual directory name changes the
> schema namespace which means that the clients that use the stored
> procedures break.
> --
> McGy
> [url]http://mcgy.blogspot.com[/url]
>
>