Message body

1.I went to system configuration,tab boot/advance option,added 2 processors

, is standard for memory maximum is 20480 (always confused with that) should I leave like that?

2. When...

ok, I am in the process of installing,so how can I Leave 2GB for the OS(where do I check for this?)

Thank you

This is I always can't get it right,how much set max memory?

Thank you

Thank you

How can I fix it? why doesn't work in 2008?

Each GROUP BY expression must contain at least one column that is not an outer reference.

go to tables,select keys,add key when i close tables, ask me do you want to save changes, I say no and it is satys there

Is your recomendations to use

"While @@Trancount > 0 Commit"

Thank you

ok, I have a backup from 2008, can I restore in sql 2005?

How can I check if we are using domain account? Also I went to sqlagent properties from componet services it says ( LocalSystemaccount is not checked, but up top it...

No I don't know, so I need your help please,this is my development server,but this is extremly urgent.

Thank you

Where can I go and create a new password for my sql agent?

Thank you

This SQL server 2005

Does that table have a LOB? What is LOB?

Thank you

I ran it

SELECT * FROM sys.dm_os_performance_counters

WHERE counter_name IN ('Total Server Memory (KB)')

but get no results back, but on my other server I got results.

What is the reason?