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.
Message
June 28th, 2015 6:16pm
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'
Free Windows Admin Tool Kit Click here and download it now
June 28th, 2015 6:39pm
Use database name once temdb.dbo.tablename
June 28th, 2015 6:54pm
This topic is archived. No further replies will be accepted.
Other recent topics
