May 9, 2011 at 6:21 am
Hi,
We are trying to drop a UDF but we get an error to indicate that this isn’t possible because the UDF is currently marked for replication. There is no replication setup for this DB so we are at a loss as to why this error is occurring. This is on an SQL2005 Standard edition setup.
Upon further investigation we have found that the is_schema_published flag is set to 1 in the sys.objects table and this is what is causing our problem.
Does anyone know where this flag is picked up from and if it can be updated? We have been unable to update it using a DAC when the server is in single user mode.
The backup file this DB was restored from came from a DB with replication setup on it but we have not preserved the replication settings when restoring. Any help would be greatly appreciated.
Thanks,
Simon
May 9, 2011 at 11:15 am
s_osborne2 (5/9/2011)
Hi,We are trying to drop a UDF but we get an error to indicate that this isn’t possible because the UDF is currently marked for replication. There is no replication setup for this DB so we are at a loss as to why this error is occurring. This is on an SQL2005 Standard edition setup.
Upon further investigation we have found that the is_schema_published flag is set to 1 in the sys.objects table and this is what is causing our problem.
Does anyone know where this flag is picked up from and if it can be updated? We have been unable to update it using a DAC when the server is in single user mode.
The backup file this DB was restored from came from a DB with replication setup on it but we have not preserved the replication settings when restoring. Any help would be greatly appreciated.
Thanks,
Simon
Alter it and remove schemabinding.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply