I've given the user full access(db_datareader,db_datawriter) to msdb and public role in the master DB. Jobs doesn't display in the EM. What do i do...
Thanx, is there any storedprocedure or something which i can assign that user to make the linked-servers acccessible. Another question 4 ur kind...
I can see the servers but when i access; i get error: the server isn't accessible. However if i use sysadmin user; i am thru.
Hi, folks. I have an SQL user that has access rights to a single user database with in the SQL-Server. I want this user to be able to access...
Hi Satya, thanx for helpin. The option "Enforce constraint for Inserts and Updates" and other options are disabled in the design view. Also there...
Hi Satya! What's the solution to this. Running this check for each table after each snapshot? And what about the 2nd question plz? Thanx.
Hi folks! I've a merge replication setup b/w two servers. Published tables have columns (INT IDENTITY SEED 1 INCREMENT[NOT FOR REPLICATION])....
Hi folks, It's said of locking, that "Applications should be coded to acquire shared locks rather than exclusive locks when waiting for user input"....
A small quesion: I've a VB application that calls a Connection file to connect to a server; placed on a share with the following entries.<br />...
When i execute WMI setup a dialog-box appears saying please wait while windows configure WMI SQL Server provider.Then it disappears. Now what to do...
I've tried lookin at it but couldn't..., too many gray areas. If anybody could guide more precisely plz!!! Thanx.
Hi Folks, I need to query MSDB to check the status of Replication(Merge-Agent) to extract the last replication status(succeeded or failed, when did...
Yes, Satya, the subscriber disconnects recently and the dynamic snapshot i guess if the subscriber disconnects; merge agent says it's succeeded and...
Hi Satya, some how it worked, i.e. the Merge-Agent started and applied the tables scripts very quickly, i could see the PUBLISHER-INSERTS with 100...
Thank You! So kind u'v been so far. I've enabled dynamic filters, created a dynamic-snapshot-job and run it. It's mentioned in the documentation to...
Satya, thanx again. Kindly guide about applying manual snapshot. This is what i am really lookin for. How do i do that? Thanx for ur patience and...
Thanx Satya. Sp_helpserver doesn't return Null for either of the servers. However the Subscriber disconnects some times from VPN, for it's over the...
Hi Folks, I've run into serious problem. I've 4 GB of Publisher that i need to replicate to a subscriber over the internet using VPN. The...
Hi, i have published tables with ID-Seeds columns as PK(Not For Replication). Conflicts occur often when the subscriber has the same new ID that...
MSDB contains the agents and repl jobs. You need to restore MSDB too on ur test server.
Separate names with a comma.
