# FB7 error executing SQL

**URL:** https://www.finalbuilder.com/forums/t/fb7-error-executing-sql/1552
**Category:** Discussion
**Created:** [August 6, 2010, 10:58am UTC](https://www.finalbuilder.com/forums/t/fb7-error-executing-sql/1552 "2010-08-06T10:58:37Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![markeverest](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/m/8c91f0/32.png) [@markeverest](https://www.finalbuilder.com/forums/u/markeverest)
#### Post date: [August 6, 2010, 10:58am UTC](https://www.finalbuilder.com/forums/t/fb7-error-executing-sql/1552/1 "2010-08-06T10:58:37Z")

</div>

Hey all,

This is a strange one.

I have a MSSQL&nbsp;Execute SQL task that contains the following SQL:

sp\_change\_users\_login 'auto\_fix', 'ecobomuser'

This fails when run with:

Msg 105, Level 15, State 1, Server MARKEV07D, Line 1  
Unclosed quotation mark after the character string 'ecobomuser  
'.  
Msg 102, Level 15, State 1, Server MARKEV07D, Line 1  
Incorrect syntax near 'ecobomuser  
'.  
Execute failed, return code: 1  
&nbsp;

However, if I put a space at the end of the line, after the closing ' - it works!

---

<div class="post-metadata">

### Author: ![paulsamways](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/p/e8c25b/32.png) [@paulsamways](https://www.finalbuilder.com/forums/u/paulsamways)
#### Post date: [August 9, 2010, 1:02am UTC](https://www.finalbuilder.com/forums/t/fb7-error-executing-sql/1552/2 "2010-08-09T01:02:29Z")

</div>

Thanks Mark, the fix will be in the next test build of FinalBuilder 7. I’ll let you know when it’s available.   
  
 Regards,   
 Paul.

---

<div class="post-metadata">

### Author: ![paulsamways](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/p/e8c25b/32.png) [@paulsamways](https://www.finalbuilder.com/forums/u/paulsamways)
#### Post date: [August 9, 2010, 7:06am UTC](https://www.finalbuilder.com/forums/t/fb7-error-executing-sql/1552/3 "2010-08-09T07:06:53Z")

</div>

Hi Mark,   
  
 Here is the new test build of FinalBuilder 7:   
  
 URL: [https://www.finalbuilder.com/forum.aspx?aft=10062](https://www.finalbuilder.com/forum.aspx?aft=10062)   
  
 Regards,   
 Paul.