Tuesday, August 21, 2018

Querying SQL Server 2017 Version 17.3 using SQLOPS

 There are already system databases. Make sure that the server has started. Start it if it has not started in Control Panel, or otherwise.

I have a default instance of SQL Server 2017 Verion 17.3 and I connect to it as described here.

Launch SQLOPS from its shortcut and click New Connection as shown


SQLServer17SQLOPS_0

The New Connection window opens as shown.


SQLServer17SQLOPS_1

Enter the items as shown.


SQLServer17SQLOPS_3

Click Connect.
You are connected as shown.



Click New Query to open a new query window as shown.


SQLServer17SQLOPS_6

Type S and a drop-down list appears.


SQLServer17SQLOPS_7

Complete a query as shown:

SELECT @@version


SQLServer17SQLOPS_8

Click Run and review the result as shown:


SQLServer17SQLOPS_9

Right click the result, copy and paste it in Notepad as shown:

Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64)  Aug 22 2017 17:04:49  Copyright (C) 2017 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Pro Insider Preview 10.0 (Build 17025: ) (Hypervisor)

Note: It was mentioned that you type in msdb as a database. In fact just localhost is all that is neccessary to connect.

No comments:

Post a Comment

Do you know what you installed while custom installing SQL Server 2022?

 When you install any software in Windows OS, the key information gets into the Registry and some of which you can look up in the control pa...