Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  freaky problem creating stored proc in VB

Author  Topic  dosele Starting Member 1 Post Posted - 2001-02-09 : 06:12:28 This freaks me out. I've created a Dynamic Stored Procedure in SQL Server. It works just fine through Query Analyser. So I copy/pasted the code in VB and altered it a bit so that I could create the procedure in VB. When I run the VB code, the procedure is created just fine. In fact - it looks identical. Here's what freaks me out. When I run the VB-created SP in Query Analyser it returns: "The name 'whatever' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted." Get this - I simply go into SQL Server, open the SP, delete the double quotes and replace with double quotes again, Click Apply, goto Query Analyser and it works. Can anyone explain this to me?