Hi,

I added a new table to the customer SQL Server database. The script of adding a table is executed without errors. And I do see this table in the DB.
Then I modified a stored procedure to add a record to this table, as follows:

		IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES 
           WHERE TABLE_NAME = N'mobile_web_log')
			BEGIN
			  INSERT INTO mobile_web_log (user_name, date_time, order_no, tran_type) values 
			    (@UserName, GETDATE(), @nOrderNo, '0')	
			END  

Executing the Modify of the SP completed without errors.

But when I Create a script of this SP the name 'mobile_web_log" and the fields in this table appear with red squiggly underline. And hovering mouse of the 'mobile_web_log' shows "Invalid object name". Why?

TIA