Did you create a primary key on this table? If not, are there duplicate rows in this table.

If there are duplicates, are you trying to delete all of them or...

From T-SQL, on SS 2005 you can iterate through your servers in a loop and connect to them and execute a query using OPENROWSET('SQLNCLI'

OPENROWSET('SQLNCLI','Server=myserver;Trusted_Connection=yes;','SELECT ...')

However, there are third party tools...

Alen cappelletti (2/21/2008)

I got this table

-----

CREATE TABLE [dbo].[Logs](

[IDLog] [int] IDENTITY(1,1) NOT NULL,

[IDlogGiorno] [int] NOT NULL,

[Date_Time] [datetime] NOT NULL,

[c-Ip] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[cs-Uri-Stem] [varchar](150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[cs-Uri-Query] [varchar](250) COLLATE SQL_Latin1_General_CP1_CI_AS...

restore database databasename with recovery

Regards,

Andras

Hi Harsh,

You should not really worry too much about how data is stored in the database, at the end of the day this is the task of the database management...

On SQL Server 2005:

select physical_name from sys.database_files

for 2000 use dbo.sysfiles

In both cases use the...

avinash repe (2/19/2008)

Yes i am going to re-install SQL SERVER 2005,where reinstalling it ask for collation setting,that you can set.

And i am going to set according to...

Kenneth has an excellent point. Many people disable their foreign keys, and...

Zeev Kazhdan (2/18/2008)

Here it goes; it didn't let me to run the statement with 1,NULL,NULL as you suggested,

but NULL,NULL,'DETAILED' - hope it will be ok. I"ve loaded the result file...

kgache (2/18/2008)

i am quite sure it is a mssql server..

please tell me if i understood correctly

- i have the database on a mssqlserver version 2000

- i go to the properties...

Encapsulate it into an extra select statement:

INSERT INTO Photovoltaic

( PV_site

, PV_state

...

Unfortunately...

Zeev Kazhdan (2/18/2008)

I have a primary key on both tables and I have tried to play with WITH(INDEX()), but nothing changed.

There is no trigger nor constraint...

You can look at the size and growth columns in sys.database_files before and after the reindexing.

Regards,

Andras

Zeev Kazhdan (2/18/2008)

I have a SELECT statement which runs less than 1 sec.

When I try to INSERT this select into real table, nor @table, nor #table it takes between...