Failure To Publish An Indexed View Logbased Publication

i am trying to publish an indexed view logbased publication but I'm getting "must be a schema-bound view with at least a clustered index to be published as a log-based indexed view article."

The table has clustered index and the view is schema-bound.



this is the script for schemabinding

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER VIEW [nth].[musictracks1] with schemabinding

AS

SELECT autoid,idtrack,songname,singer,writer,composer,center

FROM nth.musictracks

GO

SET ANSI_NULLS OFF

GO

SET QUOTED_IDENTIFIER OFF

GO



and this is for making the publication an indexed view logbased publication



exec sp_addarticle

@publication = N'lb_publication',

@article = N'musictracks1',

@source_owner = N'nth',

@source_object = N'musictracks1',

@type = N'indexed view logbased',

@description = null,

@creation_script = null,

@pre_creation_cmd = N'none',

@schema_option = 0x0000000008000001,

/* table name doesn€™t have to be the same as view name */

@destination_table = N'musictracks1',

@destination_owner = N'nth'

GO



Any idea what is wrong?



Thanks,

Salah