See solution from http://support.microsoft.com/default.aspx?scid=kb;en-us;322140

From BOL.

"Permissions

TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and are not transferable."

Thanks both.

No aware of that but definately don't use to stop/start clustered virtual SQL Server.

http://www.lumigent.com

Use performance monitor or select from sysperfinfo for accurate memory usage.

It is cluster aware. You have to install it for each instances. Make sure you have sp3 or sp3a installed prior applying it.

Edited by - allen_cui on 08/13/2003 1:49:36...

Which secuirty patch?

See solution from http://support.microsoft.com/default.aspx?scid=kb;en-us;154628

Any error messages in application/system logs? Do you removed BUILTIN\Administrators login from SQL Server? Is the account which is used for setuping windows 2000 cluster be granted to access SQL...

Quoted from BOL.

"Error 1204

Severity Level 19

Message Text

The SQL Server cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users or ask the system...

How large are your databases in size? As Larry said, SQL Server will allocate the memory when it needs. You may wait to go back to check the usage after...

set nocount on

create table ##cluster(outputinfo varchar(255))

insert into ##cluster

exec xp_cmdshell 'cluster /cluster:w2kclus1 group'

select * from ##cluster where outputinfo like '%yoursqlservergroupname%'

drop table ##cluster

Can you ping the server? Try to access with IP address.

You have to enable 'AWE' in SQL Server to use memoery that is beyond 4GB.