Nice example.

... 2) The maximum number of levels is 100. This is the limitation of T-SQL. ...

This is not correct! It is the default recursion limit.

Values: 0 - 32767

You can...

I think you can set the front end field property to accept 0 decimals. :hehe:

This way it will not allow decimals.

- http://www.davidemauri.it/DasBlog/CategoryView,category,Sql%20Server%202005.aspx

CREATE view [V_partitioned_objects]

as

select distinct

p.[object_id],

index_name = i.[name],

index_type_desc = i.type_desc,

partition_scheme = ps.[name],

data_space_id = ps.data_space_id,

...

- I think you should post in sql2005 (sys.sysusers)

- be carefull with users being actual dbowner !

- be carefull with users owning objects in databases

- Indeed you need to handle...

With SQL2005 you can use server ddl triggers to detect / intercept those kind of actions.

1) if you still have the builtin/administrators local windows group in your sqlserver's logins list, one can become sqlserver sysadmin by being added to the windows local administrators group.

2) I...

hehe, nice to see that the code html-tag does its work in the forums.:w00t:

This is the query I start with: 🙂

SELECT dmv_cntr.[object_name]

, dmv_cntr.counter_name

, dmv_cntr.instance_name

, dmv_cntr.cntr_value

, dmv_cntr.cntr_type

, CASE dmv_cntr.cntr_type

WHEN 537003264 -- This counter is expressed as a ratio and requires calculation. (Sql2005)

THEN CONVERT(FLOAT,dmv_cntr.cntr_value) /coalesce(RatioBaseValue.cntr_RatioBaseValue,-1)

ELSE...

Did you have a look at SQLH2 ?

- http://www.sqlservercentral.com/Authors/Articles/Kathi_Kellenberger/43147/

- http://www.sqlservercentral.com/articles/Product+Reviews/sqlh2thefreehealthhistoryandperformancemonitoringt/1800/

- Indeed performance_dashboard is a great resource.

- http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=65&messageid=107424 has more info regarding the pct calculation.

select cast(yourcolumn as char(10)) as yourchar10

from ...

Their data can be in a single table.

Provide a view for each of them, but create the view "WITH CHECK OPTION", so they can only modify data that fits into...

- first of all start with making a full database backup

- you state it only contains 4Mb of actual data.... How long is it in use ?

- how much...

for the SSCM (config manager) you'd have to connect to the physical box on which sqlsever is installed. (authority ?)

You could use :

- start\run Services.msc and start your sqlsever service overthere.

- Or use the SQL Server Configuration Manager, but I don't know it that accompanies SQLExpress. :blush: