SQL Server Next_RowID Stored Procedure

[BrandonCales]

I'm trying to execute the next_rowid stored procedure based on the ArcGIS help, however SQL 'Could not find stored procedure 'dbo.next_rowid''

Anyone know where I can find the script to create the stored procedure?


http://resources.arcgis.com/en/help/main/10.1/index.html#/in_SQL_Server/006z00000017000000/

[MarcoBoeringa]

What version of ArcGIS / ArcSDE are you using? Support for SQL is a new thing in 10 and extended in 10.1. It may be that the stored procedure you are trying to use does not exist in your geodatabase until a future upgrade to 10.1. Please note that an upgrade of an existing geodatabase is a separate operation from upgrading your client PC's ArcGIS for Desktop application. You may be running ArcGIS 10.1 locally, but still be connecting to a 10.0 or 9.3.1 geodatabase not having this stored procedure.

By the way, I would like to strongly discourage you to tamper with any of the stored procedures or geodatabase system tables using SQL. Unless you are a true expert geodatabase administrator, there is a high chance of wrecking your geodatabase.

[JakeSkinner]

Hi Brandon,

If you created your geodatabase with an SDE schema, the stored procedure will be owned by the SDE user.  Instead of dbo.next_rowid, try sde.next_rowid.

[BrandonCales]

You are correct. I was running this on my 9 box, but I checked my 10.1 test box and it's there.

Thanks