Category Archives: Troubleshooting

User ‘public’ does not have permission to run DBCC showfilestats for database ‘ testing’

User ‘public’ does not have permission to run DBCC showfilestats for database ‘ testing’ This error message is raised when your user account does not have the db_owner role of a database meaning you are not the owner of the … Continue reading

Posted in SQL Server, T-SQL Scripts, Tricks, Troubleshooting | Tagged , , | Leave a comment

Exception Message: The snapshot could not be generated because the publisher is inactive.

Issue:- Snapshot Agent throw errors while setting up transactional replication. Replication scripted out from another server and applied with the new publisher, distributor and subscriber details. Message Microsoft (R) SQL Server Snapshot Agent [Assembly Version = 10.0.0.0, File Version = … Continue reading

Posted in Replication, SQL Server, Troubleshooting | Tagged | Leave a comment

Msg 14234, Level 16, State 1, Procedure sp_verify_jobstep, Line 214

Msg 14234, Level 16, State 1, Procedure sp_verify_jobstep, Line 214 Issue:- Unable to enable a database to publish running the t-sql exec sp_replicationdboption ‘<dbname>’,’Publish’,’true’ Msg 14234, Level 16, State 1, Procedure sp_verify_jobstep, Line 214 The specified ‘@server’ is invalid (valid … Continue reading

Posted in Replication, SQL Server, Troubleshooting | Tagged | 2 Comments

System.Data.SqlClient.SqlException: The RPC security information for the Publisher is missing or invalid. Use sp_link_publication to specify it. Updateable Subscriptions: Rolling back transaction

System.Data.SqlClient.SqlException: The RPC security information for the Publisher is missing or invalid. Use sp_link_publication to specify it. Updateable Subscriptions: Rolling back transaction Resolution:- Add a link to the publisher server on the subscriber database for the updatable subscription (transactional replication). … Continue reading

Posted in Replication, SQL Server, Troubleshooting | Tagged , , , | Leave a comment

Failed to decrypt protected XML node “DTS:Property” with error 0x8009000B “Key not valid for use in specified state.”

TITLE: Microsoft Visual Studio ——————————————— There were errors while the package was being loaded. The package might be corrupted. See the Error List for details. ——————————————— BUTTONS: OK ——————————————— Error    1    Error loading xyz.dtsx: Failed to decrypt protected XML node … Continue reading

Posted in SQL Server, SSIS, Troubleshooting | Tagged , , , , | 4 Comments

File attachment or query results size exceeds allowable value of 1000000 bytes

Msg 22051, Level 16, State 1, Line 0 File attachment or query results size exceeds allowable value of 1000000 bytes. Send mail task in a DTA package failed with the below error attaching a .csv file of 3MB. File attachment … Continue reading

Posted in Database Mail, SQL Server, Troubleshooting | Tagged , | Leave a comment

Msg 7302, Level 16, State 1, Line 1 Cannot create an instance of OLE DB Provider “Microsoft.ACE.OLEDB.12.0” for linked server “(null)”.

Msg 7302, Level 16, State 1, Line 1 Cannot create an instance of OLE DB Provider “Microsoft.ACE.OLEDB.12.0” for linked server “(null)”. Msg 7302, Level 16, State 1, Line 1 Cannot create an instance of OLE DB Provider “Microsoft.ACE.OLEDB.12.0” for linked … Continue reading

Posted in SQL Server, Troubleshooting | Tagged , , | Leave a comment