I always it's sqlserver.exe.  My cpu constanstly reaches 100% and caused slowness for my website.

Minh Vu

I really like to know to do the looping.  Can you give me an example?

I don't have any relations on the tables, no insert triggers eithere. My server is good enough.  The think is I insert data from a link server.

insert into [122.23.23.2].ed.dbo.product_inventory

select *...

My goal is to add an identity field so that I instruct my query to insert 1000 record at a time, but I don't know how. Please rescue me.

Thanks,

Minh Vu

text data

I did shrink the db by using dbcc, but the problem was my db did not got shrunk at all.

Minh

Yes, you need to link the server before you can use open query.

Minh

Yes, you can. I just figured out. I needed to put my ip in bracket:

[172.2.24.5].  It worked for me.

Thanks,

Minh

Hi Sushila,

I got

username    table_name

dbo

Another option is detach and attach your db, delete the ldf file, then attach your db.  This will automatically create a new log file.

Hope that help.

Minh

I tried that too, but it is not correct syntax.  I meant something like this.  set @cmd = 'copy F:\data_dump\emer\inventory.txt  @filename'

But like I said, I couldn't put parameter in quotes.

Minh...

Fantastic!

I really appeciate your help!

Minh Vu

Thank you all.

Minh Vu

Thank you so much for all of the input. The only problem I had is sp_msforeachdb. 

When I run sp_msforeachdb myprocedure, the result occurred with the current db that I...

I tried, but if the indexes dropped, the queries run a lot longer that can take 100% of CPU.  Therefore, when I turn on a trace, it even lows down...