Thanks

Isn't a bit stupid the difference between Personal Edition and the next better version

and there is no other version in between (to have a better performance) than the Personal Edition)?

We...

Hi

I don't want to spend 4100 GBP but if you have limitations on the performance?

You agree with me that Standard Edition doesn't run on Windows 2000 Proffessional, right?

So we choose...

Hi

We are running Personal Edition of SQL 2000 on a Windows 2000 Operating System.

In the meantime we moved on to Windows XP Proffessional.

Sometimes we get the message:

'This SQL Server...

We use only simple recovery mode and will your proposal work for this mode too? I suppose so.

Thanks

mipo

Yes I tried with dbcc shrinkfile and it actually shrinks it but you have to do it several time to get it to an appropriate size.

mipo

I want to add something regarding this topic.

If I run the following query:

use Madison

DBCC SHRINKFILE ('opms_Data', XXXX)

where XXXX stands for the next reachable file size which is calculated as...

Could you give me more details about how handled your problem and how you created the clustered index etc.

Thanks mipo

I do have text in one file only (madison_data.mdf) and I run the following

query and unused space came extremely down but file size remains around 4,5GB:

USE MADISON

DBCC SHRINKFILE('MADISON_DATA',EMPTYFILE)

I checked...

Thanks but If you have no return values the sysdatabases still have the last value stored and therefore it will be executed.

Is there another work around in this construct:

SELECT @Year...

This worked by putting the quotes like:

Where TableName = ''' + @TableToBeCleaned + ''' and sYear etc.

Thanks

mipo

Thanks for the input.

My concern is really the unused space and how it will be released.

We run several times the script:

EXEC sp_msforeachtable 'DBCC DBREINDEX (''?'')'

DBCC SHRINKDATABASE ('MADISON')

DBCC UPDATEUSAGE ('MADISON')

and...

Thanks for your extensive information regarding shrinking databases.

May I pose a general question:

I am wondering how people maintain their SQL Servers which run at several customers sites and disk space...

Thanks for all the information from you guys

mipo

Thanks for your help. If running statement below I get a syntax error but cannot find out which one. Someone has an idea?

declare @sql varchar(1000)

select @sql...

Thanks for that tip.

Could you give me more details about how to do that or you have an example available?

mipo