MS SQL Server Not Updating Column Names
-
Hi, I am using MS SQL Server 2008 Express. I have a product table with columns Id and Name. I changed these columns to ProductId and ProductName. In my stored procedure it's not finding ProductId and ProductName, but rather Id and Name. And now it underlines ProductId and ProductName in red. How do I update it so that it sees these columns? Regards, Brendan
-
Hi, I am using MS SQL Server 2008 Express. I have a product table with columns Id and Name. I changed these columns to ProductId and ProductName. In my stored procedure it's not finding ProductId and ProductName, but rather Id and Name. And now it underlines ProductId and ProductName in red. How do I update it so that it sees these columns? Regards, Brendan
Try this, Right Click the Tables branch in the Server Explorer. Click Refresh. Open the branch for the changed tables - have the changes taken? On the Edit Menu - Click on Intellisense/Refresh Local Cache. Does this help?
I don't speak Idiot - please talk slowly and clearly 'This space for rent' Driven to the arms of Heineken by the wife
-
Try this, Right Click the Tables branch in the Server Explorer. Click Refresh. Open the branch for the changed tables - have the changes taken? On the Edit Menu - Click on Intellisense/Refresh Local Cache. Does this help?
I don't speak Idiot - please talk slowly and clearly 'This space for rent' Driven to the arms of Heineken by the wife
Andy_L_J wrote: Right Click the Tables branch in the Server Explorer. Click Refresh. Nope this does not work. Andy_L_J wrote: Open the branch for the changed tables - have the changes taken? Where do I find this? Andy_L_J wrote: On the Edit Menu - Click on Intellisense/Refresh Local Cache. There is no intellisense option from which to choose. From where are you directing me, from SQL Server Management Studio 2008?
-
Hi, I am using MS SQL Server 2008 Express. I have a product table with columns Id and Name. I changed these columns to ProductId and ProductName. In my stored procedure it's not finding ProductId and ProductName, but rather Id and Name. And now it underlines ProductId and ProductName in red. How do I update it so that it sees these columns? Regards, Brendan
-
Andy_L_J wrote: Right Click the Tables branch in the Server Explorer. Click Refresh. Nope this does not work. Andy_L_J wrote: Open the branch for the changed tables - have the changes taken? Where do I find this? Andy_L_J wrote: On the Edit Menu - Click on Intellisense/Refresh Local Cache. There is no intellisense option from which to choose. From where are you directing me, from SQL Server Management Studio 2008?
Did Ashcroft' answer help? You will have to change all references to these field names in all Functions and Stored Procedues that call them in code.
I don't speak Idiot - please talk slowly and clearly 'This space for rent' Driven to the arms of Heineken by the wife