Viewing 2 posts - 1 through 2 (of 2 total)
If you did want the user to be able to do this without giving the user rights to the table you can use the EXECUTE AS clause in the stored...
February 28, 2011 at 1:49 am
#1292186
Having done this for many years, I found the best way of doing this is by using Redgate's SQL Compare:
http://www.red-gate.com/products/sql-development/sql-compare/
February 28, 2011 at 1:46 am
#1292184