locked
Message RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Can you help me to understand the message ?

    Msg 117, Level 15, State 1, Line 527
The object name 'tempdb..tempdb..#table98E6C6F0x5172x44A6xB93Fx21994202966' contains more than the maximum number of prefixes. The maximum is 3.

    Sunday, June 28, 2015 10:14 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    In you SQL just write database name as prefix 1 time ,I think in your sql you use prefix more then one 

     'tempdb..tempdb..#table98E6C6F0x5172x44A6xB93Fx21994202966' c

    it should be 

     'tempdb..#table98E6C6F0x5172x44A6xB93Fx21994202966'

    Ahsan Kabir Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread. http://www.aktechforum.blogspot.com/

    • Marked as answer by Caladiya Sunday, June 28, 2015 10:48 PM
    Sunday, June 28, 2015 10:37 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    In you SQL just write database name as prefix 1 time ,I think in your sql you use prefix more then one 

     'tempdb..tempdb..#table98E6C6F0x5172x44A6xB93Fx21994202966' c

    it should be 

     'tempdb..#table98E6C6F0x5172x44A6xB93Fx21994202966'

    Ahsan Kabir Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread. http://www.aktechforum.blogspot.com/

    • Marked as answer by Caladiya Sunday, June 28, 2015 10:48 PM
    Sunday, June 28, 2015 10:37 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Use database name once temdb.dbo.tablename
    Sunday, June 28, 2015 10:52 PM