Hi Patrick,

I just tested with VFP8 and SQL 2000 and it works fine. How do you know that it doesn't work for you? Keep in mind, that INSERT for table with SET IDENTITY_INSERT ON should include a list off columns to insert into or it'll fail.

>Hi everybody!
>I'd like to do something like
>? SQLEXEC(lnHandle,"SET IDENTITY_INSERT dbo.Auftrag ON")
>
>This returns 1, but unfortunately does not change the IDENTITY_INSERT-Setting of my Sql Server.
>
>Is there an other way or solution?
>