Thank you all for your help

It solved the problem I only starting the service "virtual disk service" and SQL now uses all available memory.

But i don't know what is the...

HI!!

Thank you for your help but I still have the same problem

i verified the lock pages in memory policy and the service account running SQL is there

I look sys.dm_os_process_memory...

all the service account running SQL Server are administrator of the OS

but how can i check the lock pages in memory policy?

Don't worry i know that my english isn't not good

Server 1

OS x86

SQL 2005 x86

RAM 16 G

Server 2

OS x86

SQL 2008 x86

RAM 16 G

In the server 1, in the server properties of...

ok i try to explain the situacion

I have two server with this features

Server 1

64 bits

Windows server 2003 32 bits

SQL SERVER 2005

16 G

Server 2

64 bits

Windows Server 2003 32 bits

SQL SERVER...

sorry for my English but I speak Spanish

I dont get an error message

in another server with the same features, i run a store procedure and the SQL used 2G of...

DECLARE @date DATETIME, @int INTEGER

SET @date = GETDATE()

SET @int = 6

SELECT DATEADD(MONTH, -1*@int, @date) AS past,

@date,

...