Those Stubborn Database Rules - Finding Them and Scripting Them
Scripting out database rules to help you remove them from your database solutions.
2010-01-05
4,750 reads
Scripting out database rules to help you remove them from your database solutions.
2010-01-05
4,750 reads
Cracking open the default management packs in SCOM unlock a vast code library for custom automation and monitoring of SQL Server instances.
2008-03-24
7,177 reads
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
By Steve Jones
I saw a question asking about the next sequence value and decided to try...
By Vinay Thakur
Following up on my Part 1 baseline, the journey from 2017 onward changed how...
I've got a table with 186,703,969 rows, about 300GB of data. There are several...
I created a SQL Database in Azure Portal but I've just noticed it also...
Comments posted to this topic are about the item An Unusual Identity
What values are returned when I run this code?
CREATE TABLE dbo.IdentityTest2
(
id NUMERIC(10,0) IDENTITY(10,10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
INSERT dbo.IdentityTest2
(
somevalue
)
VALUES
( 'Steve')
, ('Bill')
GO
SELECT top 10
id
FROM dbo.IdentityTest2 See possible answers