Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  Sql character string that starts with "" is too lo

Author  Topic  arg179 Starting Member 1 Post Posted - 2014-04-08 : 07:59:10 Can anyone tell me if there is a way to get around the 4000 character limit for executing dynamic SQL statements? I have tried everything I can think of to get around this limitation but I can not figure out a way around this. Here's the error code below "Msg 103, Level 15, State 1, Line 191 The character string that starts with '0x4D5A90000300000004000000FFFF0000B8000000000000004000000000000000000000000000000000000000000000000000000000000000000000008000000' is too long. Maximum length is 4000." And here is my sql query below CREATE ASYMMETRIC KEY PCMFunctionsKey AUTHORIZATION dbo FROM EXECUTABLE FILE = '0x4D5A90000300000004000000FFFF0000B80000000000000040000000000000000000000000000000000000000000000000000000000000000000 CREATE LOGIN PCMFunctionsLogin FROM ASYMMETRIC KEY PCMFunctionsKey GRANT EXTERNAL ACCESS ASSEMBLY TO PCMFunctionsLogin GO I have all the admin permission and admin rights to the database but I'm not able to create the Asymmetric key. Also, I'm using SQL Server 2008R2 and VS2010 VB.Net 2010, and I'm using tmw_test as the database which is where ALL the sp_ and the assemblies as well as other files are located. Any help would be greatly appreciated.