that is coool, thanks lowell, I go for CLR.

thanks lowell and Eugene Elutin

BCP: still needs tursted connection, we have many 100s of customer with different authendication, the solution has to work in all situations.

CLR: it function...

i tried Indra freed tool, the tool shows only the servers in local NETWORK. How to add a database server that is not in the same network? pl help.

thanks for the update, i found your query useful.,

thanks GSquared for the quick reply.

I need to search entire db for a Pattern like email address. Any full text or part of text that looks like email address.

thanks perfect: "new column names every night" this will for me.

TodayMinus4 is nice idea but still will not work.

This is my situation.

I have a table [sales] where I had to store the last 30 days of total sales to each...

lowell and rob

thanks for your help. It looks like I am not thinking right. let me think and get back to you. i am not also able to use your...

pl some help me, ...any other idea...what is wrong with my stmt..I get "Incorrect syntax near '+'."

Thanks lot MJ.

Thanks again for the valuable info. it is smiply great useful tools and saved a lot.

Thanks for all your help; I am evaluating RedGate.

thanks melton, great help and queries

thanks for PAL;

thanks you guys, very useful information