Monthly Archives: February 2011

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

Export list of files in a folder and subfolders from windows explorer

I have been trying to get a list of all the backup files present on a particular drive; Here is how I acheived this. Go start —> run —>cmd this opens a command prompt window Browse to the folder you need to … Continue reading

Posted in Tricks, Windows | Tagged , | Leave a comment

Copy Folder Structure without copying any files in the folder

Use robocopy and make sure you have /XF * included in the statement, to exclude all the files mactching * ie exclude everything. c:>robocopy D:\Backups\11.02 D:\Backups\11.02.08 /mir /Z /PF /XF *

Posted in Windows | Tagged | Leave a comment