Options
System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'SqlEdition'.
Hello, get the above error when trying to run my sql test.
I do not have this column in the test, nor any of its associated files, so figure this is a redgate thing.
Looks like it is coming from tSQLt.Private_Init:
Any assistance would be appreciated.
Thanks!
I do not have this column in the test, nor any of its associated files, so figure this is a redgate thing.
Looks like it is coming from tSQLt.Private_Init:
Any assistance would be appreciated.
Thanks!
Tagged:
Answers
Thank you for your forum post.
What version of SQL Test are you using?
Also the Version of SSMS and the SQL Server of the database being tested?
tSQLt.Private_Init is installed as part of the tsqlt framework which essentially is this Stored Procedure:
<div>CREATE PROCEDURE [tSQLt].[Private_Init]</div><div>AS</div><div>BEGIN</div><div> EXEC tSQLt.Private_CleanTestResult;</div><div><br></div><div> DECLARE @enable BIT; SET @enable = 1;</div><div> DECLARE @version_match BIT;SET @version_match = 0;</div><div> BEGIN TRY</div><div> EXEC sys.sp_executesql N'SELECT @r = CASE WHEN I.Version = I.ClrVersion THEN 1 ELSE 0 END FROM tSQLt.Info() AS I;',N'@r BIT OUTPUT',@version_match OUT;</div><div> END TRY</div><div> BEGIN CATCH</div><div> RAISERROR('Cannot access CLR. Assembly might be in an invalid state. Try running EXEC tSQLt.EnableExternalAccess @enable = 0; or reinstalling tSQLt.',16,10);</div><div> RETURN;</div><div> END CATCH;</div><div> IF(@version_match = 0)</div><div> BEGIN</div><div> RAISERROR('tSQLt is in an invalid state. Please reinstall tSQLt.',16,10);</div><div> RETURN;</div><div> END;</div><div><br></div><div> IF((SELECT SqlEdition FROM tSQLt.Info()) <> 'SQL Azure')</div><div> BEGIN</div><div> EXEC tSQLt.EnableExternalAccess @enable = @enable, @try = 1;</div><div> END;</div><div>END;</div>Are you able to execute the stored procedure manually (Right click the procedure >Execute Stored Procedure)?
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com