Assigning new auto increment value I have a table that is created as below.

CREATE TABLE [dbo].[Table1](
    [ID] [INT] IDENTITY(1,1) NOT NULL,
    [Title] [VARCHAR](255) NULL,
    ...


Lets say that the latest ID is 100 ( I have 100 records)

Is there a way to ALTER this table's IDENTITY column and change the auto increment value to now be 500?

So at the end i would have something like this 
ID 98, 99, 100, 500, 501, ....

I can not seem to find a solution for this in T-SQL
You can use DBCC CHECKIDENT to reseed the IDENTITY column.

Here is a sample you can run:

SET NOCOUNT ON;
USE tempdb;
GO

CREATE TABLE dbo.foo(ID INT IDENTITY(1,1));
GO

INSERT dbo.foo DEFAULT VALUES;
GO 100

-- note: set it to ([the next value you want] - 1)
DBCC CHECKIDENT(N'dbo.foo', RESEED, 499);
GO

INSERT dbo.foo DEFAULT VALUES;
GO 3

SELECT ID FROM dbo.foo WHERE ID &gt;= 98;


Results:

98
99
100
500
501
502