Administrating SQL

Folks,
I am looking a way to better manage my SQL Server environment. Here are my
requirements
1 I need to know used, free and availabe space
2 Utilization of memory and other SQL Server 2000 related resources whether
on weekly average (for example) it's good
3 System spec that running the server.
I can do some kind of scripting to dump everything on one webpage that list
the above info but i would like to find out whether there is already any tool
availabe to ease my administration.
Protype of the display should be something like this
Srv Name Ver RAM(Threshold 2G) Diskspace(threshold 30%) Total Hits(max 300)
A 80.760 1G(Good) 25G out of 50G
235 (good)
Thank you
rupart
Start with
http://www.sql-server-performance.com
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:D717B8B5-26B0-4320-BC33-9075FF689AA6@.microsoft.com...
> Folks,
> I am looking a way to better manage my SQL Server environment. Here are my
> requirements
> 1 I need to know used, free and availabe space
> 2 Utilization of memory and other SQL Server 2000 related resources
whether
> on weekly average (for example) it's good
> 3 System spec that running the server.
> I can do some kind of scripting to dump everything on one webpage that
list
> the above info but i would like to find out whether there is already any
tool
> availabe to ease my administration.
> Protype of the display should be something like this
> Srv Name Ver RAM(Threshold 2G) Diskspace(threshold 30%) Total Hits(max
300)
> A 80.760 1G(Good) 25G out of 50G
> 235 (good)
> Thank you

Administrating SQL

Folks,
I am looking a way to better manage my SQL Server environment. Here are my
requirements
1 I need to know used, free and availabe space
2 Utilization of memory and other SQL Server 2000 related resources whether
on weekly average (for example) it's good
3 System spec that running the server.
I can do some kind of scripting to dump everything on one webpage that list
the above info but i would like to find out whether there is already any too
l
availabe to ease my administration.
Protype of the display should be something like this
Srv Name Ver RAM(Threshold 2G) Diskspace(threshold 30%) Total Hits(max 300)
A 80.760 1G(Good) 25G out of 50G
235 (good)
Thank yourupart
Start with
http://www.sql-server-performance.com
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:D717B8B5-26B0-4320-BC33-9075FF689AA6@.microsoft.com...
> Folks,
> I am looking a way to better manage my SQL Server environment. Here are my
> requirements
> 1 I need to know used, free and availabe space
> 2 Utilization of memory and other SQL Server 2000 related resources
whether
> on weekly average (for example) it's good
> 3 System spec that running the server.
> I can do some kind of scripting to dump everything on one webpage that
list
> the above info but i would like to find out whether there is already any
tool
> availabe to ease my administration.
> Protype of the display should be something like this
> Srv Name Ver RAM(Threshold 2G) Diskspace(threshold 30%) Total Hits(max
300)
> A 80.760 1G(Good) 25G out of 50G
> 235 (good)
> Thank you

Administrating SQL

Folks,
I am looking a way to better manage my SQL Server environment. Here are my
requirements
1 I need to know used, free and availabe space
2 Utilization of memory and other SQL Server 2000 related resources whether
on weekly average (for example) it's good
3 System spec that running the server.
I can do some kind of scripting to dump everything on one webpage that list
the above info but i would like to find out whether there is already any tool
availabe to ease my administration.
Protype of the display should be something like this
Srv Name Ver RAM(Threshold 2G) Diskspace(threshold 30%) Total Hits(max 300)
A 80.760 1G(Good) 25G out of 50G
235 (good)
Thank yourupart
Start with
http://www.sql-server-performance.com
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:D717B8B5-26B0-4320-BC33-9075FF689AA6@.microsoft.com...
> Folks,
> I am looking a way to better manage my SQL Server environment. Here are my
> requirements
> 1 I need to know used, free and availabe space
> 2 Utilization of memory and other SQL Server 2000 related resources
whether
> on weekly average (for example) it's good
> 3 System spec that running the server.
> I can do some kind of scripting to dump everything on one webpage that
list
> the above info but i would like to find out whether there is already any
tool
> availabe to ease my administration.
> Protype of the display should be something like this
> Srv Name Ver RAM(Threshold 2G) Diskspace(threshold 30%) Total Hits(max
300)
> A 80.760 1G(Good) 25G out of 50G
> 235 (good)
> Thank you

Administrating roles on several databases and cubes ?

Anyone know of somekind of tool, where you easy can administrate userroles on several databases and cubes ?

No. I would appreciate a product that could do that. Roles are related to solutions/databases not across solutions/databases.

When Active Directoryn was introduced in Windows 2000 my naive idea was that each application would build its security repository around AD. This is not the case nore for MS-products.

Regards

Thomas Ivarsson

Administrating content with integrated security?

I have a two tier application with a .net client that access data from a SQL
Server. Depending on what windows user group the user belong to I want them
to get different data. The solution I would like to have is one where a could
change only in the database and nothing in the client and still get different
users to get different data.
There is only one table that should differ for different the users. One
solution would therefore be to overload the table, i.e. create one table for
each user all with the same name but with different owners. Because the
client doesn't explicitly state the owner of the object it would get the
table owned by the user running the client.
This solution would lead to far to many identical copies of the table and
for each new user at the company you would have to create a new table on the
server. A better solution would be if it were possible to connect tables to
server roles and if the client would get access the table that is connected
to the server role that the user belongs to. To me, it seems this solution is
not possible because SQL Server will identify the table with the user and
never try with the role.
Regards,
Joeluse a trigger or a view on the table to match the user with a column to
select only the rows that pertain to them (current_user)
"Joel" <Joel@.discussions.microsoft.com> wrote in message
news:64B7A8C1-FF4A-4CF4-B3B7-8BE713D61E68@.microsoft.com...
>I have a two tier application with a .net client that access data from a
>SQL
> Server. Depending on what windows user group the user belong to I want
> them
> to get different data. The solution I would like to have is one where a
> could
> change only in the database and nothing in the client and still get
> different
> users to get different data.
> There is only one table that should differ for different the users. One
> solution would therefore be to overload the table, i.e. create one table
> for
> each user all with the same name but with different owners. Because the
> client doesn't explicitly state the owner of the object it would get the
> table owned by the user running the client.
> This solution would lead to far to many identical copies of the table and
> for each new user at the company you would have to create a new table on
> the
> server. A better solution would be if it were possible to connect tables
> to
> server roles and if the client would get access the table that is
> connected
> to the server role that the user belongs to. To me, it seems this solution
> is
> not possible because SQL Server will identify the table with the user and
> never try with the role.
> Regards,
> Joel