The Operation could not Completed. Not enough storage is available to complete this operation
-
Good Day All i am producing an XML from a Query and on result pane i clicked the XML results and it showed my XML nicely, now i wanted to save it in my local machine as an XML file, i clicked the save's and chooses the location and when i click on save it gave me this error
The Operation could not Completed. Not enough storage is available to complete this operationMy XML 50 Megs ThanksVuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
-
Good Day All i am producing an XML from a Query and on result pane i clicked the XML results and it showed my XML nicely, now i wanted to save it in my local machine as an XML file, i clicked the save's and chooses the location and when i click on save it gave me this error
The Operation could not Completed. Not enough storage is available to complete this operationMy XML 50 Megs ThanksVuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
Please tell me you checked the disk space! Is there a limitation on the size of xml files, does the parser support 50mb. I know we had to chop up a bunch of xml files a few years ago due to some obscure size limitations, I'm not sure if it was the xml or the application producing it.
Never underestimate the power of human stupidity RAH
-
Please tell me you checked the disk space! Is there a limitation on the size of xml files, does the parser support 50mb. I know we had to chop up a bunch of xml files a few years ago due to some obscure size limitations, I'm not sure if it was the xml or the application producing it.
Never underestimate the power of human stupidity RAH
I am producing an XML from SQL Management Studio and save it to a file , the part that is supposed to save to a file its where i get a problem. my HD free space is 350GIG
Vuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
-
I am producing an XML from SQL Management Studio and save it to a file , the part that is supposed to save to a file its where i get a problem. my HD free space is 350GIG
Vuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
-
I am producing an XML from SQL Management Studio and save it to a file , the part that is supposed to save to a file its where i get a problem. my HD free space is 350GIG
Vuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
Vuyiswa Maseko wrote:
my HD free space is 350GIG
I had to ask - have you tried saving a smaller file. I suspect it is a permissions issue rather than an IO problem. The SQL account holder needs to have permissions on the hard drive.
Never underestimate the power of human stupidity RAH
-
Good Day All i am producing an XML from a Query and on result pane i clicked the XML results and it showed my XML nicely, now i wanted to save it in my local machine as an XML file, i clicked the save's and chooses the location and when i click on save it gave me this error
The Operation could not Completed. Not enough storage is available to complete this operationMy XML 50 Megs ThanksVuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/
Is this relevant to your problem? http://connect.microsoft.com/SQLServer/feedback/details/269566/sql-server-management-studio-cant-handle-large-files[^] This mentions exactly the same error message that you are receiving, and there are several other posts in forums etc. from people struggling with large XML data sets in SSMS. It looks as if SSMS has a problem with big files. As at August 2010 this still had not been fixed.
-
Is this relevant to your problem? http://connect.microsoft.com/SQLServer/feedback/details/269566/sql-server-management-studio-cant-handle-large-files[^] This mentions exactly the same error message that you are receiving, and there are several other posts in forums etc. from people struggling with large XML data sets in SSMS. It looks as if SSMS has a problem with big files. As at August 2010 this still had not been fixed.
Good Day David This is exactly my problem. So the workaround this is to split the XML. Thanks
Vuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/