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
326 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,144 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
477 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
641 reads
By Steve Jones
Flyway is a command line tool with lots of options and parameters. Working with...
By Steve Jones
wildred –adj. feeling the haunting solitude of extremely remote places – a clearing in...
Gurus, there is a table which is very slow to query , it has...
Hi. I have a query that returns few rows (out of 7 table join,...
By Stewart "Arturius" Campbell
We are working on a project to migrate a client from a version of...
Ask SSC