Thank you guys for responding to my query, the sample data in this column looks like:

comments;l;comments, more comments

NULL

...

My thinking while writing this question was, if we discuss from a purely database maintainence (and/or performance) perspective, which is better?

I just got hold of this database, and as SCPORICH said I need to re-normalize all these tables too. But till then I needed a work around 🙂

v

this may help,

http://www.sqlmag.com/Forums/messageview.cfm?catid=8&threadid=8135

v

Is there in specific reason Frank, why we should not be using "undocumented" stored procedures in a production environment? Just curious.

SQLBill: I tried setting QUOTED_IDENTIFIER on and off, but it...

looks like I have found a solutions for this problem (or atleast a work around). I tried the following and it worked.

exec sp_MSforeachtable @command1 = ' select col_name,...

thats exactly how it looks like when I type everything together. When I execute I get the following 4 lines of error messages:

Server: Msg 207, Level 16, State 3, Line...

Thank you SQLBill for responding, I would have never found that "undocumented" stored procedure.

I tried executing it, the sp_MSforeachtable runs fines if I am only using select. For example:

...

thank you for all your help, it worked like a charm.

vijju

I am using ActiveState perl Version 5.6.1 (version 635).

thanks,

vijju

I am guessing it may not be the worms floating around because I have changed the sa password as soon as I installed SQL server 2000 (thanks to guys on...

I too have faced the same problem when I tried using Copy Database Wizard. You can try using "Import Data" or "Export Data" wizard. These worked fine with me when...

Alright, I reinstalled SP3 for SQL server 2000. The first un-packaging of the SQL2ksp3.exe didnot work properly. I didnot get any directories in X86. But the second time worked perfectly.

...

Thank you Allen for all you help. I work around something and if this doesnot work then I will probably reinstall SQL server and see if that fixes any of...

I downloaded a fresh copy of SP3 and installed them. But no good. Do you think my SQL server set up is messed up or something??