Best Practice Database Owner 'sa' SQL Server 2005

I known in SQL Server 2000 it's MS best practice to create database owner as
'sa'.
Is this still the case using SQL Server 2005?I prefer to have sa as owner of the databases. That way, I have a known SID for the owner, and that
sid exists on any SQL Server I chose to restore that database.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Joe P." <Joe P.@.discussions.microsoft.com> wrote in message
news:C564C628-DA50-41D7-9C5B-2982058BD226@.microsoft.com...
> I known in SQL Server 2000 it's MS best practice to create database owner as
> 'sa'.
> Is this still the case using SQL Server 2005?
>|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uZ3Qkzz4GHA.4976@.TK2MSFTNGP06.phx.gbl...
>I prefer to have sa as owner of the databases. That way, I have a known SID
>for the owner, and that sid exists on any SQL Server I chose to restore
>that database.
>
Ditto. And the SA login should be disabled, even if you aren't running in
Windows Authentication mode.
David|||And especially even if you ARE running in Windows Authentication mode.
;-)
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:u1A4d9z4GHA.1256@.TK2MSFTNGP04.phx.gbl...
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:uZ3Qkzz4GHA.4976@.TK2MSFTNGP06.phx.gbl...
>>I prefer to have sa as owner of the databases. That way, I have a known
>>SID for the owner, and that sid exists on any SQL Server I chose to
>>restore that database.
> Ditto. And the SA login should be disabled, even if you aren't running in
> Windows Authentication mode.
>
> David

Best Practice Database Owner 'sa' SQL Server 2005

I known in SQL Server 2000 it's MS best practice to create database owner as
'sa'.
Is this still the case using SQL Server 2005?I prefer to have sa as owner of the databases. That way, I have a known SID
for the owner, and that
sid exists on any SQL Server I chose to restore that database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Joe P." <Joe P.@.discussions.microsoft.com> wrote in message
news:C564C628-DA50-41D7-9C5B-2982058BD226@.microsoft.com...
> I known in SQL Server 2000 it's MS best practice to create database owner
as
> 'sa'.
> Is this still the case using SQL Server 2005?
>|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uZ3Qkzz4GHA.4976@.TK2MSFTNGP06.phx.gbl...
>I prefer to have sa as owner of the databases. That way, I have a known SID
>for the owner, and that sid exists on any SQL Server I chose to restore
>that database.
>
Ditto. And the SA login should be disabled, even if you aren't running in
Windows Authentication mode.
David|||And especially even if you ARE running in Windows Authentication mode.
;-)
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:u1A4d9z4GHA.1256@.TK2MSFTNGP04.phx.gbl...
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:uZ3Qkzz4GHA.4976@.TK2MSFTNGP06.phx.gbl...
> Ditto. And the SA login should be disabled, even if you aren't running in
> Windows Authentication mode.
>
> David

Best Practice Database Owner 'sa' SQL Server 2005

I known in SQL Server 2000 it's MS best practice to create database owner as
'sa'.
Is this still the case using SQL Server 2005?
I prefer to have sa as owner of the databases. That way, I have a known SID for the owner, and that
sid exists on any SQL Server I chose to restore that database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Joe P." <Joe P.@.discussions.microsoft.com> wrote in message
news:C564C628-DA50-41D7-9C5B-2982058BD226@.microsoft.com...
> I known in SQL Server 2000 it's MS best practice to create database owner as
> 'sa'.
> Is this still the case using SQL Server 2005?
>
|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uZ3Qkzz4GHA.4976@.TK2MSFTNGP06.phx.gbl...
>I prefer to have sa as owner of the databases. That way, I have a known SID
>for the owner, and that sid exists on any SQL Server I chose to restore
>that database.
>
Ditto. And the SA login should be disabled, even if you aren't running in
Windows Authentication mode.
David
|||And especially even if you ARE running in Windows Authentication mode.
;-)
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:u1A4d9z4GHA.1256@.TK2MSFTNGP04.phx.gbl...
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:uZ3Qkzz4GHA.4976@.TK2MSFTNGP06.phx.gbl...
> Ditto. And the SA login should be disabled, even if you aren't running in
> Windows Authentication mode.
>
> David

Best parctices in SSRS 2000 reports development

Any ideas or known approaches on how to better develop reports. I have
about 30 Crystal Reports based on stored procedures. Now I need to develop
SSRS 2000 reports. What is the best way to achieve this in terms of layout
development? Is there any kind of a style sheet or templates in SSRS 2000 ?
( many reports look alike, and most of them are just tables, with no charts
or any other complicated structures). From what Iâ've known so far ( I
developed quite a few reports in RS), Iâ'd develop it one by one , changing
all color/font settings for each report individually. Is it possible to do
it in a more sophisticated way?
Any response/ideas would be really appreciated
LenaI'd reccomend figuring out how to do this with SQL Server 2005 instead
of SQL Server 2000.
2005 is a very nice product
Lena wrote:
> Any ideas or known approaches on how to better develop reports. I have
> about 30 Crystal Reports based on stored procedures. Now I need to develop
> SSRS 2000 reports. What is the best way to achieve this in terms of layout
> development? Is there any kind of a style sheet or templates in SSRS 2000 ?
> ( many reports look alike, and most of them are just tables, with no charts
> or any other complicated structures). From what I've known so far ( I
> developed quite a few reports in RS), I'd develop it one by one , changing
> all color/font settings for each report individually. Is it possible to do
> it in a more sophisticated way?
> Any response/ideas would be really appreciated
> Lena