Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
phrankbooth
Posting Yak Master
162 Posts |
 Posted - 2013-08-20 : 11:48:03
|
| I have an xmla query that is 10.8 megs, to generate a full SSAS DB with partitions.After a certain size the editor stops working, I cannot copy paste from/to it, I get memory errors when trying to save and when I try to execute the query, nothing happens.I haven't found anything related to xmla limit that's out there.Anyone aware of a limit in this area? And if there is, does SQL 2012 remedy it?Thanks!--PhB |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-08-21 : 00:35:41
|
| one thing you can do in that case is use SSIS Analysis Services DDL/Processing task to execute the xmla script if you'e hitting memory limit on SSMS query window------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
SQL2008R2: Should there be a limit xmla qry size?