Adam Bean (4/27/2009)

Good call, run this to verify:

USE [tempdb]

SELECT

[name]

,CONVERT(NUMERIC(10,2),ROUND(/128.,2))AS [Size]

,CONVERT(NUMERIC(10,2),ROUND(FILEPROPERTY([name],'SpaceUsed')/128.,2))AS...

yse only one file.

the results are the nothing happen,it's not...

this article not help me because i already did what is writing there and it's not working.

what else i can do to reduce the data file?(with no sql restart)

THX

this article not help me because i already did what is writing there and it's not working.

what else i can do to reduce the data file?(with no sql restart)

THX

the sql was restart twice after that i enable the AWE and PAE in the boot.ini

when i query the sys.configuration i see that the value = 1 but the value_in_use...

as i mentioned in my first post - the perfmon show me in both total and target server 1.7GB.

yes twice.

can SQL Server 2005 STD 32BIT on Windows Server 2003 ENT 32BIT work with more then 2-3GB mem(the 32bit mem limit)?

THX

i'm pretty sure that this sql needs more then 1.7GB,

beacuse i've more then 100 users connected to this instance with more then 25 DB's on it,and the TRN log that...

hi,

i cannot casting it.

i found the answer to it.

i use the master.dbo.fn_varbintohexstr and it's works good.

THX

so what are my options to resolve this error?

THX

hi,

the sql server 2000 is 32bit but the server that it is running on is definitely 64bit, and according to the post above you i cannot upgrade an sql server...

Thanks to everyone.

it working good.

this post do exactly the opposite.

it remove the last string that i need.

THX

can you help me with that?

Thx.

no the file name is not static but what static is the . and then 3 letters

and before that there is this so we have in the end \test.mdf

i need...