James Travis

Update existing user accounts default language.

When changing the default language of a server it is neccessary to run sp_defaultlangauge against any existing logins. The reason is default language only effects any new accounts created after this change is made. This script is designed to help you quickly make the adjustment for all existing accounts. Note: this has been tested under […]


117 reads

Converting money to the word value.

With this script you can supply an money value such as $12525.83 and it will return the word value "Twelve Thousand Five Hundred And Twenty-Five Dollars And Eighty-Three Cents".It is comprised of a table for Number to Name and a procedure to parse into it's piecesNOTE: This only goes to billions at this point, but […]


417 reads

How to Fix Inconsistent Metadata Errors

Why does changing a table on a SQL Server 7.0 server cause "OLE DB provider 'SQLOLEDB' supplied inconsistent metadata. An extra column was supplied during execution that was not found at compile time." to occur when query the table from a SQL Server 2000 server via link to other. In this article by James Travis, he shows you what the problem is and how to fix it.

5 (1)


13,270 reads

Find a string in DB objects.

Find a string in Procedures, Triggers, Constraints, Defaults, Functions, and Views. First off this will not work for any items that have the WITH ENCRYPTION remark in them. With this is can pose a string such as 'INSERT' against all the 'P'rocedures to get a return of which Procedures have an INSERT statment in them […]

5 (1)


1,630 reads

Rename User Login

You can effectively rename a user account but as this is messing wit the system tables I would suggest dropping and adding the user back. But for those of you who really want to know how here it is.First off I tested this and it works fine renaming a user. However this is directly modifying […]


729 reads

Convert a given date to GMT

In SQL 7 you had no way to convert local time to GMT (UTC time) which was added in SQL 2K as GETUTCDATE() which will output the current date you would get with GETDATE() but a it's GMT counterpart. Although this was a great improvement I work with data on another server that's front end […]


582 reads


Azure SQL Database Compatibility with SQL Server


A long time ago, in early days of the Azure SQL Database in 2015,...

Custom deployment parameters in Azure Data Factory - Forget Me Not


(2020-Sep-26) Last week one of my Azure Data Factory (ADF) deployment pipelines failed with an...

VMworld 2020 – Top 10 Database Sessions (Part 2)


Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...

Read the latest Blogs


Tempdb version store related question

By vsamantha35

Hi All, Recently, we observed the tempdb has grown out of proportion and filled...

about the option (fast n) and acutal execution plan

By 892717952

 what kind of situation  can I use "option (fast 1)"  when I execute a...

Problem during the setup of SQL Server 2019

By Developper12345678

During the installation I come to the step of configuring the database engine. It...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers