This script creates comma separated lists of columns in different formats. These lists can be copied and pasted into other T-SQL statements. The lists are formatted as: a simple list of column names, a list with the column names as declared variables (@ + column name + data type), a list with column names as […]
2002-12-26
207 reads
This SP will create an Access database from TSQL using ADOX.Instead of Access, the Provider can be changed so that it will create *any* kind of database from DBase 3, Oracle, Excel, etc...
2002-12-11
347 reads
There are times when you have a limited range of ids and these have to be re-used as they become available.The script lists the first missing id in a table.Note that this script works best for a table with a limited number of rows, say sub 100,000I tested this on a PIII 500MHz 256Mb RAM […]
2002-12-09
262 reads
Purpose: To compare two strings with a supplied operator and return true if the strings evaluate to true using the operator provided. This is useful for stored procs to use instead of dynamic sql. YAY! Allowing for the operator and value to be passed in as parms. So that the user on the front end […]
2002-12-07
858 reads
Sometimes people want a Stored Proc with optional parameters. A lot of times people will use a coalesce for this. The problem with optional paremeters is that the query plan will never be an exact mach for that specific query. ( You never know what paremeters are filled..... )To solve this problem look at the […]
2002-12-06
453 reads
Sometime one needs to perform an operation on all or selected databases on a server/instance. Microsoft provides undocumented store proc sp_MSForEachDb to achieve this. I use it for some clean up process as a SQL Job.
2002-11-30
451 reads
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
468 reads
This simple script make a comparison between two given database. It compare: The table present in both database The data type, lenght, nullability, precision for each table. The object present in both database. The StoredProc is able to compare database across different server, simple make […]
2002-10-31
809 reads
This script will list the spaceused by all tables in a database. You can order the output by changing one of the parameters.It also provides totals
2002-10-27
675 reads
This script returns the latest package log for the DTS package specified in the @package_name variable. The interface for viewing DTS package logs through Enterprise Manager is limited in the fact that it doesn't provide textual descriptions of the values for the Step Execute Status and Step Execute Results. This makes it difficult to trace […]
2002-10-22
623 reads
By Chris Yates
I get asked a lot about why or how I began working with databases...
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Comments posted to this topic are about the item SQL Server 2025 Unveiled: The...
Hi, we lost our sever sql2000 To restore database to a new one we...
Comments posted to this topic are about the item Do You Really Need HA?
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers