Hi
Does anyone know of a way / script to remove all extended properties from
objects within a certain database?
Tia
James
tglThe documented way is to use sp_dropextendedproperty for each property
of each object (which can be found using fn_listextendedproperty).
An undocumented way would be:
DELETE sysproperties
(this may not work in later versions of SQL Server)
Razvan
Showing posts with label extended. Show all posts
Showing posts with label extended. Show all posts
Monday, March 26, 2012
Subscribe to:
Posts (Atom)