To fix #SQL #error 11730, you need to use a three part name as "SequenceTest.[dbo].[Seq_Sample]". See how it works below;
USE tempdb
GO
CREATE TABLE dbo.tbl_sample
(
[ID] int,
[Name] varchar(100)
)
GO
INSERT INTO tbl_sample
VALUES (NEXT VALUE FOR SequenceTest.[dbo].[Seq_Sample],’sqlwork’)
GO
More Info >>
https://ibmimedia.com/blog/91/solve-sql-error-msg-11730
