Add Datafile

I have a need to add a secondary datafile. My question pertains to the
FIlegroups tab in Enterprise Manager. Do I need to change the value of the
Primary Filegroup 'Files' from 1 to 2? From researching, I believe that a
database can only have one primary file.
Hi
I prefer to do such things by QA not by EM
CREATE DATABASE databasename
GO
ALTER DATABASE databasename SET RECOVERY FULL
ALTER DATABASE databasename ADD FILEGROUP new_customers
ALTER DATABASE databasename ADD FILEGROUP sales
GO
ALTER DATABASE databasenameADD FILE
(NAME=databasename_data_1',
FILENAME='d:\mw.dat1')
TO FILEGROUP new_customers
ALTER DATABASE databasename
ADD FILE
(NAME='databasename_data_2',
FILENAME='d:\mw.dat2')
TO FILEGROUP sales
"paldba" <paldba@.discussions.microsoft.com> wrote in message
news:560E20AD-0955-44A6-95AF-6C853151F478@.microsoft.com...
>I have a need to add a secondary datafile. My question pertains to the
> FIlegroups tab in Enterprise Manager. Do I need to change the value of
> the
> Primary Filegroup 'Files' from 1 to 2? From researching, I believe that a
> database can only have one primary file.

Add Datafile

I have a need to add a secondary datafile. My question pertains to the
FIlegroups tab in Enterprise Manager. Do I need to change the value of the
Primary Filegroup 'Files' from 1 to 2? From researching, I believe that a
database can only have one primary file.Hi
I prefer to do such things by QA not by EM
CREATE DATABASE databasename
GO
ALTER DATABASE databasename SET RECOVERY FULL
ALTER DATABASE databasename ADD FILEGROUP new_customers
ALTER DATABASE databasename ADD FILEGROUP sales
GO
ALTER DATABASE databasenameADD FILE
(NAME=databasename_data_1',
FILENAME='d:\mw.dat1')
TO FILEGROUP new_customers
ALTER DATABASE databasename
ADD FILE
(NAME='databasename_data_2',
FILENAME='d:\mw.dat2')
TO FILEGROUP sales
"paldba" <paldba@.discussions.microsoft.com> wrote in message
news:560E20AD-0955-44A6-95AF-6C853151F478@.microsoft.com...
>I have a need to add a secondary datafile. My question pertains to the
> FIlegroups tab in Enterprise Manager. Do I need to change the value of
> the
> Primary Filegroup 'Files' from 1 to 2? From researching, I believe that a
> database can only have one primary file.

Add Datafile

I have a need to add a secondary datafile. My question pertains to the
FIlegroups tab in Enterprise Manager. Do I need to change the value of the
Primary Filegroup 'Files' from 1 to 2? From researching, I believe that a
database can only have one primary file.Hi
I prefer to do such things by QA not by EM
CREATE DATABASE databasename
GO
ALTER DATABASE databasename SET RECOVERY FULL
ALTER DATABASE databasename ADD FILEGROUP new_customers
ALTER DATABASE databasename ADD FILEGROUP sales
GO
ALTER DATABASE databasenameADD FILE
(NAME=databasename_data_1',
FILENAME='d:\mw.dat1')
TO FILEGROUP new_customers
ALTER DATABASE databasename
ADD FILE
(NAME='databasename_data_2',
FILENAME='d:\mw.dat2')
TO FILEGROUP sales
"paldba" <paldba@.discussions.microsoft.com> wrote in message
news:560E20AD-0955-44A6-95AF-6C853151F478@.microsoft.com...
>I have a need to add a secondary datafile. My question pertains to the
> FIlegroups tab in Enterprise Manager. Do I need to change the value of
> the
> Primary Filegroup 'Files' from 1 to 2? From researching, I believe that a
> database can only have one primary file.

add border in matrix report with 2 row group

I have matrix report with 2 row group.

I want to add border to the first Row group.

when I Try add border in the layout tab. the border added to all the cell.

here is my image to show:
http://img2.tapuz.co.il/forums/1_92118232.jpg

is it possible?

thanks!try again

Add an export format

I want to add an export option for the report dropdown menus that will allow
users to export reports to tab delimited files. This will allow them to open
up the data of a report directly in excel.
Does anyone know if this can be done?First you can render a report in Excel already using one of the rendering
extensions... You may have the report rendered in excel immediately by
calling the report from a URL passing the rendering extention , or having a
user subscribe to the report in Excel.
However if you really wish to, you may write a new rendering extension which
renders a tab delimited report, and load it into reporting services, and
modify some config files... This is documented in books on line... look for
rendering extensions..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"DBA72" <DBA72@.discussions.microsoft.com> wrote in message
news:A5CBA5C7-9FA1-40A1-8132-45DC9E838D60@.microsoft.com...
>I want to add an export option for the report dropdown menus that will
>allow
> users to export reports to tab delimited files. This will allow them to
> open
> up the data of a report directly in excel.
> Does anyone know if this can be done?|||Were you able to get this adding to the dropdown menu? -Peter
"Wayne Snyder" wrote:
> First you can render a report in Excel already using one of the rendering
> extensions... You may have the report rendered in excel immediately by
> calling the report from a URL passing the rendering extention , or having a
> user subscribe to the report in Excel.
> However if you really wish to, you may write a new rendering extension which
> renders a tab delimited report, and load it into reporting services, and
> modify some config files... This is documented in books on line... look for
> rendering extensions..
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "DBA72" <DBA72@.discussions.microsoft.com> wrote in message
> news:A5CBA5C7-9FA1-40A1-8132-45DC9E838D60@.microsoft.com...
> >I want to add an export option for the report dropdown menus that will
> >allow
> > users to export reports to tab delimited files. This will allow them to
> > open
> > up the data of a report directly in excel.
> >
> > Does anyone know if this can be done?
>
>