Occassionally you might want to convert a binary number into some printable string. This would allow you display some meaning fully numbers hex characters, instead of just some unreadable garbage. This script takes a binary field, of basically any length, and converts it, character by character, to a character string. The character string will contain […]
2002-11-07
449 reads
Every want to keep everyone from updating all your users database? If so this script will set each database to read only status.
2002-09-26
327 reads
Every want an easy way to set all database to DBO only and single user mode? Well here is a script to do that for you. This script is useful when you want to keep users out of the all the databases.
2002-09-23
1,197 reads
Here is a companion script to "Set All databases to DBO only and Single User Mode" that will turn off dbo and single user mode for all databases.
2002-09-23
492 reads
This stored procedure produces a report of record counts for every table on your server. The record count report is organized by database, and table name.
2002-05-16
642 reads
Data isn't just about numbers and spreadsheets. It holds stories, patterns, and the answers...
By Brian Kelley
When I look at a system and think about its security model, the first...
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
I have table TicketNumbers i TicketNumber UID 2 10 09901a22c7c3acc6786847c775f1d113 6 5 00dad28bef21f916240d6e8c1c1bd67d 12 ...
Hello Everybody, I have a database on which I try to empty a file...
My knowledge of Extended Events is limited, but I am trying to capture some...
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers