sql-serer-errorTag Archive

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: Merge agent profile optimized for the high volume server-to-server synchronization scenario.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: Server user ‘%s’ is not a valid user in database ‘%s’. Add the user account or ‘guest’ user account into the database first.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: The security mode specified requires the server ‘%s’ to be registered as a linked server. Use sp_addlinkedserver to add the server.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: The value specified for the @login parameter is not valid. User ‘%s’ is not a user in database ‘%s’. Add the user account to the database before attempting to execute the stored procedures sp_grant_publication_access or sp_revoke_publication_access.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: Replication database option ‘sync with backup’ cannot be set on the publishing database because the database is in Simple Recovery mode.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: You cannot validate article ‘%s’ unless you have ‘SELECT ALL’ permission on table ‘%s’.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: Cannot create the merge replication publication access list (PAL) database role for publication ‘%s’. This role is used by replication to control access to the publication. Verify that you have sufficient permissions to create roles in the publication database.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: Filter ‘%s’ already exists in publication ‘%s’. Specify a unique name for the @filtername parameter of sp_addmergefilter.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: Cannot create partitioned snapshot job. A job already exists for publication ‘%ls’ that uses the values you specified for the @suser_sname and/or @host_name parameters of sp_adddynamicsnapshot_job. If the job that already exists is not working correctly, use sp_dropdynamicsnapshot_job to drop it and create a new one using sp_adddynamicsnapshot_job.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: Cannot find a location in which to generate a partitioned snapshot. Verify that the there is a valid snapshot folder specified for the publication. This can be the default folder associated with the Distributor or an alternate folder associated with the publication.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: Cannot start the partitioned snapshot job. Verify that SQL Server Agent is running on the Distributor.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: The article order specified in the @processing_order parameter of sp_addmergearticle does not reflect the primary key-foreign key relationships between published tables. Article ‘%s’ references one or more articles that will be created after it is created. Change the processing_order property using sp_changemergearticle.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: A push subscription to ‘%ls’ was found. Cannot add a pull subscription agent for a push subscription.