- 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:

check the MDAC level of the devices that are not able to connect to your named instance. It should be at least MDAC2.6 at client level.

btw you can download it...

you have to take care : SQLserver may want to try to overwrite the original files at the original locations if you work on the same box. !

I must say...

... One of the main differences, and actually a big advantage, is that a CTE can be referred to repeatedly within the following SQL statement unlike a derived table that...