I had some login failures today from NT Authority\SYSTEM and it turned out to be from SCOM.

Here's the error from the SQL Error log:
Login failed for user...

CELKO (8/5/2012)

---

I would have to do some digging for exact rules, but this is a T-SQL dialect error. The conversion should fail with a message that the string cannot be...

I had a similar issue recently. I remoted into the machine and ran the psexec command that the SSIS package was attempting to run and it worked fine. So I...

Luis Cazares (8/7/2012)

---

You might find this article interesting.

http://msdn.microsoft.com/en-us/library/ms190309.aspx

So you won't have to wait for Celko to "do some digging". Here are the exact rules for implicit conversion in SQL Server....

Oracle converts an empty string to null. If I could choose how SQL Server handled it, my 1st preference would be a type conversion error. 2nd would be the way...

Ok, I think I understand why this is. There is an implicit conversion from varchar to int and you might think that when converting '' to int it would be...

Sometimes I forget how low I am on the scale of intellect. Thanks for reminding me where I stand.

On the topic of "obsolete" objects, dropping them if they haven't been accessed in 3 months or a year is a big mistake. I've seen objects that are only accessed...

We experienced a similar issue today where the user would receive an error: "Cannot Generate SSPI Context". On the server side, the error generated was: SSPI handshake failed with error...

This is excellent! The wheels in my brain immediately started turning while reading this article. Thanks for sharing.

There isn't a column named col1 on table1, only column1. Therefore none of the 3 statements will work.

I'm such and idiot!

I completely fell for this.

For a default instance installed on a single server with user databases on seperate drive than "c:\" and all system databases in "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data" would the following steps...

Nice article.

Thanks for taking the time to put it together and share with us.

I enjoyed reading this article.

Thank you for taking the time to do this.