implementing blob - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

implementing blob

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-08-19 : 07:49:20

bhanu writes "need to store xml data which will be up to 1gig in our sql server 2000. however problem came when we tryied to store them as text type.

we had refered ....

http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part3/c1161.mspx

and made our tabel to store them in row using ....

EXEC sp_tableoption 'Tbl', 'text in row', 'on'

plz help"

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2005-08-19 : 07:51:37

quote:

need to store xml data which will be up to 1gig in our sql server 2000

Do you think this is a good idea ?

Damian
"A foolish consistency is the hobgoblin of little minds." - Emerson

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources