Unlock a Teradata User Account
1. Determine if the account is locked by failed password attempts. When the failed attempts equals the max logon attempts set in the user’s profile, the user will be displayed … Continue Reading →
Author: BlogAdmin
DateTime to the Millisecond in a Filename
My goal was create a filename with the DateTime format to the millisecond to be used in a stored procedure. First was to get the DateTime format I wanted without … Continue Reading →
Running A DIP Script in Teradata
Note: The following was run on a Teradata Express 15.10 VM. Problem: Teradata Support’s response to correcting a problem we were having with calendar functions was “running DIPCAL should successfully … Continue Reading →
Troubleshooting – Error: 17189, Severity: 16, State: 1
Troubleshooting the following Error: 2017-06-01 18:00:00.000 Logon Error: 17189, Severity: 16, State: 1. 2017-06-01 18:00:00.000 Logon SQL Server failed with error code 0xc0000000 to spawn a thread to process a … Continue Reading →
Error Number 825 Alert that was followed by Clean CHECKDB
Problem: Received an e-mail alert for one of my SQL Servers: SQL Server Alert System: ‘Error Number 825’ occurred on < my SQL Server > DESCRIPTION: A read of the … Continue Reading →
Teradata Finding Which User is the CreateUID
Problem: Looking at the dbc.roles table, I want to find which user created a role. There is the 4-byte column in the table called CreateUID, which identifies the user that … Continue Reading →
Truncate Table in Teradata
Coming from SQL Server & Oracle, I wanted a quick way in Teradata to truncate all the records from a table. The issue is the word TRUNCATE is not a … Continue Reading →
List All Identity Columns in a Database in SQL Server
Problem: Received a request for a list of all identity columns existing in a database. The example is from the SQL 2016 sample database: WideWorldImporters SELECT o.name as ‘OWNER’, t.name … Continue Reading →
List FILESTREAM databases in SQL Server
Problem: Received a support ticket requesting help with the FILESTREAM database for a SQL Server. Was given only the server name. This server had over 50 databases in the SQL Server … Continue Reading →
Teradata Viewing Failed Logon Information
In Teradata, there is a way to view the reason that a username is not authenticating. Teradata is good about collecting information at the time of authentication. It can be … Continue Reading →