Change DB Owner

Hello,
We have a person leaving us who is the owner of a
database. How can we switch the owner to someone else ?
M
Mia,
Check the sp_changedbowner system sp in Books OnLine.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Mia" <anonymous@.discussions.microsoft.com> wrote in message
news:2e8001c50a14$8b392950$a501280a@.phx.gbl...
> Hello,
> We have a person leaving us who is the owner of a
> database. How can we switch the owner to someone else ?
> M
|||See sp_changedbowner in SQL Server Books Online.
Anith

Change DB Owner

Hello,
We have a person leaving us who is the owner of a
database. How can we switch the owner to someone else ?
MMia,
Check the sp_changedbowner system sp in Books OnLine.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Mia" <anonymous@.discussions.microsoft.com> wrote in message
news:2e8001c50a14$8b392950$a501280a@.phx.gbl...
> Hello,
> We have a person leaving us who is the owner of a
> database. How can we switch the owner to someone else ?
> M|||See sp_changedbowner in SQL Server Books Online.
--
Anith|||Thanks Guys
>--Original Message--
>Hello,
>We have a person leaving us who is the owner of a
>database. How can we switch the owner to someone else ?
>M
>.
>

Change DB Owner

Hello,
We have a person leaving us who is the owner of a
database. How can we switch the owner to someone else ?
MMia,
Check the sp_changedbowner system sp in Books OnLine.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Mia" <anonymous@.discussions.microsoft.com> wrote in message
news:2e8001c50a14$8b392950$a501280a@.phx.gbl...
> Hello,
> We have a person leaving us who is the owner of a
> database. How can we switch the owner to someone else ?
> M|||See sp_changedbowner in SQL Server Books Online.
Anith

change chart color

Hello,

Is it possible to specify color in more detail in the switch statement?

not "yellow" or "red" but I want to determine the colors by "RGB-values"...

hope everyone understands my problem

regards,

Rhapsy

Not sure I understand your question, but you can specify colors as RGB values like HTML colors. Instead of specifying a color by name, you specify it as RGB values, e.g.:

#00FF00

-- Robert

|||

Hi Rhapsy,

This is what I use for charts

Put this in the code window (Reports/Properties/Code). you can use RGB values or colour names

Public Function Qtr_Colour(Quarter as String) As string

Dim Bar_Colour as String

Select Case Quarter

Case "Qtr 1"

Bar_Colour = "#CCCCCC"

Case "Qtr 2"

Bar_Colour = "#333333"

Case "Qtr 3"

Bar_Colour = "#FFCC00"

Case "Qtr 4"

Bar_Colour = "Silver"

Case "Qtr +"

Bar_Colour = "LightYellow"

Case Else

Bar_Colour = "#FFFFFF"

End Select

Return Bar_Colour

End Function

Then reference it in the formatting area of your chart data item (chart properties/data:values/edit/appearance/series style/ fill) like this...

=code.Qtr_Colour(Fields!Quarter.Value)

Hope that's of interest to you.

99

|||hello,

thank you for your answers. they are both helpful and that exactly what i'm loking for ...

thanks,

rhapsy