I have done this part if directory structure is same install sql server to a new machine stop sql server and copy all the data as it is. Then reboot...

Setting recovery model to simple will not make any difference as it actually logs everything but truncate on every checkpoint. Logging will not be done for for bulk and truncate...

As far as I remember I have done it once copying master and all other database on other server (directory structure remains same) and it works.....Ur approach should work, appriciate...

IS THIS IS WHAT U R LOOKING FOR....

DECLARE

@SQLINDEXTABLENAME VARCHAR (200),

@SQL_STMT NVARCHAR(4000)

SET @SQL_STMT ='SELECT @SQLINDEXTABLENAME = NAME FROM SYSOBJECTS WHERE ID = 5;

'

EXEC SP_EXECUTESQL @SQL_STMT, N'@SQLINDEXTABLENAME VARCHAR(200) OUTPUT', @SQLINDEXTABLENAME...

Shot in the dark...........

When you see that query is taking more than 2 seconds run sp_who and sp_lock and see what for query is waiting!!!!!!!!

Cheers..Prakash

Prakash

Thanks racosta

This is a major decision to be taken by me.... just wanted to confirm again that if i capture the profiler trace from production and run that onto test...

Can you detail how the temp tables is used by all users?

is it the same way all the users are accessing the temp table?

When you see locks at that...

If database is quite old and no rebuild index is done then it's possible.....because of logical and external fragmentation.

Check dbcc showcontig for that table if scan density is not nearing...

I know this is not what you are looking for....

I prefer to use errorhandler to solve this and it works for me always as in errorhandler i am raising...

well if you are taking backup from em than on backup dialog box select options tab and click on "remove inactive entries from transaction log" anyway default for this option...

Profilor is a very costly operation, I am using a different method to get which batch of the code is running.....

I actuallty take the output from sp_lock and convert this...

This is another approach to do.....

IF EXISTS(SELECT * FROM ABCDE..SYSCOLUMNS WHERE ID = OBJECT_ID('ABCDE.DBO.DIM_ALLOCATED_COST') AND COLSTAT = 1)

SET IDENTITY_INSERT ABCDE.DBO.DIM_ALLOCATED_COST ON

GO

INSERT INTO ABCDE.DBO.DIM_ALLOCATED_COST...

Can you provode more info on what you are trying? This is a very open ended question

Prakash

Can you provode more info on what you are trying? This is a very ope ended question

Prakash

you can execute fuction with the ado.connection object the same way you fire a select statement

Cheers,

Prakash