How To Find All Access Rights In Teradata
- By BlogAdmin
- 14 July, 2018
- No Comments
The problem with the table DBC.AccessRights is that the data is not something easily readable. Many of the columns use a 4-byte IDs. By joining a couple of tables to … Continue Reading →
Msg 14604, Level 16, State 1 Error When Changing A Database Mail Account
- By BlogAdmin
- 23 June, 2018
- No Comments
When attempting to change an email account in my Database Mail, I received the following error: Msg 14604, Level 16, State 1, Procedure sysmail_verify_account_sp, Line 14 Both account parameters (id … Continue Reading →
Using Keyboard Query Shortcuts in SQL Server Management Studio
- By BlogAdmin
- 19 May, 2018
- No Comments
This is something that I wish I had discovered years ago. I have put together my nine most used queries, functions, or system stored procedures that I use most everyday. … Continue Reading →
Cannot Generate SSPI Context – Connection Problem
- By BlogAdmin
- 1 April, 2018
- No Comments
Problem: When I attempted to logon to one of individual node for my AlwaysOn Availability Group, I received the connection error shown below. TITLE: Connect to Server Cannot connect to … Continue Reading →
E: Unable to locate package mssql-tools – error install the command line tools for SQL Server on Ubuntu
- By BlogAdmin
- 11 March, 2018
- 2 Comments
Problem: When attempting to install the command line tools for SQL Server on Ubuntu 16.04.3, I would get the error: “E: Unable to locate package mssql-tools” Resolution: Note: SQL Server … Continue Reading →
Problem Patching a SQL Server Cluster
- By BlogAdmin
- 24 February, 2018
- No Comments
Problem: I was working with a SQL Server 2014 two node cluster in our test environment. After the cluster had been setup, I was asked to change the drive letters … Continue Reading →
Teradata Error: Cannot Find Terasso Library
- By BlogAdmin
- 6 January, 2018
- No Comments
Problem: Setting up a new computer with the 16.10 Teradata Tools And Utilities & other Teradata programs. When I went to setup the ODBC Connection to the using the Teradata … Continue Reading →
ALTER LOGIN WITH PASSWORD causes error Msg 15151, Level 16, State 1, Line 4
- By BlogAdmin
- 1 January, 2018
- No Comments
Problem: A user that was not part of the sysadmin role attempted to change its own password using the SQL syntax, “ALTER LOGIN WITH PASSWORD”. Returned is the following error: … Continue Reading →
Trace Flag for Troubleshooting Lost or Dropped Connections in SQL Server
- By BlogAdmin
- 10 December, 2017
- No Comments
Problem: About once a month, I get support ticket regarding SQL Server dropping an application’s or user’s connection. The problem is SQL Server does not just randomly drop a connection … Continue Reading →
E: Unable to locate package mssql-server – Ubuntu SQL Server Installation Error
- By BlogAdmin
- 6 November, 2017
- 2 Comments
Problem: With the new install of Ubuntu 16.04.3 LTS (GNU/Linux 4.4.0-87-generic x86_64), different attempts at installing SQL Server resulted in the error: “E: Unable to locate package mssql-server”. Resolution: On … Continue Reading →
Copyright © 2019