Troubleshooting Microsoft SQL Server

Blog is a collection of misc troubleshooting tips collected while supporting Microsoft SQL Server 2000, 2005, and 2008. Specialty area covered is SQL Server Data Replication including Transactional Replication, Merge Replication, Change Data Capture, and

Browse by Tags

Tagged Content List
  • Blog Post: Script to purge TokenAndPermUserStore

    Here is a script that purge the 'TokenAndPermUserStore' every time it reaches 100MB. DECLARE @CacheSize int DECLARE @CurDate varchar ( 30 ) WHILE ( 1 = 1 ) BEGIN SET @CurDate = CONVERT ( varchar , GETDATE (), 126 ) SELECT @CacheSize = SUM ( single_pages_kb + multi_pages_kb...
Page 1 of 1 (1 items)