Restore SSP || Create SSP with Backup|| Create SSP with Full customization again
Friends, Life is not easy and every time we cannot create a fresh/new server, environment or a new configuration. What...
2013-02-12
750 reads
Friends, Life is not easy and every time we cannot create a fresh/new server, environment or a new configuration. What...
2013-02-12
750 reads
Friends, As covered in one of my previous blog:
How crawl works in SharePoint ||How indexing work||Basic concept .
We were...
2013-01-28
1,238 reads
Yesterday I was working with my team mates and their came a requirement to create a site collection but with...
2013-01-21
1,132 reads
Hey Friends,
Let’s today discuss on the topic How search works. We have already discussed the crawling concept in previous blog:
How...
2013-01-14
687 reads
Thank You all for your support to give me inspiration . It is the result of this that I have achieved...
2013-01-09
438 reads
Hey Friends,
Today I am here with some concept task . How a search work in SharePoint, but for a search to...
2013-01-08
563 reads
New Year begins,
Let us pray that it will be a year with new peace, new happiness and abundance of new...
2012-12-31
1,027 reads
Hey Friends,
Sometime we may feel the need to move SharePoint site collection to new content db. Below step can be...
2012-12-11
954 reads
Hey Friends,
Sometime when we build a new SharePoint site or site collection. We may feel to create in a new...
2012-12-04
378 reads
Hey Friends,
Sometime when we try to access central administration and certain tabs like operation and Application management we face issues....
2012-11-26
490 reads
By Steve Jones
Fear is fueled by a lack of imagination. The antidote to fear is not...
The slidedeck and the SQL scripts for the session Indexing for Dummies can be...
By Chris Yates
Change is not a disruption in technology; it is the rhythm. New frameworks appear,...
Comments posted to this topic are about the item Building AI Governance and Policies-...
Why is sql doing a full scan VS seeking on the index? I've included...
We have a report that has multiple tables that list the top 15 performers...
The DBCC CHECKIDENT command is used when working with identity values. I have a table with 10 rows in it that looks like this:
TravelLogID CityID StartDate EndDate 1 1 2025-01-11 2025-01-16 2 2 2025-01-11 2025-01-16 3 3 2025-01-11 2025-01-16 4 4 2025-01-11 2025-01-16 5 5 2025-01-11 2025-01-16 6 6 2025-01-11 2025-01-16 7 7 2025-01-11 2025-01-16 8 8 2025-01-11 2025-01-16 9 9 2025-01-11 2025-01-16 10 10 2025-01-11 2025-01-16The docs for DBCC CHECKIDENT say this if I run with only the table parameter: "If the current identity value for a table is less than the maximum identity value stored in the identity column, it is reset using the maximum value in the identity column. " I run this code:
DELETE dbo.TravelLog WHERE TravelLogID >= 9 GO DBCC CHECKIDENT(TravelLog, RESEED) GO INSERT dbo.TravelLog ( CityID, StartDate, EndDate ) VALUES (4, '2025-09-14', '2025-09-17') GOWhat is the identity value for the new row inserted by the insert statement above? See possible answers