To verify bank routing number by calculating correct check digit (digit #9 is used to validate 8-digit bank routing (ABA) number) and compare with digit #9 in given 9-digit routing number.(for more scripts goto http://www.siccolo.com/articles.html)
2007-08-03 (first published: 2006-11-21)
703 reads
To calculate bank routing check digit (digit #9 is used to validate 8-digit bank routing (ABA) number) (for more scripts --> goto http://www.siccolo.com/articles.html)
2007-08-02 (first published: 2006-11-21)
1,425 reads
This script is to monitor drive\database file space. There are variations of this script. The one posted has 2 parts. The frist is one that loops through the databases on a particular server calling the second which is the proc that gathers the information.
2007-08-01 (first published: 2006-11-21)
1,184 reads
Script can be used to find out the objects which are available in other database and are referenced in your stored procedure. These objects will not be listed with sp_depends system stored procedure.
2007-07-31 (first published: 2006-11-21)
288 reads
Created By:Srivathsani M(Srivathsani_m@infosys.com)Arvinder Singh Khosla(arvinder_khosla@infosys.com)Details:The scripts gives the flexibility to create customized backups.1)It gives the provision to give the backup files a customized name with customized time stamp.2)It allows the user to create the backup directory.3)These scripts can be used in the form of stored procedures by passing the variables defined in the script as […]
2007-07-30 (first published: 2006-11-15)
1,478 reads
Quick & Easy way to kill connections to specific database
2007-07-27 (first published: 2006-11-10)
870 reads
This script returns a result set showing which jobs were running at what point during a given day.One column is returned for each Job, and one row for each discrete portion of the day (configured by @TimeGranuality). A value of 1 indicates that the job was running at that point in time, 0 otherwise.Particularly useful […]
2007-07-26 (first published: 2006-11-10)
540 reads
The script can be used to find all the tables that have the particular column name in it.
2007-07-25 (first published: 2006-11-06)
136 reads
This SQL 2005-only VBS script will show the longest-running queries on a given server, complete with graphical .sqlplan when clicked. Results go to a web page, viewed from the local machines's temp directory.Each row of the resulting table has the session ID, the currently running statement of the batch, a link to a text file […]
2007-07-24 (first published: 2006-10-30)
377 reads
Script will create a sorted list of databaes and their recvoery model. I'm sure there is a more elegant way to do this, but this works in a pinch.
2007-07-23 (first published: 2006-10-26)
1,072 reads
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Comments posted to this topic are about the item Symmetric Key Encryption
Comments posted to this topic are about the item The “Successful Login” Dilemma: Why...
Comments posted to this topic are about the item Building Your Own Software
If I run this statement in SQL Server 2025, how is the password encrypted?
CREATE SYMMETRIC KEY MySymmetricKey WITH ALGORITHM = AES_256, KEY_SOURCE = 'My secret key source passphrase', IDENTITY_VALUE = 'My secret identity value' ENCRYPTION BY PASSWORD = 'S&perS#cretP@ssword7'; GOSee possible answers