BIGINT Data type and replication

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

BIGINT Data type and replication

Author

Topic

sql_er
Constraint Violating Yak Guru

267 Posts

Posted - 2008-04-14 : 10:36:42

Hello,

I am using MS SQL Server 2000.

I have created a table with the following structure:

CREATE TABLE [dbo].[x] (
[a] [bigint] NOT NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[x] WITH NOCHECK ADD
CONSTRAINT [PK_x] PRIMARY KEY CLUSTERED
(
[a]
) ON [PRIMARY]
GO

When I try to add it as an article in the transactional replication, it does not work. If I change the datatype of 'a' to INT, it works.

Is a datatype BIGINT not allowed as a type of the column used by replication?

Thanks a lot!

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-04-14 : 11:19:58

What Service Pack are you using?

sql_er
Constraint Violating Yak Guru

267 Posts

Posted - 2008-04-14 : 11:38:26

This is what I get when I run

SELECT @@version

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)

I believe I did not apply the latest service pack. Could that be it?

sql_er
Constraint Violating Yak Guru

267 Posts

Posted - 2008-04-14 : 11:39:48

The full result is:

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-14 : 12:05:17

Then it is 32-bit SQL server

sql_er
Constraint Violating Yak Guru

267 Posts

Posted - 2008-04-14 : 12:14:53

Could you please explain further how this would result in the problem I am having?

Thank you!

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-14 : 22:38:07

What's sql version of subscriber?

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-04-15 : 02:29:19

quote:
Originally posted by sodeep

Then it is 32-bit SQL server

I don't see how that is relevant in the slightest?!?

As rmiao said, what is the version on the subscriber?

sql_er
Constraint Violating Yak Guru

267 Posts

Posted - 2008-04-15 : 09:55:47

The version is exactly the same as on the publisher:

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

Thank you!

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-15 : 22:25:06

Ensure target db has compatibility 80.

sql_er
Constraint Violating Yak Guru

267 Posts

Posted - 2008-04-16 : 11:58:25

Will do - Thank you!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources