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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment