Update document properties on MS site server
Hello,
I hope that this is the right place to ask my question about MS Site Server.
After the migration to new user accounts I want to change the ownership of the documents in our content management system. With this code “Select owner FROM ContentManagement..SCOPE(' ""D:\Inetpub\trnintranet\publishing"" ')Where…. “ it is possible to show all documents from a specific owner.
I tried to make an update statement "update ContentManagement..SCOPE(' ""D:\Inetpub\trnintranet\publishing"" ') set owner = ""EU\RNL20019"" Where ( CONTAINS(owner, '""EU\RNL20023*""') > 0 )” but I continues get the following error:
Microsoft OLE DB Provider for Indexing Service error '80040e14'
Incorrect syntax near 'update'. Expected CREATE, DROP, SELECT, SET. SQLSTATE=42000
Is it possible to make an update statement to perform an update of the owner property? Otherwise the users have to change hundreds of document manually.
Thanks in advance.
T. Postma
