Showing posts with label related. Show all posts
Showing posts with label related. Show all posts

Friday, March 23, 2012

reset next identity value

For a set of tables many of which contain FK constraints related to identity
cols in the foreign tables:
When deleting all data (dropping FK constraints first) and then repopulating
data from scripts , how to instruct SS to reset the next identity value to
the identity seed ?TRUNCATE TABLE, or check out DBCC CHECKIDENT (TableName, RESEED)
Roy
On Mon, 27 Feb 2006 17:14:18 -0800, "John A Grandy"
<johnagrandy-at-yahoo-dot-com> wrote:

>For a set of tables many of which contain FK constraints related to identit
y
>cols in the foreign tables:
>When deleting all data (dropping FK constraints first) and then repopulatin
g
>data from scripts , how to instruct SS to reset the next identity value to
>the identity seed ?

Tuesday, February 21, 2012

Repository

Have any one come across practical issues related to repository.
Can we discus plus & minus points of using repository.One issue is the number of environments where you deploy your reports. I'm working in an environment where the reports are deployed to several idependent enviroments and have found very little use for the repository. I guess the repository could be useful if you are working in a single environment

- Jukka