Click here to Skip to main content
15,845,912 members
Home / Discussions / Database
   

Database

 
GeneralRe: NAKRA Pin
Pete O'Hanlon28-Jun-07 23:20
subeditorPete O'Hanlon28-Jun-07 23:20 
GeneralRe: NAKRA Pin
kubben29-Jun-07 2:53
kubben29-Jun-07 2:53 
NewsNAKRA Pin
NAKRAINC28-Jun-07 23:09
NAKRAINC28-Jun-07 23:09 
NewsNAKRA Pin
NAKRAINC28-Jun-07 23:08
NAKRAINC28-Jun-07 23:08 
NewsNAKRA Pin
NAKRAINC28-Jun-07 23:06
NAKRAINC28-Jun-07 23:06 
Questionhow to encrypt whole Database ? Pin
hdv21228-Jun-07 22:51
hdv21228-Jun-07 22:51 
AnswerRe: how to encrypt whole Database ? Pin
originSH29-Jun-07 1:06
originSH29-Jun-07 1:06 
QuestionMerge Replication rights Pin
Sgg24528-Jun-07 21:15
Sgg24528-Jun-07 21:15 
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???Confused | :confused: Confused | :confused:

Regards
SG (sgg245@yahoo.co.in)
QuestionCritical probs to display records..., Pin
Member 387988128-Jun-07 19:02
Member 387988128-Jun-07 19:02 
AnswerRe: Critical probs to display records..., Pin
Devkranth Kishore Vanja28-Jun-07 21:24
Devkranth Kishore Vanja28-Jun-07 21:24 
GeneralRe: Critical probs to display records..., Pin
Member 387988128-Jun-07 21:57
Member 387988128-Jun-07 21:57 
AnswerRe: Critical probs to display records..., Pin
Navneet Hegde29-Jun-07 4:34
Navneet Hegde29-Jun-07 4:34 
QuestionParamaterized Queries vs. Stored Procedures Pin
martin_hughes28-Jun-07 9:17
martin_hughes28-Jun-07 9:17 
AnswerRe: Paramaterized Queries vs. Stored Procedures Pin
kubben28-Jun-07 10:09
kubben28-Jun-07 10:09 
AnswerRe: Paramaterized Queries vs. Stored Procedures [modified] Pin
Mike Dimmick28-Jun-07 10:22
Mike Dimmick28-Jun-07 10:22 
GeneralRe: Paramaterized Queries vs. Stored Procedures Pin
martin_hughes29-Jun-07 2:34
martin_hughes29-Jun-07 2:34 
AnswerRe: Paramaterized Queries vs. Stored Procedures Pin
originSH29-Jun-07 1:11
originSH29-Jun-07 1:11 
GeneralRe: Paramaterized Queries vs. Stored Procedures Pin
martin_hughes29-Jun-07 2:32
martin_hughes29-Jun-07 2:32 
QuestionView more than one page with CrystalReportViewer vb.net Pin
kindman_nb28-Jun-07 6:09
kindman_nb28-Jun-07 6:09 
QuestionAlternative of CONVERT function in MS Access Pin
FishiFishi28-Jun-07 4:12
FishiFishi28-Jun-07 4:12 
AnswerRe: Alternative of CONVERT function in MS Access Pin
leckey28-Jun-07 5:20
leckey28-Jun-07 5:20 
Questiondatetime code Pin
niki_nilu28-Jun-07 2:56
niki_nilu28-Jun-07 2:56 
AnswerRe: datetime code Pin
Sathesh Sakthivel28-Jun-07 3:22
Sathesh Sakthivel28-Jun-07 3:22 
Questiondatetime problem Pin
niki_nilu28-Jun-07 1:54
niki_nilu28-Jun-07 1:54 
AnswerRe: datetime problem Pin
Krish - KP28-Jun-07 2:30
Krish - KP28-Jun-07 2:30 

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.