In my case, even you have simple recovery turn on, the log files are sometimes still expanded faster than the trasanctions committed. I do have have shrink the log files...

you can also backup the transaction with truncate or no_log option:

backup log your_db with truncate_only

Minh V.

Thank you all for all of the inputs. I took SSChampion's suggestion and it did work for me. It ran a lot faster by doing that and put...

If I understand correcly, I normally run a query like this assum that I already linked the servers:

select * from tablea

union

select * from [111.11.1.1].db_name.dbo.tablea

union

select * from [111.11.1.2].db_name.dbo.tablea

union

select * from [111.11.1.3].db_name.dbo.tablea

union

select...

I tried to clean up the table because the email list I got from some outside source.

I used the below where clause to eliminate most of the bad...

Thank you so much for all of ex...ex...excellent help.

I'm deeply appreciate them.

It works for me now.

Minh Vu

yes, that is what i'm looking for. I'd like to know how to find them.

Thanks

It did not work for me at all since later I need to pass in parameter for sp_OAsetproperty.  The limit for this system sp is also 8K I guessed.

Anyone has...

Thanks so much for the hint.  Let me try that way to see.

I'm really appreciate your help.

Minh Vu

Yes, the E is my local SQL Server drive that I have in my system.

Thanks,

Minh Vu

Thanks for the input.  I talked to our programmer, they could easily handle that in the code by replacing single quote with double quote.

Thank you so much for all of the helps.

They all worked for my case.

Minh Vu

Thanks so much for all of the help.  It works lovely for me.

Have a great day!

Minh

sorry. That is my typo.  Yet, it is 2005.

Minh Vu

they should have everything except 'Drop table'

Thanks,

Minh Vu