This procedure will execute, taking two parameters, (the 2 db names, and will then list out the major object and schema changes for you. It is pretty sraight forward and suggestions are appreciated. It's a good utility for a DBA to track changes after upgrades, etc.. Each portion is easily convertable to a stand alone […]
2004-08-02 (first published: 2004-07-16)
1,107 reads
I don't remember where I found this little gem, but as a VB Developer it has simplified retrieving dates on many projects. Simply pass the function a datetime value and the format that you want in VB style syntax and the date is properly returned. I have modified it slightly from the original author (who […]
2004-07-23 (first published: 2004-06-24)
305 reads
This procedures grants execute permissions to all the stored procedures in a database to the role/user supplied as the parameter. the default is Execute_StoredProcedure. Execute this procedure local to the database you need to grant permissions.
2004-07-22 (first published: 2004-06-21)
344 reads
For lazy folks who want to use 'sp_force_shrink_log' in all dbs. This script depends on 'sp_force_shrink_log' already existing.
2002-08-20
973 reads
This script creates a stored procedure to shrink the transaction log in the database it is created in. The stored procedure shrinks each transaction log file in the database, to the size specified.
2002-07-14
681 reads
Here is a strait forward script that allows you to use CDONTS to send email. Note that the Subject, From, CC and BCC are all optional parameters. Because it uses a fully qualified path, this procedure can live in any database on the server. CDONTS will need to be installed on the server.
2002-06-06
700 reads
Generates a XML document containing metadata on a specified table. Table name is provided to the procedure.
2002-03-13
587 reads
This is an updated scripts with some useful modification for the script submitted by Seshu Kanuri
2002-02-07
736 reads
Ever wanted to know whether your triggers are enabled or not? The ObjectProperty command allows you to select information about the status of objects in your database, returning 1 for True and 0 for False. The example below determines whether a single trigger is disabled. SELECT ObjectProperty(object_id('Trigger_Name'), 'ExecIsTriggerDisabled') There are a number of other useful […]
2001-10-28
1,380 reads
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
By Steve Jones
fawtle – n. a weird little flaw built into your partner that somehow only...
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
Comments posted to this topic are about the item Where Your Value Separates You...
Comments posted to this topic are about the item Fixing the Error
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
On SQL Server 2025, I have a database that has this collation: SQL_Latin1_General_CP1_CI_AS. I decide I want to run this code:
SELECT UNISTR('*3041*308A*304C*3068 and good night', '*') AS 'A Classic';
I get this error:Msg 9844, Level 16, State 4, Line 24 The char/varchar input type uses an unsupported collation. Only a UTF8 collation is supported with char/varchar input type in UNISTR function.What is the easiest way to fix this error? See possible answers