June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – 2005 Collation Explanation and Translation – Part 2

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Collation, SQL Scripts, SQL String
Following function return all the available collation of SQL Server 2005. My previous article about the SQL SERVER – 2005 Collation Explanation and Translation. SELECT * FROM sys.fn_HelpCollations() Result Set: (only few of 1011 records) Name Description Latin1_General_BIN Latin1-General, binary sort Latin1_General_BIN2 Latin1-General, binary code point comparison sort Latin1_General_CI_AI Latin1-General,…
Read More

SQLAuthority News – SQL Blog SQLAuthority.com Comment by Mr. Ben Forta

Pinal Dave
Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, DBA, SQL Scripts
Today is one of the most glorious day for SQLAuthority.com in history. Famous author of Sams Teach Yourself Microsoft SQL Server T-SQL In 10 Minutes, ColdFusion Guru, and well known evangelists Mr. Ben Forta has made comment on his blog about SQLAuthority.com. I encourage all my readers to visit comment…
Read More

SQL SERVER – 2005 – List All Stored Procedure Modified in Last N Days

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL DateTime, SQL Scripts, SQL Stored Procedure
I usually run following script to check if any stored procedure was deployed on live server without proper authorization in last 7 days. If SQL Server suddenly start behaving in un-expectable behavior and if stored procedure were changed recently, following script can be used to check recently modified stored procedure.…
Read More