Hi All ,

I sorted this out by executing this statement :
DBCC SHRINKFILE (1, TRUNCATEONLY);

cheers

By the way... when you buy sql license which value that you look at in order to determine the number of users ?

Thanks for the reply guys . really appreciate it !
Anyone knows how to get the license cost information ?

thanks guys ..will try !

Hi Alex

Many thanks for the valuable feedback , It believe it will be very useful

I will use witness server to act as DISTRIBUTOR then

Questions :

1.Should it install with...

Hi All,

Anyone can give me the idea how to deal with this please?

Really appreciated

Cheers

sync and no mirror

Thanks for the reply . Much appreciated

I feel It has nothing to do with rebuilt index as I have just rebuilt all indexes in that database and still can’t...

Thanks for the reply . Much appreciated .

Only 1 filegroup which is primary and 1 data file

The result of your query is as below ( I cut some information but...

Thanks for the reply . Much appreciated

No message because when I right click on that db and choose Shrink -> data file . It shows up a shrink file...

Thanks for the feedback . Much appreciated

It is very cheap ! Can you show me the link about the price / product information ?

Many thanks

Thanks for the feedback

It has been sorted out , the cause is the service account in witness should be the same with the one that I use in principal and...