Thanks guys,

Matt idea is good but there is no identity column in the table.

I am trying David code and copy data which need to be delete into temp table and...

I am trying to delete records in a batch and it's taking forever. there are 65 million rows in one table and I am deleting based on some condition and...

Thanks buddy,

I like the idea of deleting in a batch in that case transaction log files will not grow.

I cannot use truncate option because there is a condition associated with...

It actually closes the application. Yes, I am trying to modify user Stored Procedure.

I don't think that make any sense to have one DB per user. it means if you have 2000 user , you will create 2000 database on the server.

I think...

Thanks,

I saw the picture on your home page. Looks good but con't access other link on your home page like articles, scripts etc.

Thanks buddy,

I did the same test and also if do following command like

select * from tablename where field1 = '1'

you will get the result .

I think this kind of...

Thanks guys.

That is what I have been telling my DBA friend that we don't need update statistics if we have created new index.

Phil, you did a great job to handle this guy. Very professional.

Phil.. Yes, the text file has more then 65535.

Lee.. I will try to use your script and see if this goes well.

Thanks a lot , you guys are great.

Thanks Kelley. I did install .net Framework. When you install SQL 2005 , it will install .net framework automatically.

Thanks to Rooman for the reply. Sure I will do that and...

It might be some SQL Job that somebody has created which Detach the database for some reason.

when I try to kill the SPID secound time , I am getting following error like ;

SPID 59: transaction rollback in progress. Estimated rollback completion: 100%. Estimated time remaining: 0...

I did register the DLL but when I run the SP it's taking forever.

Thanks for your reply.

How to register dll on the server