Is there a way of using SET IDENTITY_INSERT tablename ON from an ASP page?

 I want to copy data from a temporary table into a permanent table (which

has an identity column, hence the use of IDENTITY_INSERT).

Dear Jake,

            I think you can execute the SET

IDENTITY_INSERT tablename ON statement by using a

Connection object. Try it.

                                          regards

                                  O.Patanjali Sastry

--- Jake C <jakeone@b...> wrote:

> Is there a way of using SET IDENTITY_INSERT

> tablename ON from an ASP page?

>  I want to copy data from a temporary table into a

> permanent table (which

> has an identity column, hence the use of

> IDENTITY_INSERT).

>