![toad sql server show rows affected toad sql server show rows affected](https://www.quest.com/images/video/medium/how-to-generate-test-data-in-toad-for-sql-server8121596-medium.jpg)
Probably best to use the SSIS tool for that if you have that installed? Other people here may have suggests on how you can best export your database to Excel, given that you have zero knowledge of the tools available and how to use them it would clearly help if you have the "easiest" method, starting from that base. Once you have decided on which tables you are interested in then you can export them to Excel. Which will show you the first 100 rows (i.e. If you see a schema / table that you like the look of type: SELECT TOP 100 *
![toad sql server show rows affected toad sql server show rows affected](https://devstyle.pl/wp-content/uploads/2009/03/Toad-for-MS-SQL-Server-รข%C2%80%C2%93-alternatywa-dla-Management-Studio.jpg)
Once you are connected to the right database you can see what schema and tables it contains: SELECT = S.name + '.' + T.name
![toad sql server show rows affected toad sql server show rows affected](https://res.cloudinary.com/dmsxwwfb5/image/upload/v1601039715/compare-database-red-gate-min.png)
Then you can "connect" to that database with: USE YourDatabaseName Hopefully there is just one other name, and that will be your database. Ignore "master", "tempdb", "model" and "msdb". Start your SQL tool and use this command to view the database names: SELECT name However, the fact that the script finished showing all "1 rows affected" messages is a good sign - the script most likely did create a database. so you won't know if all rows were successfully inserted. You probably were not able to see any error messages during the running of the script. Presumably your SQL script already did that, otherwise you would have seen errors when the script ran (but it appears from your screen shot that you have "1 rows affected" messages, which probably means that a row was inserted into a database's table.