I dont have sqlsp.log file anywhere on my machine. Is there a chance that it is stored under any other name???

looking at the log file (sqlstp.log) doesnt seem like SP3 is getting installed successfully. Any ideas why??

Hi Allen,

I just now installed the SQL server 2000 SP3. But the select @@version still says Microsoft SQL Server 2000 8.00.194.

Yes Allen, I am still facing the same problem I mentioned earlier. Even after installing MDAC 2.7.

I will install the SQL server 2000 SP 3 right off.

really appreciate for all...

I have Microsoft SQL Server 2000 - 8.00.194, how can I update?

Just now I installed MDAC 2.7 SP1, and ran my Component Checker, guess what...

Hi Allen,

just now checked the version of MDAC Component checker I was using,

Microsoft (R) 2.50.4613.0

Version 5.0 (Build 2195: Service...

Hi Allen,

before installing MDAC 2.6 SP2 I checked the server for existing MDAC using Component Checker utility and it came up saying the closest one I have...

thank you Michale, that helped to do what I wanted to do.

thanks,

Vijju

Thank you anteras, for me the inner join worked perfectly.

really appreciate all your comments guys.

Thanks mromm, I was able fasten the query process. Now i am reading and storing each record from the long list into a tempTable. And then using a sub-query to...

Thank you David, that did the trick. But just out of newbie curiosity, why would SQL restrict the default size to 256 char. only?? Any security problems??

thanks,

Vijju2k

thank you Andy, that works like a charm.

Thank you very much for your immediate help.

Vijju2k

Thanks a lot guys for your valuable suggestions. It helps a lot. I will play around and see how things goes ( and will bug you all if I get...