SQL Server – Get SQL Server Service Account using T-SQL
SQL Server service account information is stored in Windows Registry database. You can get this information from Services Console or...
2013-08-20
2,487 reads
SQL Server service account information is stored in Windows Registry database. You can get this information from Services Console or...
2013-08-20
2,487 reads
There are several options available to import data from external sources to SQL Server. Such as Import & Export Wizard, BULK...
2013-07-29
1,056 reads
This is a follow-up post on SQL Server – Check SQL Agent Job History using T-SQL.
SQL Server Agent stores SQL jobs...
2013-07-22
715 reads
To SELECT only top N rows from a table we can use TOP clause in SELECT statement. Using TOP clause...
2013-07-15
849 reads
By default SQL Server ERRORLOG is stored in "C:\Program Files\Microsoft SQL Server\InstanceFolder\MSSQL\Log" folder. The ERRORLOG location is configured as a...
2013-07-12 (first published: 2013-07-08)
5,711 reads
If you have lost the password for sa account or does not have any administrative account and you are locked...
2013-07-03 (first published: 2013-07-01)
4,163 reads
When an account is disable it cannot be used to login to SQL Server. You will receive below error when...
2013-06-24
976 reads
Often we may need to update a column in a table based of another column in another table.
In SQL Server...
2013-06-18
1,141 reads
To get database size information we can use sys.master_files catalog view. This view contains a row per file of a...
2013-06-10
1,257 reads
To move a database from one location to other you fist need to detach the database from server. In this...
2013-06-03
1,139 reads
SQL Server 2025 introduces native support for vector data types and external AI models....
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...
I'm building ETL packages in SSIS. My data comes from an OLE DB Source...
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...
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