There may be situations when you want to get all of the tables in a SQL Server database and the data they currently hold, but you can't (because of permissions assigned to your account, for example) or don't want to backup the whole database. Well, follow the following steps to achieve this: 1- Open SSMS … Continue reading Get tables and their data without backing up the database: SQL Server 2008 R2 →