script out table definition and data

Is there any free download tool that I could use to script out table
definition along with the data?
There is a tool by vyas but it was not scripting out correctly. I don't mean
to say wrong things about the tool but may be it was "my bad"!!
When I used that tool, it was chopping out some of the characters at the
very end of script lines.
Please let me know if there is any other free tool out there that I could us
e.
ThanksThat was most likely due to the setting of the # of characters returned per
column in Query Analyzer. Change that setting "Tools - Options" and you
will most likely get the desired results. But note you will always be
limited to 8000 bytes per column in SQL 2000 QA.
Andrew J. Kelly SQL MVP
"sqlster" <nospam@.nospam.com> wrote in message
news:14C21109-D426-468A-A321-C28150271812@.microsoft.com...
> Is there any free download tool that I could use to script out table
> definition along with the data?
> There is a tool by vyas but it was not scripting out correctly. I don't
> mean
> to say wrong things about the tool but may be it was "my bad"!!
> When I used that tool, it was chopping out some of the characters at the
> very end of script lines.
> Please let me know if there is any other free tool out there that I could
> use.
> Thanks|||I'm not familiar with the tool but if you're using Query Analyzer to execute
it, you'll need to change the output results setting.
Tools | Options. Click Results tab. Set the Maximum number of characters
per column to 8192 (the max).
Just a thought,
Joe
"sqlster" wrote:

> Is there any free download tool that I could use to script out table
> definition along with the data?
> There is a tool by vyas but it was not scripting out correctly. I don't me
an
> to say wrong things about the tool but may be it was "my bad"!!
> When I used that tool, it was chopping out some of the characters at the
> very end of script lines.
> Please let me know if there is any other free tool out there that I could
use.
> Thanks|||Joe and Andrew,
Thank you very much and it works great.
I knew it was "my bad" !!!
"Joe from WI" wrote:
> I'm not familiar with the tool but if you're using Query Analyzer to execu
te
> it, you'll need to change the output results setting.
> Tools | Options. Click Results tab. Set the Maximum number of characters
> per column to 8192 (the max).
> Just a thought,
> Joe
> "sqlster" wrote:
>