Truncate of table can resolve the problem, might be follow these step to perform this task-

STEP.1 - CREATE TRIGGER on BEFORE INSERT event to get table count and if count=0...

Does it will make any seance to change datatype ntext to NVARCHAR.

Hi Gila,

User already performing shrinkdatabase command and it was not giving proper solution to him that's why he posted the problem so he might have already know the advantage and...

I am completely agree with Gail without creating the Cluster Index you will not be able to release size from table even you will have to REORG the index then...

You can attached database mdf file without ldf file, see example given below:-

sp_attach_single_file_db @dbname='Amber',@physname='S:\AMBERDATAFILE\Amber.mdf'

http://msdn.microsoft.com/en-us/library/ms174385.aspx

Data file can be repaired by DBCC repair command but there is risk of data loss so first take the database backup and also record all table count in excel...

This SQL query will help to find table name and column name in database which column value length is 9.

DECLARE @Tab_Name VARCHAR(500)

DECLARE @Col_Name VARCHAR(500)

DECLARE @SQL NVARCHAR(MAX)

CREATE TABLE #TMP_Details(TabName VARCHAR(500) NOT...

Active-Active Fail-over clustering can be a solution for your requirement.

I hope this link can help you to understand the topic.

http://sqlblog.com/blogs/kalen_delaney/archive/2008/02/28/fragmentation-revisited.aspx

Hi,

I hope this could help you..