Browse by Tags

Working with SSAS traces and the dreaded Textdata in SSMS
04 February 2012 22:06

For good or bad i regularly work with SSAS traces that i have saved to a table and many years ago i was regularly frustrated by the fact that the contents of the textdata column containing the query is always truncated at 65535 characters. You may think 65535 characters should cover most queries but once Excel gets to work it generates some huge queries! Fortunately... Read More...

by ACALVETT | with no comments

Filed under: Tools, Tips, SSMS, SSAS 2005, Analysis Services, SSAS, 2008, SSAS 2008 R2, 2008 R2, SSAS 2008, Trouble Shooting, Profiling

SSMS Restore backup error
14 September 2007 15:31

We had a requirement to allow someone to create and restore databases on a test server today and i thought to myself "Thats easy, i`ll just grant the "Create Any Database" right to the appropriate user, thats when the pain began! The user was using SSMS connecting using a SQL login to restore a database and when they went to specify the backup location they got... Read More...

by ACALVETT | with no comments

Filed under: SQL 2005, SSMS, Security