What are the challenges you face when working across database platforms? Take the survey

SQL Search does not seem to check partition schemas and partition functions

GoodersGooders Posts: 7 New member
I am using SQL Search and attempting to find all database objects that reference a specific partition schema. No tables using the relevant partition schema are found. Also the partition schema itself is not shown in the results pane. The only correctly displayed results are those for stored procedures which reference the seached-for partition schema.(using SQL Server 2016) This is the case even after a reindex. Are partition schemas and functions database objects ignored by SQL Search - even when 'All object types' is specified?


Sign In or Register to comment.