Does your Management Studio registration use the actual server name or does it use the IP address or a virtual name? I ran into this problem as well, when...

If you right click on a single stored proc and script out a drop statement for it, the IF EXISTS is generated as part of the DROP. This has...

If you right click on a single stored proc and script out a drop statement for it, the IF EXISTS is generated as part of the DROP. This has...

Yes, thanks, but it doesn't generate the IF EXISTS part of the drop statement...

To bump a thread on an Internet forum is to post a reply to it purely in order to raise the thread's profile. This will typically return...

As the previous poster says, the login which owned that database has been dropped.  You can readd the login back to your SQL Server or reassign the database ownership to...

Take a look at the default database for this user.  If the default database no longer exists, or if the default database is offline or otherwise not accessible, SQL Server...

Thanks for your response.  I do think it can be solved with either a calculated member or a custom rollup but I haven't quite figured it out yet.

The mail quantity...

Depending on the type of cube you are processing, MOLAP, ROLAP, or HOLAP, the dimension data and the fact table data and aggregates are stored either in files on the operating...

Thanks - I'll try editing that to display the connection string.  I also found under Tools->Macro->Miscrosoft Script Editor, searching on the provider name "MSOLAP" brings up the connection string in...

Steve, thanks so much for answering my question.  Unfortunately I have multiple .oqy files, multiple spreadsheets and multiple cubes.  How can I determine which .oqy file goes with a given excel pivot...

Yes, thanks.  I understand that I can edit the transformations for individual columns but what I wanted was to match the settings that the wizard uses for datetime, decimal, int,...