Hi,
I have a problem when setting filegroup to readonly in EM.
I go to property of a database, click on FileGroup tab,
I checked READ-ONLY checkbox, when I apply, Error message box popup, Error
20541: [SQL-DMO] Can not change the name of the default file group, drop
the
default file group, or set it to READONLY. what is the problem and how can
I make it readonly?From the error message, it looks like you are trying to set
the primary filegroup to read-only. The primary filegroup
cannot be made read-only.
-Sue
On Wed, 12 May 2004 17:25:37 -0400, "joe"
<pearl_77@.hotmail.com> wrote:
>Hi,
>I have a problem when setting filegroup to readonly in EM.
>I go to property of a database, click on FileGroup tab,
>I checked READ-ONLY checkbox, when I apply, Error message box popup, Error
>20541: [SQL-DMO] Can not change the name of the default file group, dro
p the
>default file group, or set it to READONLY. what is the problem and how can
>I make it readonly?
>sql
Showing posts with label tab. Show all posts
Showing posts with label tab. Show all posts
Sunday, March 25, 2012
Monday, March 19, 2012
Change CSV export to TAB delimited
Hi,
I want to change the CSV export to TAB delimited instead of comma delimited
in order Excel to open it properly without defining the delimiter each time I
open the export. I define the following in rsreportserver.config:
<Extension Name="CSV-TAB"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<OverrideNames>
<Name Language="en-US">CSV - TAB Delimited</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<FieldDelimiter> </FieldDelimiter>
</DeviceInfo>
</Configuration>
</Extension>
but I still get comma delimited file.
Thanks,
Ronen Fidel
UnisfairI have never tried this, but perhaps you need to use \t ?
=-Chris
"FidelR" <fidelr@.newsgroups.nospam> wrote in message
news:7CC6BBEB-95AA-4205-8426-646A07974B51@.microsoft.com...
> Hi,
> I want to change the CSV export to TAB delimited instead of comma
> delimited
> in order Excel to open it properly without defining the delimiter each
> time I
> open the export. I define the following in rsreportserver.config:
> <Extension Name="CSV-TAB"
> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
> <OverrideNames>
> <Name Language="en-US">CSV - TAB Delimited</Name>
> </OverrideNames>
> <Configuration>
> <DeviceInfo>
> <FieldDelimiter> </FieldDelimiter>
> </DeviceInfo>
> </Configuration>
> </Extension>
> but I still get comma delimited file.
> Thanks,
> Ronen Fidel
> Unisfair|||I tried \t and %09 but I still get comma delimited file. There are notes in
some web forums that claim that this is a known bug. Can you or anyone else
confirm that?
Thanks,
Ronen Fidel
Unisfair
"Chris Conner" wrote:
> I have never tried this, but perhaps you need to use \t ?
> =-Chris
> "FidelR" <fidelr@.newsgroups.nospam> wrote in message
> news:7CC6BBEB-95AA-4205-8426-646A07974B51@.microsoft.com...
> > Hi,
> >
> > I want to change the CSV export to TAB delimited instead of comma
> > delimited
> > in order Excel to open it properly without defining the delimiter each
> > time I
> > open the export. I define the following in rsreportserver.config:
> > <Extension Name="CSV-TAB"
> > Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
> > <OverrideNames>
> > <Name Language="en-US">CSV - TAB Delimited</Name>
> > </OverrideNames>
> > <Configuration>
> > <DeviceInfo>
> > <FieldDelimiter> </FieldDelimiter>
> > </DeviceInfo>
> > </Configuration>
> > </Extension>
> > but I still get comma delimited file.
> >
> > Thanks,
> > Ronen Fidel
> > Unisfair
>
>
I want to change the CSV export to TAB delimited instead of comma delimited
in order Excel to open it properly without defining the delimiter each time I
open the export. I define the following in rsreportserver.config:
<Extension Name="CSV-TAB"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<OverrideNames>
<Name Language="en-US">CSV - TAB Delimited</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<FieldDelimiter> </FieldDelimiter>
</DeviceInfo>
</Configuration>
</Extension>
but I still get comma delimited file.
Thanks,
Ronen Fidel
UnisfairI have never tried this, but perhaps you need to use \t ?
=-Chris
"FidelR" <fidelr@.newsgroups.nospam> wrote in message
news:7CC6BBEB-95AA-4205-8426-646A07974B51@.microsoft.com...
> Hi,
> I want to change the CSV export to TAB delimited instead of comma
> delimited
> in order Excel to open it properly without defining the delimiter each
> time I
> open the export. I define the following in rsreportserver.config:
> <Extension Name="CSV-TAB"
> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
> <OverrideNames>
> <Name Language="en-US">CSV - TAB Delimited</Name>
> </OverrideNames>
> <Configuration>
> <DeviceInfo>
> <FieldDelimiter> </FieldDelimiter>
> </DeviceInfo>
> </Configuration>
> </Extension>
> but I still get comma delimited file.
> Thanks,
> Ronen Fidel
> Unisfair|||I tried \t and %09 but I still get comma delimited file. There are notes in
some web forums that claim that this is a known bug. Can you or anyone else
confirm that?
Thanks,
Ronen Fidel
Unisfair
"Chris Conner" wrote:
> I have never tried this, but perhaps you need to use \t ?
> =-Chris
> "FidelR" <fidelr@.newsgroups.nospam> wrote in message
> news:7CC6BBEB-95AA-4205-8426-646A07974B51@.microsoft.com...
> > Hi,
> >
> > I want to change the CSV export to TAB delimited instead of comma
> > delimited
> > in order Excel to open it properly without defining the delimiter each
> > time I
> > open the export. I define the following in rsreportserver.config:
> > <Extension Name="CSV-TAB"
> > Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
> > <OverrideNames>
> > <Name Language="en-US">CSV - TAB Delimited</Name>
> > </OverrideNames>
> > <Configuration>
> > <DeviceInfo>
> > <FieldDelimiter> </FieldDelimiter>
> > </DeviceInfo>
> > </Configuration>
> > </Extension>
> > but I still get comma delimited file.
> >
> > Thanks,
> > Ronen Fidel
> > Unisfair
>
>
Subscribe to:
Posts (Atom)