|
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.
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)
|
|
|
|
|
Have you looked through the permissions and grants?
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
Hi Everyone,
How to get the list of table name and tables related to them, in SQL Server Database???
Thanks in advance...........
-Prashant
![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
|
|
|
|
|
select * from sysobjects
select * from syscolumns
Thanks
Warm Regards
Prakash-B
|
|
|
|
|
SYSOBJECTS table contains all objects created in a databse
SELECT * FROM sysobjects WHERE xtype = 'U' AND uid = user_id()
this returns all tables created in the current database by the current user.
Regards
KP
|
|
|
|
|
good answer. more details
http://msdn2.microsoft.com/en-us/library/ms177596.aspx
|
|
|
|
|
Thank you.
The URL is very usefull for me.
Regards
KP
|
|
|
|
|
You should also look at getschema("Tables"). This is an Ado method introduced in 2.0 to eliminate the need to query the system tables.
_____________________________________________________________________
Our developers never release
code. Rather, it tends to escape, pillaging the countryside all around.
The Enlightenment Project (paraphrased comment)
Visit Me at GISDevCafe
|
|
|
|
|
I have a ASP.net interfacee to get the user define date time schedule and I store that in the database. I want to use that data to schedule a job to run the store procedure and get the data and send it through a email
|
|
|
|
|
I have a ASP.net interfacee to get the user define date time schedule and I store that in the database. I want to use that data to schedule a store procedure to be run.
or
For job scheduling in SQL SERVER 2005 we can use job scheduling wizard, but i want to know some other way , like can i schedule jobs in SQL through SQL Storeprocedure what i want to do is i want to provide a interface to a user in ASP or some other tool and i will pass all the require parameters to SQL and schedule the job through Store procedure instead of using the wizard, is there a way like this, please suggest
|
|
|
|
|
I want to make a job in SQL calculate the unfixed occasion every year like easter it is in the first monday on May, I want to get the date day/month/year.
merwa
|
|
|
|
|
I want to make a check constrain in 7 Colum together each Colum take a bit I want to make only one Colum true and the other is false in each row. How can I do that.
merwa
|
|
|
|
|
i assuming that you want your result should be somehting like this
column1 column2 column3 column4 column5 column6 column7
false false false true false false false
only one column can have true value, right?
|
|
|
|
|
|
so whats your question? you want to give some constraint that only one true value can be entered database level or form level?
clarify your scenario please
|
|
|
|
|
how one can apply unique constraint using MS SQL Server Management Studio.
I can see in table property "Replicated" but i can't change its values as its disabled. Or I've to user general query like the one below;
CREATE TABLE Customer(SID integer UNIQUE);
|
|
|
|
|
Does anyone know a fast way of getting the primary key column of a table using SQL SMO? My aproach so far has been to run through all of the columns checking to see if they are primary key columns...
Apparently it's not OK to start a bonfire of Microsoft products in the aisles of CompUSA even though the Linuxrulz web site says so
|
|
|
|
|
|
tbl.Indexes(0).Name seems to give me the constraint name...but i need to column name, sorry if i missed it, but i didnt see it in your code.
Thanks for the quick response 
Apparently it's not OK to start a bonfire of Microsoft products in the aisles of CompUSA even though the Linuxrulz web site says so
|
|
|
|
|
As far as I can remember you'd have to loop and check.
Is the problem that doign the loop and check is very slow?
If so check out the 'SetDefaultInitFields' method.
|
|
|
|
|
The fastest way i have found so far is by extending your idea slightly:
<br />
If tbl.Indexes.Count > 0 Then<br />
If tbl.Indexes(0).IndexedColumns.Count > 0 Then<br />
Return tbl.Indexes(0).IndexedColumns(0).Name<br />
End If<br />
End If<br />
Apparently it's not OK to start a bonfire of Microsoft products in the aisles of CompUSA even though the Linuxrulz web site says so
|
|
|
|
|
Hi,
its possible to generate some event from database? Let say that i have in some table cell with date and time with value 23-06-2007 13:14:05 and when time will be equal to this value database will do some thing like: remove this record and increment some value in other table...
Its possible to do?
Any idea how resolve it?
Greetings
|
|
|
|
|
I think your looking to implement Trigers[^]
|
|
|
|
|
Hi,
no... im not looking for trigers... trigers are launched when someone do insert update etc... not when some valu eis equal to other value...
Greetings
|
|
|
|
|
How does one value becomes equal to another without some update operation?Anyways you seem to know what you want...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
