SQL Server

This category contains 94 posts

How to fix System.OutOfMemoryException when using SSMS

Problem: When executing a query through SSMS you get a System.OutOfMemoryException error “An error occurred while executing batch. Error message is: Exception of type ‘System.OutOfMemoryException’ was thrown.” Solution: SSMS is a 32 bit process. It is limited to 2GB memory.When using Grid Mode there is a 64 kb limit per database field. If the result … Continue reading

Understanding the SSIS Package Protection Level

One property of all SSIS packages that you must understand is the ProtectionLevel. This property tells SSIS how to handle sensitive information stored within your packages. Most commonly this is a password stored in a connection string. Why is this information important? If you don’t set the ProtectionLevel correctly, the package may become unusable. Other … Continue reading

Creating a Linked Server for Analysis Services

  To set up a linked server for Analysis Services, follow these steps: Connect to the Database Engine in Management Studio. Expand Server Objects, right-click Linked Servers, and click New Linked Server. Define a name for the linked server, and set the following options as shown in the screenshot below: Provider: Microsoft OLE DB Provider … Continue reading

SSAS: Errors in the metadata manager

Can not Open, Browse, Process, Rename or Delete a Cube and\or SSAS cube database Recently I had received notification from one of my developers that they could not process a cube after a deployment. So the first thing I tried to do is recreate the issue and tried to process the cube but no cubes … Continue reading