You can do it, by query too...

Strange... very strange....

I know i should not make a shrink, because of all that was written in this post, but i have tried because i'm in the dev. enviroment and...

When the rebuild is finish in the data file , the cppy of the index is eliminated from the datafile?

I understud.

Thank you very much

Thank's for reply.

I understand that.

But in my case, it is not the Log that grow, but the data file.

Why?

thank you

P.s - my database is in simple recovery model, that's why...

thanks

No

I will read it.

What about using BDCC shrink file instead of using the GUI (EM) to shrink the log file?

do i have any benefits of doing it through DBCC instead...

My database as 430 MB in the data file and 10GB in the Log file.

I want to live the database in full recovery model, because i want to be able...

The query in 2000 run in 2 minutes.

In SQL Server 2005 (after i repleace to order by codliq or order by 5) executes but it does not finish.

Can you help...

sorry but i dind't undesrtud... 🙁

ok, thank you very mutch.

I have other question related to the same problem.

I now can run the query, but in SQL Server 2000 this query executes in 2 minutes.

When...

but why does it funtion in SQL Server 2000 and don't work in 2005?

I don't understand why chande from nota..... to 5

Where is the number 5 in my table definition?

thank...

SQL Server 2005 (script produced trought management studio):

table SGTALIQDATA:

USE [SGT]

GO

/****** Object: Table [dbo].[SGTALIQDATA] Script Date: 08/14/2009 13:59:52 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[SGTALIQDATA](

[CODLIQ]...

what do you mean with tables definitions?

The field names and data types?

thank you