MSDE not keeping an ALTER modifcation

Hi Everyone,
Today i faced the following issue : An MSDE Database I had been working
on in the morning in order to be able to upgrade our software, with
the statement:
Through Osql :
1)IF ( (SELECT currentSize= (size /128) FROM
PMI_Operations.dbo.sysfiles WHERE groupid = 1) < 200)
2)PRINT 'PMI_Operations under 200Mb'
3)GO
'PMI_Operations under 200Mb'
1)IF ( (SELECT currentSize= (size /128) FROM
PMI_Operations.dbo.sysfiles WHERE groupid = 1) < 200)
2)PRINT 'PMI_Operations under 200Mb...please wait while increasing'
3)ALTER DATABASE [PMI_Operations] MODIFY FILE (NAME =
N'PMI_Operations', SIZE = 200)
'PMI_Operations under 200Mb...please wait while increasing'
1)
It worked fine.
I came back to the box in the afternoon, after rush hour, and did same
test again (
1)IF ( (SELECT currentSize= (size /128) FROM
PMI_Operations.dbo.sysfiles WHERE groupid = 1) < 200)
2)PRINT 'PMI_Operations under 200Mb'
3)GO
expecting it to not display the print message, but it did !! I had to
run the ALTER again.
What could have caused my morning ALTER to be discarded by the
Afternoon ?
Thanks for any help you can bring
Rgards
hi,
Frogbeef wrote:
> expecting it to not display the print message, but it did !! I had to
> run the ALTER again.
> What could have caused my morning ALTER to be discarded by the
> Afternoon ?
do you have a scheduled job to "shrink" databases?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
-- remove DMO to reply