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

Problem with DTS reading from spreadsheet

Has anyone encountered an issue with blank cells when DTS tries to read
a range from a spreadsheet using a SELECT * FROM [Sheetname$] query? I have
a spreadsheet where I read a range, and some of the cells show up as blank
even though there are values in them. If I alter the cell and resave the
sheet, it works fine. I suppose this could be worksheet corruption, but I
wanted to see if there were any other ideas about what to do. Thanks.

*************************************************
Andy S.
andymcdba1@.noreply.yahoo.com
Please remove "noreply" before replying.
*************************************************
Are you seeing this?
Excel Inserts Null Values
(http://www.sqldts.com/default.aspx?254)
Allan
"Andy S." <andymcdba1@.noreply.yahoo.com> wrote in message
news:#5c#mlL5FHA.472@.TK2MSFTNGP15.phx.gbl:

> Has anyone encountered an issue with blank cells when DTS tries to read
> a range from a spreadsheet using a SELECT * FROM [Sheetname$] query? I
> have
> a spreadsheet where I read a range, and some of the cells show up as
> blank
> even though there are values in them. If I alter the cell and resave
> the
> sheet, it works fine. I suppose this could be worksheet corruption, but
> I
> wanted to see if there were any other ideas about what to do. Thanks.
>
> --
> *************************************************
> Andy S.
> andymcdba1@.noreply.yahoo.com
> Please remove "noreply" before replying.
> *************************************************
|||Yes, thank you! It is amazing. This was driving me nuts. Excel will read
in the character data, the character mixed with number data, and ignore the
number data.
Your website is one of the best SQL sites out there. The looping example
alone was a lifesaver.
"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
news:uEUNVTM5FHA.3496@.TK2MSFTNGP10.phx.gbl...
> Are you seeing this?
> Excel Inserts Null Values
> (http://www.sqldts.com/default.aspx?254)
>
> Allan
> "Andy S." <andymcdba1@.noreply.yahoo.com> wrote in message
> news:#5c#mlL5FHA.472@.TK2MSFTNGP15.phx.gbl:
>

Problem with DTS reading from spreadsheet

Has anyone encountered an issue with blank cells when DTS tries to read
a range from a spreadsheet using a SELECT * FROM [Sheetname$] query? I have
a spreadsheet where I read a range, and some of the cells show up as blank
even though there are values in them. If I alter the cell and resave the
sheet, it works fine. I suppose this could be worksheet corruption, but I
wanted to see if there were any other ideas about what to do. Thanks.

*************************************************
Andy S.
andymcdba1@.noreply.yahoo.com
Please remove "noreply" before replying.
*************************************************
Are you seeing this?
Excel Inserts Null Values
(http://www.sqldts.com/default.aspx?254)
Allan
"Andy S." <andymcdba1@.noreply.yahoo.com> wrote in message
news:#5c#mlL5FHA.472@.TK2MSFTNGP15.phx.gbl:

> Has anyone encountered an issue with blank cells when DTS tries to read
> a range from a spreadsheet using a SELECT * FROM [Sheetname$] query? I
> have
> a spreadsheet where I read a range, and some of the cells show up as
> blank
> even though there are values in them. If I alter the cell and resave
> the
> sheet, it works fine. I suppose this could be worksheet corruption, but
> I
> wanted to see if there were any other ideas about what to do. Thanks.
>
> --
> *************************************************
> Andy S.
> andymcdba1@.noreply.yahoo.com
> Please remove "noreply" before replying.
> *************************************************
|||Yes, thank you! It is amazing. This was driving me nuts. Excel will read
in the character data, the character mixed with number data, and ignore the
number data.
Your website is one of the best SQL sites out there. The looping example
alone was a lifesaver.
"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
news:uEUNVTM5FHA.3496@.TK2MSFTNGP10.phx.gbl...
> Are you seeing this?
> Excel Inserts Null Values
> (http://www.sqldts.com/default.aspx?254)
>
> Allan
> "Andy S." <andymcdba1@.noreply.yahoo.com> wrote in message
> news:#5c#mlL5FHA.472@.TK2MSFTNGP15.phx.gbl:
>

Problem with DTS reading from spreadsheet

Has anyone encountered an issue with blank cells when DTS tries to read
a range from a spreadsheet using a SELECT * FROM [Sheetname$] query? I
have
a spreadsheet where I read a range, and some of the cells show up as blank
even though there are values in them. If I alter the cell and resave the
sheet, it works fine. I suppose this could be worksheet corruption, but I
wanted to see if there were any other ideas about what to do. Thanks.
****************************************
*********
Andy S.
andymcdba1@.noreply.yahoo.com
Please remove "noreply" before replying.
****************************************
*********Are you seeing this?
Excel Inserts Null Values
(http://www.sqldts.com/default.aspx?254)
Allan
"Andy S." <andymcdba1@.noreply.yahoo.com> wrote in message
news:#5c#mlL5FHA.472@.TK2MSFTNGP15.phx.gbl:

> Has anyone encountered an issue with blank cells when DTS tries to read
> a range from a spreadsheet using a SELECT * FROM [Sheetname$] query?
I
> have
> a spreadsheet where I read a range, and some of the cells show up as
> blank
> even though there are values in them. If I alter the cell and resave
> the
> sheet, it works fine. I suppose this could be worksheet corruption, but
> I
> wanted to see if there were any other ideas about what to do. Thanks.
>
> --
> ****************************************
*********
> Andy S.
> andymcdba1@.noreply.yahoo.com
> Please remove "noreply" before replying.
> ****************************************
*********|||Yes, thank you! It is amazing. This was driving me nuts. Excel will read
in the character data, the character mixed with number data, and ignore the
number data.
Your website is one of the best SQL sites out there. The looping example
alone was a lifesaver.
"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
news:uEUNVTM5FHA.3496@.TK2MSFTNGP10.phx.gbl...
> Are you seeing this?
> Excel Inserts Null Values
> (http://www.sqldts.com/default.aspx?254)
>
> Allan
> "Andy S." <andymcdba1@.noreply.yahoo.com> wrote in message
> news:#5c#mlL5FHA.472@.TK2MSFTNGP15.phx.gbl:
>
>

Problem with DTS reading from spreadsheet

Has anyone encountered an issue with blank cells when DTS tries to read
a range from a spreadsheet using a SELECT * FROM [Sheetname$] query? I have
a spreadsheet where I read a range, and some of the cells show up as blank
even though there are values in them. If I alter the cell and resave the
sheet, it works fine. I suppose this could be worksheet corruption, but I
wanted to see if there were any other ideas about what to do. Thanks.
--
*************************************************
Andy S.
andymcdba1@.noreply.yahoo.com
Please remove "noreply" before replying.
*************************************************Are you seeing this?
Excel Inserts Null Values
(http://www.sqldts.com/default.aspx?254)
Allan
"Andy S." <andymcdba1@.noreply.yahoo.com> wrote in message
news:#5c#mlL5FHA.472@.TK2MSFTNGP15.phx.gbl:
> Has anyone encountered an issue with blank cells when DTS tries to read
> a range from a spreadsheet using a SELECT * FROM [Sheetname$] query? I
> have
> a spreadsheet where I read a range, and some of the cells show up as
> blank
> even though there are values in them. If I alter the cell and resave
> the
> sheet, it works fine. I suppose this could be worksheet corruption, but
> I
> wanted to see if there were any other ideas about what to do. Thanks.
>
> --
> *************************************************
> Andy S.
> andymcdba1@.noreply.yahoo.com
> Please remove "noreply" before replying.
> *************************************************|||no IT JUST DOESNT FUCKING WORK.
THATS ONE OF THE REASONS I FUCKING HATE EXCEL SO MUCH
SHIT DOESNT WORK LIKE IT SAYS IT SHOULD
just the basics; microsoft
start fucking fixing bugs you piece of shit company
oh.. is $70bn of OUR hard-earned money not enough to fix a half dozen
bugs?
MS is too fat and lazy to succeed; plz boycott MS everywhere
they just dont fucking get it anymore|||Yes, thank you! It is amazing. This was driving me nuts. Excel will read
in the character data, the character mixed with number data, and ignore the
number data.
Your website is one of the best SQL sites out there. The looping example
alone was a lifesaver.
"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
news:uEUNVTM5FHA.3496@.TK2MSFTNGP10.phx.gbl...
> Are you seeing this?
> Excel Inserts Null Values
> (http://www.sqldts.com/default.aspx?254)
>
> Allan
> "Andy S." <andymcdba1@.noreply.yahoo.com> wrote in message
> news:#5c#mlL5FHA.472@.TK2MSFTNGP15.phx.gbl:
>> Has anyone encountered an issue with blank cells when DTS tries to read
>> a range from a spreadsheet using a SELECT * FROM [Sheetname$] query? I
>> have
>> a spreadsheet where I read a range, and some of the cells show up as
>> blank
>> even though there are values in them. If I alter the cell and resave
>> the
>> sheet, it works fine. I suppose this could be worksheet corruption, but
>> I
>> wanted to see if there were any other ideas about what to do. Thanks.
>>
>> --
>> *************************************************
>> Andy S.
>> andymcdba1@.noreply.yahoo.com
>> Please remove "noreply" before replying.
>> *************************************************
>