Post reply

Msg 128, Level 15, State 1, Line 2 The name "sp_resetstatus" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.

  • July 10, 2012 at 10:16 am

    #263669

    The following SQL

    "

    Use FlexFamilyMembership

    PRINT sp_resetstatus 'FlexFamilyMembership'

    ALTER DATABASE FlexFamilyMembership SET EMERGENCY

    DBCC checkdb ('FlexFamilyMembership')

    ALTER DATABASE FlexFamilyMembership SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    DBCC CheckDB ('FlexFamilyMembership',REPAIR_ALLOW_DATA_LOSS)

    ALTER DATABASE FlexFamilyMembership SET MULTI_USER

    "

    This giving error :

    Msg 128, Level 15, State 1, Line 2 The name "sp_resetstatus" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted

    Please give me solution

  • July 10, 2012 at 12:15 pm

    #1511128

    You don't use PRINT before the stored proc. Also, this sp shouldn't be used since it is deprecated. http://msdn.microsoft.com/en-us/library/ms188424.aspx[/code]

    Jared
    CE - Microsoft

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

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