Querying SQL Server data in SBS 2003 [Windows Small Business Server 2003 Best Practices book excerpt]

Hello there – harrybbbb here – author for the SBS 2003 book. Today I am posting up a SQL query procedure in the SBS realm as part of the Daily virtual book reading. Enjoy!

Query the Data

You will now query the SSLDOG database, much like a client application does. Why? Because in and of itself, a table populated with data is relatively worthless. For your relationship with SQL Server to have true value, you must use the information. That’s an action verb, as in query. Thus, after populating a table with information, you will query it to return the information in a synthesized or value-added form. And that’s essentially the database food chain.

 Visit http://www.smbnation.com for additional SMB and SBS book, newsletter and conference resources.

Chapter 14 Database Management With SQL Server 2000

1                    Log on to the SBS server machine as Administrator with the pass­word Husky9999!

2                    Click Start, All Programs, Microsoft SQL Server, Enterprise Manager.

3                    Expand the following objects in the left pane: Microsoft SQL Serv­ers, SQL Server Group, SPRINGERS1 (Windows NT).

4                    Select and expand the SSLDOG database.

5                    From the Tools menu, select SQL Query Analyzer. The SQL Query Analyzer program launches.

6                    A Query window appears inside of the SQL Query Analyzer appli­cation. In the SQL Query Analyzer toolbar, confirm that SSLDOG appears in the database drop-down menu (upper right in Query win­dow). If not, select SSLDOG from the database drop-down menu.

7                    In the Query window, click the blank space in the upper-left part of the screen and type the following command: select * from tracking. This is shown in Figure 14-10.

 

Figure 14-10

Creating a select statement in SQL Server 2000 to query the SSLDOG database and, specifically, the Tracking table.

 Visit http://www.microsoft.com/technet for the latest updates for any Microsoft product.

14-26

Section 4 SBS 2003 Premium Edition

8.         Select Execute from the Query menu (you can also press F5 or click the green right arrow on the Query window toolbar). The contents of the Tracking table are returned to you, as seen in Figure 14-11.

Figure 14-11

Successful query against Tracking with result returned to the display.

9.         Close SQL Query by selecting File, Exit. Select No when the SQL Query Analyzer dialog box asks if you want to save the query (named Untitled1 by default).

 

cheers…harrybbbb

Harry Brelsford, CEO at smb nation www.smbnation.com

Microsoft Small Business Specialist SBSC, MBA, MCSE, MCT, MCP, CNE, CLSE, CNP

PS – did u know I host a technology conference in the New York City area each spring? Save the date for March 6-8, 2009 and watch “voice meet data” in the SMB space!

PPS – my SBS 2008 book will be out in mid-November 2008!

PPPS – my Microsoft Response Point Primer book is here NOW!

Advertisements

Leave a comment

Filed under Book

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s