Category Archives: Problem Resolution
-
Why am I getting an NT AUTHORITY\ANONYMOUS error when creating or altering a stored procedure?
1May 8, 2019 by Kenneth Fisher
If you have to deal with linked servers then you probably have or will run into the following error: Login …
Continue reading -
SQL Homework – May 2019 – SQLCMD and the DAC
5May 1, 2019 by Kenneth Fisher
Yes, it’s that time again. Time to do your homework. This month your homework is to set up the DAC …
Continue reading -
How do I let someone execute a SQL Agent job they don’t own?
2April 15, 2019 by Kenneth Fisher
In my last post I discussed the fact that SQL Ids can, in fact, be useful on an instance that …
Continue reading -
What happens in a trigger stays in the transaction: T-SQL Tuesday #106
Leave a commentSeptember 11, 2018 by Kenneth Fisher
Anything that happens in a trigger happens within the same transaction of the command that called it. Part of me …
Continue reading -
SQL Puzzle: Advent of Code
Leave a commentAugust 29, 2018 by Kenneth Fisher
A few years back someone started the Advent of code. If you aren’t familiar with it, it’s an advent calendar …
Continue reading -
Complicated linked servers and a bunch of head-desks: T-SQL Tuesday #104
Leave a commentAugust 14, 2018 by Kenneth Fisher
Wayne Sheffield (b/t) is our host this month for the long running blog party (104 months now and running!) started …
Continue reading -
Processes can dramatically improve your work until they don’t.
Leave a commentJuly 23, 2018 by Kenneth Fisher
As always with something like this, I like to start with a definition so we are all starting in the …
Continue reading -
Misleading errors: “Server is configured for Windows authentication only.” But it’s not!
3June 18, 2018 by Kenneth Fisher
In general, the errors SQL gives are highly useful. Of course every now and again you get one that’s just …
Continue reading -
The identity column, the insert and the linked server.
4June 14, 2018 by Kenneth Fisher
tl;dr; When doing an insert across a linked server you have to include the list of fields to be inserted …
Continue reading -
Updated query to view data in the error log
2May 31, 2018 by Kenneth Fisher
This is one of my favorite scripts. It pulls all of the data from the error log and dumps it …
Continue reading
