@@IDENTITY Issues With SQL2000 On GoDaddy

Okay... GoDaddy's driving me nuts!!!  Anyone... please help.

I am doing an insert into a database with:

INSERT blah blah blah; SELECT @@IDENTITY;

On EVERY OTHER SERVER I have tried this on (local SQLExpress 2005's and my companies various SQL2000 servers, this always returns for me the row number (of autoIndex number of the row just added to the database).  My autoIndex was created with the following code:

ALTER TABLE sites ADD autoIndex INT NOT NULL IDENTITY (1,1)  PRIMARY KEY

The code I have tried getting the identity with is:

cmd.CommandText = "INSERT blah blah; SELECT @@IDENTITY;";

string autoIndex = Convert.ToString(cmd.ExecuteScalar());

cmd.Dispose();

I also tried:

// bulding of SQL INSERT here

cmd.ExecuteNonQuery();

cmd.Dispose();

cmd = new SqlCommand(SQLDataSource_pics.SelectCommand, conn);

cmd.CommandType = CommandType.Text;

cmd.CommandText = "SELECT @@IDENTITY;";

string autoIndex = Convert.ToString(cmd.ExecuteScalar());

Session.Add("autoIndex", autoIndex);

Most of the time, I get a value of "0" (zero) for autoIndex.  Every now an then (5%) of the time I get back a correct value.

 

I don't know where to go from here.

 

Thank you.

Hayedid