Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

resetting an ident with a stored procedure that automatically increments it Expand / Collapse
Author
Message
Posted Tuesday, April 6, 2010 10:22 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 12, 2010 3:12 PM
Points: 27, Visits: 36
hi there,

I am updating some dimensions and OLAP cubes in SSIS with a package for each. What is the package does for each is that it executes a stored procedure and used @@IDENT to output the identity into a new table. I wrongly executed a ssis package and now I need to reset the indent back to a specified value. ANy way this can be done?
thanks
Post #898132
Posted Tuesday, April 6, 2010 10:37 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: 2 days ago @ 10:07 PM
Points: 9,926, Visits: 11,183
Link: DBCC CHECKIDENT



Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #898139
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse