# How can I use a variable in SQL Server Action?

**URL:** https://www.finalbuilder.com/forums/t/how-can-i-use-a-variable-in-sql-server-action/1971
**Category:** Discussion
**Created:** [April 19, 2012, 6:15am UTC](https://www.finalbuilder.com/forums/t/how-can-i-use-a-variable-in-sql-server-action/1971 "2012-04-19T06:15:46Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![valve1900](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/v/edb3f5/32.png) [@valve1900](https://www.finalbuilder.com/forums/u/valve1900)
#### Post date: [April 19, 2012, 6:15am UTC](https://www.finalbuilder.com/forums/t/how-can-i-use-a-variable-in-sql-server-action/1971/1 "2012-04-19T06:15:46Z")

</div>

I am using final builder 7.

I set my database name into a variable, %DatabaseName%. And I put the %DatabaseName into database field in a Set Access Mode action.

Then I got error:

Could not restore backup: Incorrect syntax near ‘%’

&nbsp;

But if I directly put database name, it works fine. Is it possible to use a variable in SQL Server Action?

[http://i39.tinypic.com/mww4s6.jpg](http://i39.tinypic.com/mww4s6.jpg)

&nbsp;

Thanks.

---

<div class="post-metadata">

### Author: ![Vincent](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/vincent/32/938_2.png) [@Vincent](https://www.finalbuilder.com/forums/u/Vincent)
#### Post date: [April 20, 2012, 12:51pm UTC](https://www.finalbuilder.com/forums/t/how-can-i-use-a-variable-in-sql-server-action/1971/2 "2012-04-20T12:51:56Z")

</div>

Hi   
  
 That looks like a bug, I’ll post here with a link to a new build a the fix later today.

---

<div class="post-metadata">

### Author: ![valve1900](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/v/edb3f5/32.png) [@valve1900](https://www.finalbuilder.com/forums/u/valve1900)
#### Post date: [April 20, 2012, 2:03am UTC](https://www.finalbuilder.com/forums/t/how-can-i-use-a-variable-in-sql-server-action/1971/3 "2012-04-20T02:03:34Z")

</div>

Thanks for reply. Also, please check the Password and Username field of SQL actions, neither of them accepts variables. &nbsp;But Server name field works fine.

&nbsp;

Thanks.

---

<div class="post-metadata">

### Author: ![Vincent](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/vincent/32/938_2.png) [@Vincent](https://www.finalbuilder.com/forums/u/Vincent)
#### Post date: [April 20, 2012, 7:08am UTC](https://www.finalbuilder.com/forums/t/how-can-i-use-a-variable-in-sql-server-action/1971/4 "2012-04-20T07:08:08Z")

</div>

Hi   
  
 This build has the fix : [http://downloads.finalbuilder.com/downloads/finalbuilder/700/FB700\_1847.exe](http://downloads.finalbuilder.com/downloads/finalbuilder/700/FB700_1847.exe)   
  
 I could only find one action where the password field didn’t expand variables, can you tell me which actions you tried where it didn’t expand the variables?

---

<div class="post-metadata">

### Author: ![valve1900](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/v/edb3f5/32.png) [@valve1900](https://www.finalbuilder.com/forums/u/valve1900)
#### Post date: [April 24, 2012, 9:46am UTC](https://www.finalbuilder.com/forums/t/how-can-i-use-a-variable-in-sql-server-action/1971/5 "2012-04-24T09:46:43Z")

</div>

I have installed this new version and all of problem has been solved.   
  
 Thanks