Tag: SQL Server
-
Problem: I always need to open SQL Server using my admin account but I don’t want to keep on doing right click + run as different user, then type my admin username and super long admin password. My solution? I created a shortcut that launches SQL Server using a different user. Now all I have… Continue reading
-
In case you want to export all the rows in a table as insert statements, here’s how to do it: 1. Open MS SQL Server Management studio and login to your desired database server 2. Right click database >> Tasks >> Generate Scripts 3. Choose Objects: Select specific database objects >> Select the table you… Continue reading