Click here to Skip to main content
15,901,426 members
Home / Discussions / Database
   

Database

 
AnswerRe: sql server2000 Pin
andyharman1-Jul-07 22:37
professionalandyharman1-Jul-07 22:37 
AnswerRe: sql server2000 Pin
N a v a n e e t h1-Jul-07 22:42
N a v a n e e t h1-Jul-07 22:42 
AnswerRe: sql server2000 Pin
Sgg2451-Jul-07 23:16
Sgg2451-Jul-07 23:16 
GeneralRe: sql server2000 Pin
ahmedalisha1-Jul-07 23:25
ahmedalisha1-Jul-07 23:25 
GeneralRe: sql server2000 Pin
Sgg2452-Jul-07 0:06
Sgg2452-Jul-07 0:06 
Questionchange case of a text field Pin
rkherath1-Jul-07 20:40
rkherath1-Jul-07 20:40 
AnswerRe: change case of a text field Pin
Sgg2451-Jul-07 21:11
Sgg2451-Jul-07 21:11 
QuestionPlz Help Me!! Urgently... Anybody for Merge Replication... Pin
Sgg2451-Jul-07 18:38
Sgg2451-Jul-07 18:38 
I have a central db as publisher on SQL Server 2005, which has SUPERVISOR user having sysadmin rights.

And created another client db with subscriber user (not having sysadmin rights on the publisher SQL Server 2005), say U1, on SQL Express 2005 instance. As subscriber is the owner of db of subscriber db, so has sysadmin rights on the SQL Express 2005.

Done all the pre-requisite for merge replication.

When I try to replicate between the publisher db & subscriber db with subscriber user, it gives error
"The Publisher failed to allocate a new set of identity ranges for the subscription. This can occur when a publisher or a republishing Subscriber has run out of identity ranges to allocate to its own subscriber or when an identity column data type does not support an additional identity range allocation. If a republishing subscriber has run out of identity ranges, synchronize the republishing subscriber to obtain more identity ranges before restarting the synchronization. if a publisher runs out of identity....."

Although, if the subscriber user is created as sysadmin on the publisher i.e. SQL Server 2005 then the synchronization works perfectly and synchronizes the data.
Confused | :confused: Confused | :confused:
I would like to know why SYSADMIN right is needed to be given to the subscriber user at the publisher i.e. SQL Server 2005 instance???
Regards


Regards
SG (sgg245@yahoo.co.in)

AnswerRe: Plz Help Me!! Urgently... Anybody for Merge Replication... Pin
Paul Conrad13-Jul-07 11:56
professionalPaul Conrad13-Jul-07 11:56 
QuestionHow to get list of tables in SQL Server Pin
Prashant C1-Jul-07 17:52
Prashant C1-Jul-07 17:52 
AnswerRe: How to get list of tables in SQL Server Pin
PrakashBhaskar1-Jul-07 18:21
PrakashBhaskar1-Jul-07 18:21 
AnswerRe: How to get list of tables in SQL Server Pin
Krish - KP1-Jul-07 18:27
Krish - KP1-Jul-07 18:27 
GeneralRe: How to get list of tables in SQL Server Pin
sajjadtx1-Jul-07 18:33
sajjadtx1-Jul-07 18:33 
GeneralRe: How to get list of tables in SQL Server Pin
Krish - KP1-Jul-07 23:26
Krish - KP1-Jul-07 23:26 
AnswerRe: How to get list of tables in SQL Server Pin
Aaron VanWieren2-Jul-07 3:32
Aaron VanWieren2-Jul-07 3:32 
QuestionHow to schedule the job using stored procedure Pin
madhu071-Jul-07 7:15
madhu071-Jul-07 7:15 
QuestionHow to schedule the job using stored procedure Pin
madhu071-Jul-07 7:13
madhu071-Jul-07 7:13 
Questionschedual Jobs Pin
merwa1-Jul-07 3:42
merwa1-Jul-07 3:42 
Questioncheck constrain on colum Pin
merwa30-Jun-07 22:52
merwa30-Jun-07 22:52 
AnswerRe: check constrain on colum Pin
Gamzun30-Jun-07 23:17
Gamzun30-Jun-07 23:17 
GeneralRe: check constrain on colum Pin
merwa1-Jul-07 3:39
merwa1-Jul-07 3:39 
GeneralRe: check constrain on colum Pin
Gamzun1-Jul-07 3:44
Gamzun1-Jul-07 3:44 
QuestionHow to apply Unique Constraints ? Pin
Gamzun30-Jun-07 21:29
Gamzun30-Jun-07 21:29 
QuestionSQL SMO Fast way to get primary key column from a table Pin
Polymorpher30-Jun-07 15:19
Polymorpher30-Jun-07 15:19 
AnswerRe: SQL SMO Fast way to get primary key column from a table Pin
Sathesh Sakthivel30-Jun-07 15:21
Sathesh Sakthivel30-Jun-07 15:21 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.