InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 00:08:05 GMT20http://www.sqlservercentral.com/Forums/Topic1411076-391-1.aspxAlso syscomments is depreciated, use sys.sql_modules insteadThu, 24 Jan 2013 05:34:18 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1411076-391-1.aspxyou want to use the system view sys.synonyms, instead, which has everything you need:[code]select * from sys.synonyms--rebuilding the command:select 'CREATE SYNONYM ' + quotename(SCHEMA_NAME(schema_id)) +'.' + quotename(name) --ie MyView + ' FOR ' + base_object_name --ie [SandBox].[dbo].[VW_FIXEDWIDTH]FROM sys.synonyms --Results:/*CREATE SYNONYM [dbo].[MyView] FOR [SandBox].[dbo].[VW_FIXEDWIDTH]*/[/code]Thu, 24 Jan 2013 05:29:44 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1411076-391-1.aspxI have created a synonym as followsCREATE SYNONYM [dbo].[ms4] FOR [local].[Northwind].[dbo].[Products]GOand then i want to retrieve a same SQL definition statement from one of the system/db's view so i firedselect text from syscomments where id = object_id('dbo.[ms4]')but 'text' from syscomments returns text for all other types other then synomymsyscomments contains entries for each view, rule, default, trigger, CHECK constraint, DEFAULT constraint, and stored procedure within the database. The text column contains the original SQL definition statements. so from which table/view i can get original SQL definition statements for synonym. Its not there in syscomments . so where is they stored?Thu, 24 Jan 2013 05:23:10 GMTs_v_joshi