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
Showing posts with label causing. Show all posts
Showing posts with label causing. Show all posts
Sunday, March 11, 2012
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...
>
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.
McG
y
[url]http://mcg
y.blogspot.com[/url]I should add this is on SQL Server 2000!
McG
y
[url]http://mcg
y.blogspot.com[/url]
"McG
y" <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.
> --
> McG
y
> [url]http://mcg
y.blogspot.com[/url]
>
>
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.
McG

[url]http://mcg

McG

[url]http://mcg

"McG

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.
> --
> McG

> [url]http://mcg

>
>
Subscribe to:
Posts (Atom)