tag:blogger.com,1999:blog-4291664034828038593.post3809630537231204522..comments2010-01-19T11:38:03.991ZComments on Strictly Software: Using SYNONYMs in SQL 2005R Reidhttp://www.blogger.com/profile/05430306492065347012noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-4291664034828038593.post-70136065749071621412010-01-19T11:38:03.991Z2010-01-19T11:38:03.991ZWell the article you just commented on is all abou...Well the article you just commented on is all about using SYNONYMs to do just that, switching SYNONYMs between two tables.<br /><br />You just need to use the CREATE and DROP statement to drop the old pointer and the create the new pointer.<br /><br />Example code is:<br /><br />DECLARE @SYNONYM varchar(100)<br /> ,@SQL varchar(1000)<br /><br />-- set name of SYNONYM<br />SELECT @SYNONYM = 'R Reidhttp://www.blogger.com/profile/05430306492065347012noreply@blogger.comtag:blogger.com,1999:blog-4291664034828038593.post-26903918823031656822010-01-18T21:02:07.288Z2010-01-18T21:02:07.288ZDo you have any useful t-sql for swapping synonyms...Do you have any useful t-sql for swapping synonyms between table_a and table_b after determining which table the synonym is referencing?Bobhttp://www.blogger.com/profile/02045310713910044770noreply@blogger.com