Post reply

Maximum number of Prefixes

  • December 5, 2002 at 6:40 am

    #158395

    I am getting following error on my sp

    "Server: Msg 117, Level 15, State 1, Procedure dbspCalcdbaSpaceDist, Line 77

    The object name 'uszhoit25794.dbspace..dbaSpaceDist.' contains more than the maximum number of prefixes. The maximum is 3."

    There the code at line 77

    insert uszhoit25794.dbspace..dbaSpaceDist.dbaSpaceDist

    select substring( lFileNM, 1, 20),

    ((cast( TotExt as numeric( 10, 4))* 32) / 512),

    ((cast( UsdExt as numeric( 10, 4))* 32) / 512),

    --((cast( TotExt - UsdExt as numeric( 10, 4))* 32) / 512),

    (100 - ( (((cast( UsdExt as numeric( 10, 4))* 32) / 512) * 100 ) / ((cast( TotExt as numeric( 10, 4))* 32) / 512))),

    @db,

    'Data',

    getdate()

    from #dataspace

    Any idea?

    Thanks

  • December 5, 2002 at 6:50 am

    #443262

    Your table name "uszhoit25794.dbspace..dbaSpaceDist.dbaSpaceDist" contains to many qualifiers. Looks like you are trying to reference a linked server "uszhoit25794", and on that server you are trying to insert records into "dbspace..dbaSpaceDist", but you are reference that table with "dbspace..dbaSpaceDist.dbaSpaceDist". Remove the second "dbaSpaceDist" and see if that works.

  • December 5, 2002 at 6:53 am

    #443263

    Thanks for your help.

Viewing 3 posts - 1 through 2 (of 2 total)

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