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 ?
Showing posts with label related. Show all posts
Showing posts with label related. Show all posts
Friday, March 23, 2012
reset next identity value
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
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
Subscribe to:
Posts (Atom)