Read more about the article Identity columns that are about to overflow
Microsoft SQL Server

Identity columns that are about to overflow

Identity columns are widely used as primary key columns in SQL Server tables. They can be one of the data types TINYINT, SMALLINT, INT, BIGINT, NUMERIC or DECIMAL. Each of these data types has an upper limit and when that upper limit is reached, an error is raised and further inserts into the table are impossible.

(more…)

Continue ReadingIdentity columns that are about to overflow
Read more about the article Mass editing of SQL Server objects
Microsoft SQL Server

Mass editing of SQL Server objects

Ever had the need to replace a piece of code in multiple SQL Server objects (Stored Procedure, Trigger, Function or Views)? Here’s a method to search for a string in all objects, replace it with some other code, and to finally script all changes. In other words, a method for mass editing SQL Server objects.

(more…)

Continue ReadingMass editing of SQL Server objects