oops! This was not expected...

Msg 8152, Level 16, State 14, Line 3

String or binary data would be truncated.

The statement has been terminated.

Thanks for sharing your experience. I'm sure you have not been the first and will not be the last to have this, or something like this happen when taking over...

What's Merge got to do with Valentine's Day?? 😉 Just kidding, good question!

The question's IF statements challenged my logic processing more than the data type, but it still was a good question because I like logic puzzles - Thanks 🙂

I missed this one today, not paying close enough attention on a Monday - who'd have guessed! 😀

I agree with Dalton! 🙂 Also, it would be nice to have a "starts-with" function...

Contact was and is one of my favorite sci-fi movies. Enjoy the weekend:-)

I think I finally identified the problem...the server with SQL 2012 is new to our network and it was not added to the DNS servers correctly. I found this on...

I tried that, and it failed because the provider to connect to SQL 2012 (SQLNCLI11) is not available on my SQL 2008 instance. The server with SQL 2008 is Windows...

I am planning to die with my boots on as a DBA. I have loved my career in technology and am currently employed in the healthcare industry, which is stable....

Thanks Hugo, for providing the example. That helped me see why I got it wrong!

Happy Easter!

? on SQL 2012 +1

Great question! It was worth the time to look at the examples and understand what really happens to data results from views when changes are made to underlying objects. Thanks...

Missed this one because I looked at it too long. Should have followed my first intuition...better luck tomorrow! Thanks for the question.

I'd be a Chevy Camaro - red, convertible and sporty with 8 cylinders and a stick shift...:-D

Currently driving my husbands Jeep Grand Cherokee, a 4-wheeled "grocery getter" with a full...