thks all, i suggested NVACHAR for xml type values is it ok?

thank for your replay.i am looking for inbuild function or any other way to view my data with out this type of conversion.because our development team is desire to retrive...

Dear opc.three,

sorry, my result same as your result. I need with out change as '<tst>1>0</tst>'

thanks gsc_dba

we need scripts or any procedure with out third part software.

table structure please

use sp_executesql it will help you.

hi

post error from errorlog or application for detailed reference.

can you tell me the registry setting for below entry and its values?

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI

i have met the same problem. try below steps

* Uninstall oracle client

* restart and delete the existing oracle folder like("app")

and update the server patch then reinstall oracle client.

i want...

thanks bipan

source of the backupfile is live server.

i will try.. for the dos script.

thanks bipan

hi

My case is a folder contain n files ,file count is not fixed and also n different db backup,some times 10 or 1 or 2 file may be there. what...

thanks to all,

here each bak file are different database for ex.

1. testdb.bak for testdb

2. storedb.bak for storedb

3. silksdb.bak for silksdb ..etc

all these should be restored. how can i read...

sorroy that table contains 50 thousand rows.

that table contains 50 rows around 1.5mb.

we need better solution.