Viewing 4 posts - 1 through 4 (of 4 total)
Please look for this script in correponding folder and check file content.
SQL Server 2000 often build bad scripts if article filter has complex condition
and article shapshoot is reinitialized...
February 13, 2004 at 3:51 am
Sorry, try
ALTER DATABASE DBName
MODIFY FILE (name=DBName_Log, size=IncreasedSizeInMB)
and then
DBCC SHRINKFILE (2, DesiredSizeInMB)
February 11, 2004 at 5:02 am
Try ALTER DATABASE MODIFY FILE (name=_Log, size=) and then
February 11, 2004 at 4:58 am
May be you need to check execution plans. I suppose that for fast example it was build better execution plan because SQL Server has real values of parameters during building...
January 16, 2004 at 4:50 am
Viewing 4 posts - 1 through 4 (of 4 total)