-
You are not logged on as the database owner or system administrator.
Leave a commentFebruary 22, 2016 by Kenneth Fisher
I had one of my developers ask me why he keeps seeing the following warning when he tries to modify …
Continue reading -
Take caution when altering a column using TSQL
1February 17, 2016 by Kenneth Fisher
When developing in SQL Server you are eventually going to have to modify a column or two (at least). And …
Continue reading -
varchar(1) VS char(1)
5February 15, 2016 by Kenneth Fisher
The other day I made a somewhat flip coment on twitter. (I know, everyone is shocked right?) varchar(1) Really? It’s …
Continue reading -
Changing to simple recovery to clear the log.
6February 10, 2016 by Kenneth Fisher
Clearing out a full transaction log is a common problem. A quick search will find you dozens of forum entries …
Continue reading -
Impersonation can give you the wrong answer
1February 8, 2016 by Kenneth Fisher
I use impersonation all the time to let me see additional permissions information I can only get that way and, …
Continue reading -
Blogger questions: What if someone else wrote about the same subject?
8February 3, 2016 by Kenneth Fisher
I have a moderately popular blog. In part because I syndicate but largely (in my opinion) because I write a …
Continue reading -
Running code on the startup of SQL Server
1February 1, 2016 by Kenneth Fisher
Every now and again you need to run code when your instance starts up. For example you might want to …
Continue reading -
Reusing schedules in SQL Agent
1January 25, 2016 by Kenneth Fisher
I’m a big fan of automation. You get it written, tested, and scheduled, then you just sit back and monitor …
Continue reading -
Start SQL Server without tempdb
3January 20, 2016 by Kenneth Fisher
tl;dr; Re-start the instance in safe mode (-f startup parameter) and move tempdb. Then re-start without the parameter. While at …
Continue reading
SQL Studies
Live, Learn, Share
SQL Studies 