...

alter table mytable alter column colname int not null;

cheers,

R

create table tutu (fid int)

create nonclustered index ix_tutu_fid on tutu (fid)

sp_helpindex tutu

-- ix_tutu_fidnonclustered located on PRIMARYfid

create unique clustered index ix_tutu_fid on tutu (fid)

WITH (DROP_EXISTING = ON);

sp_helpindex tutu

-- ix_tutu_fidclustered,...

This one works for me if this is what you are looking for, the idea is to create the temporary table before and insert the rows later.

CREATE TABLE #test (val...

...

I would do first a check on these files:

select * from sys.traces

Watch the maximum size of the files which is in MB I think and if everything is...

Hi ..

If you say something like below:

1.set statistics xml on

SELECT top 100* INTO TraceData

FROM ::fn_trace_gettable('D:\TraceInformation.trc', default

set statistics xml off

2.click on result and save the file with sqlplan extension somewhere...

Thank Andras, I will take it in consideration.

R

Thank yo mate but I am more concerned about locks on the table and so on ... I was just doing some tests and it seems the table is locked...