Free SQL Server 2012 eBook from Microsoft Press
Which SQL Client versions are connecting to my instance?
Get your free Microsoft Press eBook, Introducing Microsoft SQL Server 2012 by visiting this link to get your PDF version today – http://blogs.msdn.com/b/microsoft_press/archive/2012/03/15/free-ebook-introducing-microsoft-sql-server-2012.aspx This book was written by former MVP turned Microsoft employee Ross Mistry and current MVP Stacia Misner. Enjoy!
SSIS 2012 – SSIS Environment Variables String Limit
Without fully restating what’s already published, please read this MSDN Blog Post for more details on how to determine which SQL Client version is connecting to a SQL instance. Basically, SELECT CAST(protocol_version as BINARY(4)) FROM sys.dm_exec_connections will tell you which version is connecting to your instance based on the TDS protocol appendix document, http://msdn.microsoft.com/en-us/library/dd339982(PROT.13).aspx. SQL […]
UPDATE: 2012-02-24 – The bug I submitted on this has been closed as “won’t fix.” I had asked the team to enforce this limitation in the GUI instead of throwing a somewhat cryptic error. Sorry. When creating environments in the new SSIS catalog, you are able to define environment variables. When creating string variables, you […]