# SQL Server 2012?

**URL:** <https://forum.inductiveautomation.com/t/sql-server-2012/3884>\
**Category:** Archived Topics\
**Created:** [January 19, 2012, 7:24pm UTC](https://forum.inductiveautomation.com/t/sql-server-2012/3884 "2012-01-19T19:24:02Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Greg.Buehler](https://avatars.discourse-cdn.com/v4/letter/g/ecc23a/32.png) [@Greg.Buehler](https://forum.inductiveautomation.com/u/Greg.Buehler)\
**Post date:** [January 19, 2012, 7:24pm UTC](https://forum.inductiveautomation.com/t/sql-server-2012/3884/1 "2012-01-19T19:24:02Z")

</div>

Has anybody tried SQL Server 2012 yet? Any problems or gotchas?

---

<div class="post-metadata">

**Author:** ![Kevin.McClusky](https://avatars.discourse-cdn.com/v4/letter/k/47e85d/32.png) [@Kevin.McClusky](https://forum.inductiveautomation.com/u/Kevin.McClusky)\
**Post date:** [February 15, 2012, 9:17pm UTC](https://forum.inductiveautomation.com/t/sql-server-2012/3884/2 "2012-02-15T21:17:10Z")

</div>

I’ve connected to it, and set up a demo project; seemed to work fine. I haven’t done anything other than using simple db functionality though.

---

<div class="post-metadata">

**Author:** ![gnguyen](https://avatars.discourse-cdn.com/v4/letter/g/41988e/32.png) [@gnguyen](https://forum.inductiveautomation.com/u/gnguyen)\
**Post date:** [May 25, 2012, 10:30am UTC](https://forum.inductiveautomation.com/t/sql-server-2012/3884/3 "2012-05-25T10:30:03Z")

</div>

I confirm. Running actually a SQL2012 Express Advanced with no problem. But still 1.3 gb to dl and install…

---

<div class="post-metadata">

**Author:** ![jrichards](https://avatars.discourse-cdn.com/v4/letter/j/c6cbf5/32.png) [@jrichards](https://forum.inductiveautomation.com/u/jrichards)\
**Post date:** [July 12, 2012, 6:38pm UTC](https://forum.inductiveautomation.com/t/sql-server-2012/3884/4 "2012-07-12T18:38:24Z")

</div>

I’m running SQL2012. We cannot seem to save records to a table that has a trigger. Trigger off, no issues.  
This trigger fires an stored procedure that writes a simple .csv file to a server location. From there, another program see the file and produces a label for bar code.

Anyone help on this would be greatly appreciated. We are working on a “Plan B” right now.

---

<div class="post-metadata">

**Author:** ![Robert](https://avatars.discourse-cdn.com/v4/letter/r/e95f7d/32.png) [@Robert](https://forum.inductiveautomation.com/u/Robert)\
**Post date:** [July 13, 2012, 11:18pm UTC](https://forum.inductiveautomation.com/t/sql-server-2012/3884/5 "2012-07-13T23:18:40Z")

</div>

Does the stored procedure run?

---

<div class="post-metadata">

**Author:** ![jrichards](https://avatars.discourse-cdn.com/v4/letter/j/c6cbf5/32.png) [@jrichards](https://forum.inductiveautomation.com/u/jrichards)\
**Post date:** [July 24, 2012, 2:07am UTC](https://forum.inductiveautomation.com/t/sql-server-2012/3884/6 "2012-07-24T02:07:39Z")

</div>

Sorry, been real busy lately…

the trigger fires, but does not run the stored procedure. We think it is the stored procedure. It used to work in SQL2005.

With the help of the IA guys, we created a script to do the same thing. I don’t know if it is better running from Ignition or off the SQL server, but this way, maintenance can look at the HMI screen and troubleshoot if necessary. Otherwise, they would have to call me.

---

<div class="post-metadata">

**Author:** ![Robert](https://avatars.discourse-cdn.com/v4/letter/r/e95f7d/32.png) [@Robert](https://forum.inductiveautomation.com/u/Robert)\
**Post date:** [July 25, 2012, 10:52pm UTC](https://forum.inductiveautomation.com/t/sql-server-2012/3884/7 "2012-07-25T22:52:13Z")

</div>

Usability and maintainability trump efficiency every time. ![:thumb_right:](https://us1.discourse-cdn.com/inductiveautomation/original/1X/2026e28c0c425034352c1b75807edf956adc75f4.gif ":thumb\_right:")