iainelder/repro_for_synonym_chaining_is_not_allowed.sql

## repro_for_synonym_chaining_is_not_allowed.sql
CREATE SYNONYM first_link FOR second_link;

CREATE SYNONYM second_link FOR third_link;

CREATE TABLE third_link (a INT);

-- Msg 470, Level 16, State 1, Line 7
-- The synonym "first_link" referenced synonym "second_link". Synonym chaining is not allowed.
SELECT *
FROM first_link;
	CREATE SYNONYM first_link FOR second_link;

	CREATE SYNONYM second_link FOR third_link;

	CREATE TABLE third_link (a INT);

	-- Msg 470, Level 16, State 1, Line 7
	-- The synonym "first_link" referenced synonym "second_link". Synonym chaining is not allowed.
	SELECT *
	FROM first_link;