Developer Forum

Hi,

I am having table with text column which holds table creation scripts whose
lenght exceeding 8000 charactres..Is there is anyway i can take this value
one by one and execute it dynamically in another db..

Logig should be as follows..

cursor for select text from table

for each value

exec 'text value'

end

deallocate cursor..

Regards
rect

Yes, you can pull off pieces of a text field using the TextPTR function...
Search for this in Books on line and there are some examples...

--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, C *** te, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org



whose