Post reply

dbcc checkdb shows mystery files

  • November 12, 2003 at 9:18 am

    #59503

    when I run dbcc checkdb the report indicates 9000 rows in c:\temp\sales.txt. However this file does not exist when I look thru windows explorer.

    Any ideas why this shows up?

  • November 12, 2003 at 1:29 pm

    #481770

    What version of sql server

    Mike

  • November 12, 2003 at 4:35 pm

    #481788

    Can you post the actual output

  • November 13, 2003 at 2:18 am

    #481803

    sql2000

    here's the relevent real output.

    ......

    DBCC results for 'waste_packing_types'.

    There are 6 rows in 1 pages for object 'waste_packing_types'.

    DBCC results for 'c:\temp\sales.txt'.

    There are 3616448 rows in 59390 pages for object 'c:\temp\sales.txt'.

    DBCC results for 'LCPSales Data'.

    There are 846540 rows in 13336 pages for object 'LCPSales Data'. ..........

  • November 13, 2003 at 2:38 am

    #481806

    Someone's created a table called "c:\temp\sales.txt". It's just an object in your database with an operating-system-like name. It can be done like:

    

    create table [c:\temp\sales.txt]

    ( x int)

    Cheers,

    - Mark


    Cheers,
    - Mark

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply