Identity Range Issue

Hi - I have a peculiar problem. I have been able to successfully add
merge articles to a publication (both in script and through EM) with identiy
range in a instance of sql server. Whenever I try to do the same thing in a
default installation of sql server, I get a syntax error.
I have been able to find out that the error occurs because the identity
column has spaces in its name (e.g. [ID for Category] - the error says there
is a syntax error near the key word 'for', but it can be any other word
after the space). If I don't use identity range, I can add the article fine.
So here is my situation:
1. I need to keep the column names the same for legacy reasons.
2. I need to use identity range.
3. I need to be able to do this both in an instance and default
installation of sql server.
What puzzles me the most is why this is not an issue in a instance of
sql server.
I hadn't found out about this problem until recently because I had
always worked with an instance in this application.
So I have two questions:
Why does this only happen in a default installation?
What can I do to make it work in a default installation?
Any help will be greatly appreciated,
Maer
I'll try to reproduce it tomorrow, but my first thought is that the service
pack level might be different between the default and named instances - can
you check that for us.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hi Paul,
The service pack level was indeed different. As a matter of fact, I had
forgotten to apply any service pack to the default installation. After
applying the latest pack, it worked.
Thanks,
Maer
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:urYbMjcdFHA.3492@.TK2MSFTNGP14.phx.gbl...
> I'll try to reproduce it tomorrow, but my first thought is that the
> service pack level might be different between the default and named
> instances - can you check that for us.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>