Changing the file name stored in database properties

I need to change the file name of a database.
The name I need to change is shown when you right click on a database and
select properties then select the Data File tab.
I need to change the filename associated with the database.
Is this possible and how
Regards
Jeff
--
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.504 / Virus Database: 302 - Release Date: 24/07/2003Jeff,
The filename you mentioned is the "logical filename".Why I clarified is
because, normally the xxxx.mdf is referred as filename of data file.As Kalen
mentioned, you can change the logical filename only in SQL2000 and the
command is:
ALTER DATABASE <databasename>
MODIFY FILE (NAME= '<oldlogicalfilename>', NEWNAME = '<newlogicalfilename>')
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Jeff Williams" <jeff.williams@.hardsoft.com.au> wrote in message
news:eUENlIfXDHA.2484@.TK2MSFTNGP09.phx.gbl...
> I need to change the file name of a database.
> The name I need to change is shown when you right click on a database and
> select properties then select the Data File tab.
> I need to change the filename associated with the database.
> Is this possible and how
> Regards
> Jeff
>
> --
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.504 / Virus Database: 302 - Release Date: 24/07/2003
>

Changing labels inside the rdl on runtime

Hi
Is it possible to change labels inside a report before rendering it? I need
to localize some labels before the report is shown in my
WinForms-Application. I do not want to have one report for each language.
Sometimes I need to change some more things in the report not only labels.
So, how can I get access to all the controls (lists, textboxes, subreports
etc.) of my report?
Thanks
MichaelThe approach I took was a custom assembly with a resource file. I park the
language identifier in a property then use an accessor method in the
assembly to fetch the string from the correct resource file. You can pass
in the ReportItems object into a custom assembly or code behind. If the
report has a page with no rows I've had trouble with this and wasn't able to
figure it out.
Thanks,
Steve MunLeeuw
"Michael Reukauff" <mreukauff@.gmx.net> wrote in message
news:O$Tk2LdpGHA.4996@.TK2MSFTNGP05.phx.gbl...
> Hi
> Is it possible to change labels inside a report before rendering it? I
> need to localize some labels before the report is shown in my
> WinForms-Application. I do not want to have one report for each language.
> Sometimes I need to change some more things in the report not only labels.
> So, how can I get access to all the controls (lists, textboxes, subreports
> etc.) of my report?
> Thanks
> Michael
>

Changing label of y-axis

For my report i have to change the label of the y-axis. My dataset is
returning integer values "0", "1", "2". These values are now shown as the
label. However, i need to translate these ID's to string values, such as "0"
= "no value available", "1" = "service down", "2" = "service up".
I have tied to insert a code snippet for conditinal names in the Label
Format Code field
=IIF(Fields!Parameter.Value=0, "no values available", Fields!Parameter.Value)
but this does not solve the problem, because it seems i can only use
formatting code in the label field.
Is there a way to do this or do i have to label my y-axis as is and insert a
legend to let the reader of the report know, what that values are meaning?For the series or category (I forget which one is the y-axis), specify the
following instead of just "Fields!myvalue.value"
=IIF(Fields!myValue.value = 0, "No value available",
IIF(Fields!myValue.Value = 1, "Service Down", "Service Up"))
Replace "myvalue" with the actual name of your column.
"Ben" <yogiben_at_gmx_dot_net> wrote in message
news:2B86E61F-186C-4A74-AE0B-EAF85F1DF9C7@.microsoft.com...
> For my report i have to change the label of the y-axis. My dataset is
> returning integer values "0", "1", "2". These values are now shown as the
> label. However, i need to translate these ID's to string values, such as
> "0"
> = "no value available", "1" = "service down", "2" = "service up".
> I have tied to insert a code snippet for conditinal names in the Label
> Format Code field
> =IIF(Fields!Parameter.Value=0, "no values available",
> Fields!Parameter.Value)
> but this does not solve the problem, because it seems i can only use
> formatting code in the label field.
> Is there a way to do this or do i have to label my y-axis as is and insert
> a
> legend to let the reader of the report know, what that values are meaning?