I would like to ask, what could be wrong with this procedure:
SELECT object_id, index_id, avg_fragmentation_in_percent, page_count
OBJECT_ID('dbo.ad_master'), NULL, NULL, NULL);
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '('.
In my other database server, I just changed the database name and table name, the procedure is working fine.