MS SQL / Visual Studio - EXPORT TABLE or VIEW with records into sql statement

In Visual Studio go to view/Server explorer.
Right click on database (you may need to create new connection if required) and select publish to provider.
Click next and select RJM BackOffice, uncheck script all objects.
Click Views then next
Select View then next
Script to file then next
Script for target database - you may need to select 2000
Next and finish.

MS SQL - Rebuild All Indexes

MS SQL - Rebuild All Indexes

MS SQL - Edit more then 200 records

- select Edit top 200 records.
- right click/Pane/SQL
- modify sql (top 300) order by, etc.