The script is in three parts:1. A select statement to determine the number of duplicate records contained within the table2. The deduping process builds a temporary table called #Duplicates and uses it to compare duplicates across both similar tables whilst deleting records with multiple counts3. Final test of deduping with no records indicating table is […]
2007-06-27
384 reads
This procedure is used to shrink the databases. Many times we use shrink option to shrink the databases for backup. and we do it N number of times, when we take the back of databses or make free space of drive.instructions:- Follwo the step.1. run script.2. And execute the statement, exec shrink_databasesI m new, if […]
2007-06-27
793 reads
Old version, archived, that works on ss2k. Updated version works on ss2k5. NOTE: This is a Microsoft developed script, not from the contributor (Steve Jones)
2007-06-27 (first published: 2006-05-04)
894 reads
There is a great article on SQLServerCentral on an Extended Stored Procedure http://www.sqlservercentral.com/columnists/mcoles/freeencryption.asp and this XP will undoubtedly perform better than my Function. However I had a need to encrypt a column in a shared hosted environment where I was not allowed to install XPs. Just copy script and paste into Query Analyzer
2007-06-26 (first published: 2006-01-12)
1,274 reads
DBCC page was decommissioned in 7.0 according BOL. Parameters have being changed, but the call itself remains. Following script shows some reverse engineering results.
2007-06-25 (first published: 2006-05-29)
418 reads
This is a first version of a custom solution for SQL Server log shipping using VB.NET 2005 and .NET Framework v.2.0. The script has to run on a server where you have SQL Server 2005 (or at least tools) installed because it uses new SMO. For some functions of the script you will have to […]
2007-06-22 (first published: 2006-06-05)
1,131 reads
Hi,exec sp_change_users_login 'report' displays the list of orphan USERS in a database but we don't have any builtin SP which displays the orphan LOGINS.By Orphan Logins (not users), I mean the Logins that don't have any access to any databases and are sitting idle on the server (also aren't member of any fixed server role).We […]
2007-06-21
271 reads
A database can have objects with multiple owners. The script will give you the list of all the TABLES, VIEWS and PROCEDURES having the specified owner. Just input the owner name and it will give you the list of all the Objects with that owner. This scope of the script is limited to the TABLES, […]
2007-06-21 (first published: 2006-01-30)
293 reads
Some time back i had the requirement for a SP which will give non repeatable random numbers with in a range. Following SP accepts a range and gives the random numbers. Once the numbers are exhausetd NULL, will be the out put. In this case user can restart the random number generation by passing 1 […]
2007-06-20 (first published: 2006-03-29)
234 reads
Use this Perl script to add Enterprise Manager registrations from a text file. The text file should contain three fields seperated by spaces. The first two fields are the server groups you want to create, and the last is the server name. ex...Production Accounting ACTPRSQL01QA Accounting ACTQASQL01The script also goes out and registers all SQL […]
2007-06-19 (first published: 2005-03-23)
292 reads
By Steve Jones
Thanks to everyone who attended my sessions today at SQL Saturday Boston 2025. I’ve...
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...
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')
GO
What is the identity value for the new row inserted by the insert statement above? See possible answers