Showing posts with label automatic. Show all posts
Showing posts with label automatic. Show all posts

Friday, March 23, 2012

Problem with identity range

Hi,
I have a table that has different owner than DBO. When I include this table
in publication, SQL Server does not allow to enable automatic identity range
for this article.
Any help would be greatly appreciated.
Leila
If changing the owner of the object is an acceptable solutions, refer to
Microsoft Knowledge Base Article - 275312.
"Leila" wrote:

> Hi,
> I have a table that has different owner than DBO. When I include this table
> in publication, SQL Server does not allow to enable automatic identity range
> for this article.
> Any help would be greatly appreciated.
> Leila
>
>
|||Hi,
Unfortunately I must keep the owners intact. Isn't there any solution to
this problem?
Thanks
"Sasan Saidi" <SasanSaidi@.discussions.microsoft.com> wrote in message
news:F88A75E5-7A4B-42AB-8EFA-F7A48E3290D5@.microsoft.com...[vbcol=seagreen]
> If changing the owner of the object is an acceptable solutions, refer to
> Microsoft Knowledge Base Article - 275312.
>
> "Leila" wrote:
table[vbcol=seagreen]
range[vbcol=seagreen]
|||What exactly do you mean by saying that "SQL Server does not allow to enable
automatic identity range" ?
Do you get an error or it is just somehow not possible to select that option
of automatic identity range handling ?
If you are getting an error then I know what you are talking about and I
know what causes those problems - there are some known bugs in merge
replication, which are very significant in case of objects owned not by dbo.
I have developed fixes for some of those bugs and posted them in this
newsgroup (you can look for my posts). If you will not find them, I can
repost them again.
Regards,
Kestutis Adomavicius
Consultant
UAB "Baltic Software Solutions"
"Leila" <leilas@.hotpop.com> wrote in message
news:%234$ay$hpEHA.868@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I have a table that has different owner than DBO. When I include this
table
> in publication, SQL Server does not allow to enable automatic identity
range
> for this article.
> Any help would be greatly appreciated.
> Leila
>
sql

Problem with identity range

Hi,
I have a table that has different owner than DBO. When I include this table
in publication, SQL Server does not allow to enable automatic identity range
for this article.
Any help would be greatly appreciated.
Leila
If changing the owner of the object is an acceptable solutions, refer to
Microsoft Knowledge Base Article - 275312.
"Leila" wrote:

> Hi,
> I have a table that has different owner than DBO. When I include this table
> in publication, SQL Server does not allow to enable automatic identity range
> for this article.
> Any help would be greatly appreciated.
> Leila
>
>
|||Hi,
Unfortunately I must keep the owners intact. Isn't there any solution to
this problem?
Thanks
"Sasan Saidi" <SasanSaidi@.discussions.microsoft.com> wrote in message
news:F88A75E5-7A4B-42AB-8EFA-F7A48E3290D5@.microsoft.com...[vbcol=seagreen]
> If changing the owner of the object is an acceptable solutions, refer to
> Microsoft Knowledge Base Article - 275312.
>
> "Leila" wrote:
table[vbcol=seagreen]
range[vbcol=seagreen]

Problem with identity range

Hi,
I have a table that has different owner than DBO. When I include this table
in publication, SQL Server does not allow to enable automatic identity range
for this article.
Any help would be greatly appreciated.
LeilaIf changing the owner of the object is an acceptable solutions, refer to
Microsoft Knowledge Base Article - 275312.
"Leila" wrote:
> Hi,
> I have a table that has different owner than DBO. When I include this table
> in publication, SQL Server does not allow to enable automatic identity range
> for this article.
> Any help would be greatly appreciated.
> Leila
>
>|||Hi,
Unfortunately I must keep the owners intact. Isn't there any solution to
this problem?
Thanks
"Sasan Saidi" <SasanSaidi@.discussions.microsoft.com> wrote in message
news:F88A75E5-7A4B-42AB-8EFA-F7A48E3290D5@.microsoft.com...
> If changing the owner of the object is an acceptable solutions, refer to
> Microsoft Knowledge Base Article - 275312.
>
> "Leila" wrote:
> > Hi,
> > I have a table that has different owner than DBO. When I include this
table
> > in publication, SQL Server does not allow to enable automatic identity
range
> > for this article.
> > Any help would be greatly appreciated.
> > Leila
> >
> >
> >