topic Re: SQL Server Next_RowID Stored Procedure in Data Management Questions

SQL Server Next_RowID Stored Procedure

BrandonCales — Tue, 26 Mar 2013 22:22:07 GMT

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/

Re: SQL Server Next_RowID Stored Procedure

MarcoBoeringa — Wed, 27 Mar 2013 08:02:06 GMT

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.

Re: SQL Server Next_RowID Stored Procedure

JakeSkinner — Wed, 27 Mar 2013 10:13:12 GMT

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.

Re: SQL Server Next_RowID Stored Procedure

BrandonCales — Wed, 27 Mar 2013 12:25:40 GMT

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

Thanks