Activity overview
Latest activity by susanna
Hi @Alex B, Thanks a lot! Kind regards, Susanna / comments
Hi @Alex B,Thanks a lot!Kind regards,Susanna
Hi @Alex B , Thank you so much for your answer and sorry for my late response. I have tried to reproduce the issue with the following quite simple example. I have created a test table and a view and a function depending on it like follows: CREATE TABLE test_table ( column1 NVARCHAR(10) NULL, colum2 NVARCHAR(10) NULL ) GO CREATE VIEW test_view AS SELECT * FROM test_table GO CREATE FUNCTION fn_test_function() RETURNS TABLE AS RETURN SELECT * FROM test_table GO Then I have dropped column2 from test_table. When deploying the last change using SQL Compare, in dependencies tab I can only see the view but not the function. So the view dependent on the table is being refreshed but the function not and is not valid anymore. The version I am currently using is 14.0.0. When I am checking for updates I am getting a message that I am using the most up-to-date version. Many thanks! Susanna / comments
Hi @Alex B ,Thank you so much for your answer and sorry for my late response. I have tried to reproduce the issue with the following quite simple example.I have created a test table and a view and ...