Show_Locks
Shows database, table names which are locked, the user who locks them, the command which is executed
2005-01-28 (first published: 2005-01-06)
1,140 reads
Scripts
Reporting Services Extras Bug - Date Sort Problem
SQL Server's Reporting Services comes with some pre-built reports to be able to monitor who is doing what with your Reporting Services Server. You can find these reports in the \Extras\Execution Log Sample Reports folder on the product CD-ROM (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_rslogfiles_v1_88gy.asp). One of the reports is titled "Todays Reports" (Todays Reports.rdl/pToday Dataset). It should show the […]
2005-01-27 (first published: 2005-01-07)
895 reads
Backup DTS Package while editing in Designer
This is a very cool time saving ActiveX Script, run manually from within DTS Designer, that generates date and sequence named backups of the package into the specified development and backup folders. Don't ever lose work again.
2005-01-26 (first published: 2005-01-08)
108 reads
Use of regular expressions in TSQL -- version 2
This script creates 2 new system functions ****************************************** NEW: 1. functions will be case sensitive if database is 2. Replace all or only first occurence ****************************************** fn__regexp_test(@String,@Pattern) returns int execute the method test(@String) on the regular expressions @Pattern returns : 0 : no match 1 : match null : one of the parameters was null […]
2005-01-26 (first published: 2004-04-08)
521 reads
Add Wildcards to Advanced Search Stored Procedure
I have found that I can add wildcard support to the Advanced Search Stored Procedure submitted by jgroseth (Posted: 07/02/2004) here:http://www.sqlservercentral.com/scripts/contributions/1201.aspby simply modifying "charindex( c.string," to "patindex('%' + c.string + '%'"I did this to take varying whitespace into account since SQL server does not care about whitespace, for example "INSERT INTO DATABASE_MYTABLE" could have any […]
2005-01-25 (first published: 2005-01-10)
514 reads
Generate Random Alphanumeric String
Here's a short script to generate a random alphanumeric string based on newid(). The procedure takes in length (@len) which determines the key length. Length must be between 8 and 32. Result is returned in an output parameter. A test script is supplied.
2005-01-24 (first published: 2005-01-10)
1,285 reads
create t-sql scripts for every jobs in Instance.
Desc : This SQL statement will provide script for backup all your jobs.Remark : Grow-up 'maximum characters per column' (for 8192) and disable 'print column headers' in 'tools' / 'options'
2005-01-21 (first published: 2005-01-11)
1,059 reads
t-sql function to parse string data
The below function can be used to parse or split out data from a delimited string. The function takes in 3 parameters. The text you want to parse, the 1 character delimiter, and the total count of objects in the text.Text for function is set at size of varchar(2000), feel free to make bigger if […]
2005-01-19 (first published: 2005-01-13)
1,878 reads
Rename DTS Tasks / Steps for Logging
ActiveX Script that will rename all DTS Package Tasks and Steps to include the Task Description. For generating DTS Logs with meaningful names.
2005-01-17 (first published: 2005-01-04)
377 reads
USER PROCESS CHECK (COMPLETE)
The following runable script is a very simple way to track SPID's and PROCESS information (VERY BASIC) in a small target (Local) database.1. Creates a small database 1.1 must set MDF and LDF (File location information) specific to the drive and file folder locations for each server2. Sets All db options3. Creates single table to […]
2005-01-14 (first published: 2005-01-04)
224 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
ALAMAT BANK BCA KCU PEMATANG SIANTAR TLP/WA 08218200233
Telp Cs: 08218200233 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...
ALAMAT KANTOR BCA KCU ASIA TLP/WA 08218200233
Telp Cs: 08218200233 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas II,...
ALAMAT KANTOR BCA KCU WISMA ASIA TLP/WA 08218200233
Telp Cs: 08218200233 Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers