Retrieve the name of the current database for use with bcp and other procedures that require database name. This will help increase the portability of code and less maintenance required when migrating code to new database/server.
2003-05-22
210 reads
This script uses sysobjects and sysindexes to ID all tables in a database that are indexed, and/or clustered. It then runs through per table all of the indexes and runs DBREINDEX with their fillfactor. This eliminates having to maintain a list of all indexes and having code fail when it tries to modify indexes that […]
2002-12-19
1,786 reads
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forgive me for the title. Mentally I’m 12. When I started my current day...
At FARE Labs Pvt. Ltd., our inspection and auditing services focus on precision, quality...
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Comments posted to this topic are about the item Expanding into Print
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers