I was asked to defrag a table's index. I tried to run DBCC INDEX DEFRAG on
a TABLE OWNED by a user called PD7333. The command didn't like the
DBCC INDEXDEFRAG (JDE_PD7333, PD7333.F98950, F98950_2)
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '.'.
It doesn't like the object owner id. but this command obviously won't work
DBCC INDEXDEFRAG (JDE_PD7333, [F98950], F98950_2)
Server: Msg 2501, Level 16, State 45, Line 1
Could not find a table or object named 'F98950'. Check sysobjects.
DBCC execution completed. If DBCC printed error messages, contact your
I gues I have the option to use the object id for the table, but WHY can't
I use the owner ID in the command?