This script will help you locate columns that you provide in a comma delimited format. You pass it as few or as many columns as you want in the following format: ',,....' and this will generate you a report that states which database, and table each column you passed is in.
2004-08-13 (first published: 2004-01-22)
123 reads
Generate an html-excel file with any table. Does not need Excel to generate , because does not use Excel automation
2004-08-12 (first published: 2004-02-10)
792 reads
The code in this procedure takes standard formula’s given by Microsoft and calculates approximate size of a table as per the fields & indexs on that table. The procdure can be quickly be used in a loop to work for entire database. Refer to article http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_02_92k3.asp for the actual document containing the formula’s used.There are […]
2004-08-11 (first published: 2004-02-16)
2,930 reads
The purpose of this SP is to provide a method in T-SQL to launch another T-SQL thread without havingto wait for its completion. Uses fairly basic calls to create and execute SQL Jobs. Contains helpfull notes and documentation.
2004-08-10 (first published: 2004-02-17)
2,219 reads
Script to look at all articles in all publications in a DB to find replicated columns of certain data types. I used this to find BLOB columns that we wanted to remove from the articles.
2004-08-09 (first published: 2004-02-19)
452 reads
This script will generate random Strong Passwords for all Standard SQL Logins for a specified SQL Server. It currently does ALL standard logins, including SA, so you would want to add to the WHERE clause in the SELECT_LOGINS constant if you want to limit the logins. The password generated will be 10 - 15 characters […]
2004-08-05 (first published: 2004-05-12)
269 reads
I use this VBScript to get a DDL copy of all objects in my DB, and check them into SourceSafe if they have changed. I run it via Scheduled Tasks every night. Make sure unauthorised users have no access to the script location, as you need to enter the VSS password in it.
2004-08-04 (first published: 2004-05-20)
469 reads
This script will run a DTS package from any registered SQL Server instance and display the standard package execution progress dialog while the package is running.To specify the SQL Server instance and package to run, amend the parameters for the ExecuteDTS function in the "Main Program" section of the script.The script is written using SQL […]
2004-08-03 (first published: 2004-05-25)
1,061 reads
This procedure will execute, taking two parameters, (the 2 db names, and will then list out the major object and schema changes for you. It is pretty sraight forward and suggestions are appreciated. It's a good utility for a DBA to track changes after upgrades, etc.. Each portion is easily convertable to a stand alone […]
2004-08-02 (first published: 2004-07-16)
1,105 reads
This stored procedure will detect all first level object dependencies on Stored Procedure.The result set will be stored in table Depend. Unlike sp_depends, sp_MSdependencies will be able to detect all links and dependencies associated to an object. It includes TRIGGER, DELETE, UPDATE etc .
2004-07-30 (first published: 2004-07-16)
327 reads
The slidedeck and the SQL scripts for the session Indexing for Dummies can be...
By Chris Yates
Change is not a disruption in technology; it is the rhythm. New frameworks appear,...
No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL...
Comments posted to this topic are about the item Don't Forget About Financial Skills
Comments posted to this topic are about the item Building a Simple SQL/AI Environment
Comments posted to this topic are about the item Checking Identities
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