This may help.

Analyzing Memory Requirements for SQL Server

http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/analyzingmemoryrequirementsforsqlserver/2498/#

rbarryyoung (7/8/2008)

---

Actually, it is not valid to exclude 'dbo' here. If a Login owns a database, then they are user 'dbo' in the database and they own all of...

Worked out a version for all databases (SQL2000).

-- List all objects owned by any user(s) other than DBO.

DECLARE @sql VARCHAR(500)

SELECT @sql =...

Thank you Perry.

I modified a little.

select user_name(uid) as user_name, name

from sysobjects

where user_name(uid) <> 'dbo' and user_name(uid) <> 'sys'

order by user_name, name

Thank you RBarryYoung. But still have errors.

Msg 156, Level 15, State 1, Line 2

Incorrect syntax near the keyword 'User'.

....

Try Idera SQLpermissions tool.

http://www.sqlservercentral.com/Forums/Topic483265-146-1.aspx

I think MVP is more valuable than the certificate. Not saying that certificate is not good. It is a helpful learning path.

Congratulations Gail! I just read Steve's...

Just read this post today. Are you still looking for the course?

http://www.cmstraining.ca/CourseDetails.aspx?CourseId=56&Product=SCOM

Implementing Operations Manager (SCOM 2007)

July 16 - 18

September 03 - 05

I heard that the instructor is...

Strongly agree. These traits are very...

Two more:

1. "SQL Server clustering best practices" By Hilary Cotter with Geoff Hiten

http://searchsqlserver.techtarget.com/

2. SQL Server Consolidation on the 64-Bit Platform, Lessons Learned

http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/64bitconsolidation.mspx

Category 2: DBA Best Practice Specific to Clustered Instance.

--> make SQL/MSDTC/Cluster Service seperate groups.

Finally use OSQL -SserverN -E -iMyinput.sql to loop through all my servers and append the output to the same output file, then load the file to a table.

Congratulations to both of you.

I am really impressed by Jeff’s posts. Seems nothing he cannot resolve. When I post my question, I wish Jeff could read...

andrewkane17 (6/26/2008)

---

Check this series of articles out, he shows how to dynamically connect to N number of servers, you simple populate a servername table to be used by an ADO...

This may...