Thanks to all of you for support.

noeld, I will try and maintain with your suggestion but at this point I don't know how will I proceed, I was just gathering...

Hi all,

I agree with noeld about no 100% gurantee, specially during upgrade etc... but upgrade will be planned outage, I was trying to achieve here is maximum availability due to...

Thanks Mark,

I am using function now but it is slow for latger records.

That's why I was looking to have this via view, I guess I am expecting too much from...

Thanks Steve for the reply,

I was looking for a code like create view etc.... similar to what is used in create proc and then we write paramaters shich will...

Hi Killer,

migration work bench may not be solution for me as I aill be running DTS everyday as schedule job.

But the link you have posted looks promising, I will walk...

Thanks all,

I tried Rookie's method selecting column in the end of the query, no luck.

I will try out Addict's suggestion sometime today as our internet is down for 2 days.

I...