MHTML Streaming

I am streaming an MHTML file to an aspx page:
Response.Clear()
Response.AddHeader("Content-Disposition", "inline; filename=MyFile.mht")
Response.AddHeader("Content-Length", MyByteArray.Length.ToString)
Response.ContentType = "multipart/related"
Response.BinaryWrite(MyByteArray)
Response.Flush()
When I load the aspx page on my computer with IE... I get "Invalid syntax
error"... when I load the same page... thru HTTP access from a co-worker's
computer... it loads fine... what am I doing wrong?
Not sure if it makes a difference... I had the address bar hidden so I didn't
notice at first... when my co-worker renders the stream the url stays the
same... for me I get mhtml: in front of the url... in addition to the
"invalid syntax" error.I figured I should post this in case other ppl were looking for some
answers... apparently my MHTML issue has something to do with a security
patch for IE... there is however a way to get around it...
You can attach a dummy query string to your aspx page that ends with a .mht.
For example, if the page that streams down mht content is MyPage.aspx, then
you want to use this URL:
http://Path-To-File/MyPage.aspx?ignored=whatever.mht
"MER78" wrote:
> I am streaming an MHTML file to an aspx page:
> Response.Clear()
> Response.AddHeader("Content-Disposition", "inline; filename=MyFile.mht")
> Response.AddHeader("Content-Length", MyByteArray.Length.ToString)
> Response.ContentType = "multipart/related"
> Response.BinaryWrite(MyByteArray)
> Response.Flush()
> When I load the aspx page on my computer with IE... I get "Invalid syntax
> error"... when I load the same page... thru HTTP access from a co-worker's
> computer... it loads fine... what am I doing wrong?
> Not sure if it makes a difference... I had the address bar hidden so I didn't
> notice at first... when my co-worker renders the stream the url stays the
> same... for me I get mhtml: in front of the url... in addition to the
> "invalid syntax" error.

Metabase Log

We are using MSCRM and my SQL Metabase Log file is 21.3GB and my Metabase
Database file is 18.7MB. How do I clear out the Metabase Log File?
Check the recovery model of the database. If it is in full mode, the
database log file will keep growing, unless you take periodic transaction
log backups.
If you don't need transaction log backups, but simply want to backup the
database once a day or so, switch the database to simple recovery mode.
This can be done from the database properties dialog box in Enterprise
Manager.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"KMD" <KMD@.discussions.microsoft.com> wrote in message
news:9D0CA478-2FAA-4AEA-97B7-C4608637D1F8@.microsoft.com...
We are using MSCRM and my SQL Metabase Log file is 21.3GB and my Metabase
Database file is 18.7MB. How do I clear out the Metabase Log File?
|||My backup strategy is set to Simple for quite some time now. How can I
regain the space that is used in the Metabase Log, it is 21GIG. To backup
the Transaction Log is greyed out, is this because the recovery model is set
to Simple. Any ideas to regain this space.
"Narayana Vyas Kondreddi" wrote:

> Check the recovery model of the database. If it is in full mode, the
> database log file will keep growing, unless you take periodic transaction
> log backups.
> If you don't need transaction log backups, but simply want to backup the
> database once a day or so, switch the database to simple recovery mode.
> This can be done from the database properties dialog box in Enterprise
> Manager.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "KMD" <KMD@.discussions.microsoft.com> wrote in message
> news:9D0CA478-2FAA-4AEA-97B7-C4608637D1F8@.microsoft.com...
> We are using MSCRM and my SQL Metabase Log file is 21.3GB and my Metabase
> Database file is 18.7MB. How do I clear out the Metabase Log File?
>
>
|||Try shrinking the file (DBCC SHRINKFILE).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"KMD" <KMD@.discussions.microsoft.com> wrote in message
news:06A1E21B-0CD9-49E7-A93B-6E50D104D8BC@.microsoft.com...[vbcol=seagreen]
> My backup strategy is set to Simple for quite some time now. How can I
> regain the space that is used in the Metabase Log, it is 21GIG. To backup
> the Transaction Log is greyed out, is this because the recovery model is set
> to Simple. Any ideas to regain this space.
> "Narayana Vyas Kondreddi" wrote:

Metabase Log

We are using MSCRM and my SQL Metabase Log file is 21.3GB and my Metabase
Database file is 18.7MB. How do I clear out the Metabase Log File?Check the recovery model of the database. If it is in full mode, the
database log file will keep growing, unless you take periodic transaction
log backups.
If you don't need transaction log backups, but simply want to backup the
database once a day or so, switch the database to simple recovery mode.
This can be done from the database properties dialog box in Enterprise
Manager.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"KMD" <KMD@.discussions.microsoft.com> wrote in message
news:9D0CA478-2FAA-4AEA-97B7-C4608637D1F8@.microsoft.com...
We are using MSCRM and my SQL Metabase Log file is 21.3GB and my Metabase
Database file is 18.7MB. How do I clear out the Metabase Log File?|||My backup strategy is set to Simple for quite some time now. How can I
regain the space that is used in the Metabase Log, it is 21GIG. To backup
the Transaction Log is greyed out, is this because the recovery model is set
to Simple. Any ideas to regain this space.
"Narayana Vyas Kondreddi" wrote:
> Check the recovery model of the database. If it is in full mode, the
> database log file will keep growing, unless you take periodic transaction
> log backups.
> If you don't need transaction log backups, but simply want to backup the
> database once a day or so, switch the database to simple recovery mode.
> This can be done from the database properties dialog box in Enterprise
> Manager.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "KMD" <KMD@.discussions.microsoft.com> wrote in message
> news:9D0CA478-2FAA-4AEA-97B7-C4608637D1F8@.microsoft.com...
> We are using MSCRM and my SQL Metabase Log file is 21.3GB and my Metabase
> Database file is 18.7MB. How do I clear out the Metabase Log File?
>
>|||Try shrinking the file (DBCC SHRINKFILE).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"KMD" <KMD@.discussions.microsoft.com> wrote in message
news:06A1E21B-0CD9-49E7-A93B-6E50D104D8BC@.microsoft.com...
> My backup strategy is set to Simple for quite some time now. How can I
> regain the space that is used in the Metabase Log, it is 21GIG. To backup
> the Transaction Log is greyed out, is this because the recovery model is set
> to Simple. Any ideas to regain this space.
> "Narayana Vyas Kondreddi" wrote:
>> Check the recovery model of the database. If it is in full mode, the
>> database log file will keep growing, unless you take periodic transaction
>> log backups.
>> If you don't need transaction log backups, but simply want to backup the
>> database once a day or so, switch the database to simple recovery mode.
>> This can be done from the database properties dialog box in Enterprise
>> Manager.
>> --
>> HTH,
>> Vyas, MVP (SQL Server)
>> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>>
>> "KMD" <KMD@.discussions.microsoft.com> wrote in message
>> news:9D0CA478-2FAA-4AEA-97B7-C4608637D1F8@.microsoft.com...
>> We are using MSCRM and my SQL Metabase Log file is 21.3GB and my Metabase
>> Database file is 18.7MB. How do I clear out the Metabase Log File?
>>

Metabase Log

We are using MSCRM and my SQL Metabase Log file is 21.3GB and my Metabase
Database file is 18.7MB. How do I clear out the Metabase Log File?Check the recovery model of the database. If it is in full mode, the
database log file will keep growing, unless you take periodic transaction
log backups.
If you don't need transaction log backups, but simply want to backup the
database once a day or so, switch the database to simple recovery mode.
This can be done from the database properties dialog box in Enterprise
Manager.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"KMD" <KMD@.discussions.microsoft.com> wrote in message
news:9D0CA478-2FAA-4AEA-97B7-C4608637D1F8@.microsoft.com...
We are using MSCRM and my SQL Metabase Log file is 21.3GB and my Metabase
Database file is 18.7MB. How do I clear out the Metabase Log File?|||My backup strategy is set to Simple for quite some time now. How can I
regain the space that is used in the Metabase Log, it is 21GIG. To backup
the Transaction Log is greyed out, is this because the recovery model is set
to Simple. Any ideas to regain this space.
"Narayana Vyas Kondreddi" wrote:

> Check the recovery model of the database. If it is in full mode, the
> database log file will keep growing, unless you take periodic transaction
> log backups.
> If you don't need transaction log backups, but simply want to backup the
> database once a day or so, switch the database to simple recovery mode.
> This can be done from the database properties dialog box in Enterprise
> Manager.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "KMD" <KMD@.discussions.microsoft.com> wrote in message
> news:9D0CA478-2FAA-4AEA-97B7-C4608637D1F8@.microsoft.com...
> We are using MSCRM and my SQL Metabase Log file is 21.3GB and my Metabase
> Database file is 18.7MB. How do I clear out the Metabase Log File?
>
>|||Try shrinking the file (DBCC SHRINKFILE).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"KMD" <KMD@.discussions.microsoft.com> wrote in message
news:06A1E21B-0CD9-49E7-A93B-6E50D104D8BC@.microsoft.com...[vbcol=seagreen]
> My backup strategy is set to Simple for quite some time now. How can I
> regain the space that is used in the Metabase Log, it is 21GIG. To backup
> the Transaction Log is greyed out, is this because the recovery model is s
et
> to Simple. Any ideas to regain this space.
> "Narayana Vyas Kondreddi" wrote:
>