Some time you need to know only Date without Time.This is simple function that allows you truncate datetime field to date only.This function can help you to construct dynamic T-SQL for select date period. P.S. Thanks for ispaleny! Conversion only for real not enough! It is necessary convert to real that correct errors near the […]
2003-03-28
422 reads
Modified the sp_who2 proc provided by Microsoft. This proc takes a dbname or dbid for input, and lists current processes in that database. If no database is provided, the current database is used.
2003-03-28
203 reads
This is a sp_password enhanced by Dmitri Bobkov (see http://www.sqlservercentral.com/scripts/contributions/718.asp) and re-enhanced with a small changes from SQL2kSP3.For SQL Server in Mixed Authentication mode this stored procedure helps to validate users password. Currently this procedure checks for the next requrements: password must have length at least 8 characters plus among them at least one digit […]
2003-03-27
480 reads
User Defined function to parse a string with known delimiters and return back the substing in the position.Takes string,delimiter and position as parameters. Can be used directly in TSQL code.
2003-03-27
340 reads
When you want to export a table structure to T-SQL, everyone always points you to Enterprise Manager, or a script that calls BCP.Sometimes, a developer either doesn't have access to those tools, or just doesn't want to use them (like me) out of spite.I made this T-SQL because it was educational, and noone else seems […]
2003-03-26
4,064 reads
This procedure helps to find the status of all the trigger (i.e Enabled/Disabled) for a given database. If no database name is provided then it uses the default database.This script is tested on SQL Server 7.0/2000 only.
2003-03-25
306 reads
This stored procedure shrinks all database files within the current database, including the unused portion of transaction log. This procedure is especially useful for multi-file databases.
2003-03-24
218 reads
This script reindexes all tables in all databases. Execute the script with the desired fill factor and it will do the rest. There is an option to exclude databases from the reindex. This makes it easy to reindex all newly created databases. Great for the Development environment when Developers are creating database all the time.
2003-03-23
1,994 reads
This script will obscure email addresses from robots even ones that ignore the tags to not snoop. Usually robots that ignore the tags, and the robots.txt file are used by spammers. They pull down the SOURCE of your page and scrape the email addresses from them. This script breaks the mail href into its base […]
2003-03-23
115 reads
The three functions here can be used to store Bit Masks as Integers.These are functions to convert an integer into a binary string. This can be useful if you store Bit Masks in your database as integers.For example .. '00000000000011111001001001110011' to 1020531Each Bit could represent an ON or OFF value. One integer columncould be equivalent […]
2003-03-21
4,076 reads
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
How I used AI for this postChatGPT to generate images based on info specifically...
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
Comments posted to this topic are about the item How Can SQL Server Detect...
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers