Thanks for the reply!

I actually got SQL Server 2012 Express installed without any problems. That is all I need, I will not be doing any designing or admin tasks on...

Thanks for the help! I see the error of my ways!!

I made things difficult for myself by copying an SP I wrote at work. That SP does not do...

bteraberry (3/25/2010)

---

If you have .NET 3.5 and SQL 2008 you can use a table valued parameter to pass the whole table of what you want updated all at the same...

The Sub CheckLawsonHoldRecord is just doing a simple SQL select over the AS400 table to confirm that the Company, Vendor, Invoice key combo has been inserted by the AS400 SP...

Ok, this is totally driving me nuts!! I have NEVER had a problem like this before!!!

Once again the code and the SP all work fine when executed from my...

Ok, so the SQL DBA had me add "SET NOCOUNT ON", in all my SP's. That definitely helped as the bit field column started getting updated.

I also added...

I will try out your changes for the SP, ASAP. Right now I am working with the SQL DBA.

Here is the sub in VB.Net code that calls this SP:

Public...

Thanks for the replies, I am going to try out the suggestion in that article (from the link). If anyone else has any other ideas please do let me know.