I need full path as a filed in first query.please correct first query for this goal.in adition to I run last query but it does not get my goal.

I found this script but It does not return my result:

IF OBJECT_ID('tempdb..#dirtree') IS NOT NULL

DROP TABLE #dirtree;

CREATE TABLE #dirtree

(

id INT identity(1,1),

subdirectory NVARCHAR(260),

...

Thank you sooooooo much for your reply.my problem is solved by your reply.

ok. but main problem is inserting in to archivedepatment from EXEC master.sys.xp_dirtree @Path,0,1;

please give me a query for this.thanks

I need a script to do this. I really have a terrible with this. please help me and give me a query. thanks a lot.

my major problem is inserting in to tables archivedepatment which stores folder and subfolders in order to hierarchical and inserting into rel_archivedepartment_entities which stores files in folders in archivedepartment.

thank you:-)

thank you for following up and your help deare GilaMonster:-)

No unfortunatly.Because every data is important for my customer's company.

I have Backup every day but my data base is increased every moment and I need to whole Data from it.

Thank you for your reply.

In this situation Wich T-Sql command should I run for reparing this data?

thank you for your reply Dear GilaMonster.this is checkDB Output:

Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID...

hi.

how to reach output of checkDB?I post one of error wich was occured.

when I want to delete this row I get this error:

SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:4911282; actual 1:4911010). It occurred during a read of...

hi.

I can select rows from this table except some rows.I can select substrin([column],1,2) but I nedd to retrive whole of this row to disk.