Right click your database in your server, and select Tasks > Generate Scripts. At Introduction step, click Next. At Choose Objects, you can either select either the entire database (including functions, and etc) or specify what objects you want to generate. In your case, you should select Script entire databases and all database objects then … Read more
Go to Tools > Options > Environment > Keyboard / General. In the middle box, Select Window.ShowResultsPane Change the Use new shortcut dropdown to SQL Query Editor (Global did not work for me) Put your cursor in the “Press shortcut keys:” box and hit CTRL + R. You should see the following: Click Assign and … Read more
Well, glad I asked. The solution I finally discovered was here: How do I configure SQL Server Express to allow remote tcp/ip connections on port 1433? Run SQL Server Configuration Manager. Go to SQL Server Network Configuration > Protocols for SQLEXPRESS. Make sure TCP/IP is enabled. So far, so good, and entirely expected. But then: … Read more