if I am not mistaken, inline functions where there since SQL 2000

I know you have found your solution, but as been asked before why do you want to detach your database?

does it take a long time still if you rerun the delete with the same big TOP

I have used xml before for importing into a table, but as to whether its suitable or not really depends on your particular circumstances which you have not mentioned.

Please put...

what messages are you getting

Jack's method should work, let us know if it doesn't

forgot to say and can you also post the schema for

mytable1.dbo.app_TelephoneDetails

as far as i know it should not affect, but then the log file is making reference to it.

i don't recall having to install iis before installing sql server.

well just...

its all good.

did you install the IIS?

yes, whatever do you get?

for this error to disappear use T2 in the select

Gail, can you post the schema for ZIPUSA

upendramkumar (4/24/2008)

---

Bledu,

I followed your advice & threw in bunch of validations & here is where Im struck at now...

FROM [hqvm03\hqsqlinst05].sdk.dbo.ml B where isnumeric(b.sa_ss) = 1 and b.sa_ss not like '99999%'

WHERE...

try reinstalling your crystal reports.