James Travis

I currently work for a major US Bank in their internal support service area.

I develop tools and applications used by the call center, division, and corporate employees for various tasks.

I work with the following development platforms:
ASP
Visual Basic
ActiveX
COM/DCOM
.NET
Crystal Reports
VBScript
JavaScript
XML/XSL
HTML
DHTML
VBA with Office 97/2000/XP
SQL Server
Oracle
Informix
Visual C++
Photoshop

I am admin over several severs. Platforms include:
SQL 7 & 2000
IIS 4 & 5
Windows NT 4 & 2000

Currently I have developed or am developing applications for:
Project and employee time tracking
Financial Center/ATM information
Web based password resets for various systems
Call center scheduling and adherence
Inventory
  • Interests: My Family, Programming (Go Figure), Movies, Guitar

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 […]

2002-05-09

119 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 […]

2002-04-11

419 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)

2002-02-28

13,929 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)

2002-02-21

1,634 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 […]

2002-02-14

772 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 […]

2002-02-05

591 reads

Blogs

Daily Coping 24 Sept 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Using environment variable files for SQL Server in containers

By

There are a whole bunch of environment variables that can be used to configure...

How to Design Backups in SQL Server?

By

The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related...

Read the latest Blogs

Forums

SELECT CONTAINS is limited to 4000 characters

By zequion

In c# I use a function that generates Sql code that is executed through...

help with script to calculate gaps and overlaps from list of times

By chenks

hi got a question here that i hope someone can help with. i have...

Automatic INSERT-INTO

By LD3060

I have a view in my database where data is stored, it has 2...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers