Adding and Accessing a SQL Server 2005 Express Database

To get the latest-and-greatest view of everything about your SQL Server 2005 Express instance, right-click anywhere on the Object Explorer tree and choose Refresh. The Query window The Query window is where you and SQL Server 2005 Express get to know each other, up close and personal. The workspace contains input windows (described as the Query Editor) for queries and other data interaction. You can also elect to have your output show up at the bottom of the screen in the area (described as the Output window). You can create as many Query Editor windows as you need simply by clicking the New Query icon on the Standard toolbar. When you’re comfortable working in the workspace, you can decide how and where you want your results to appear. You have three options; click one of these icons at the top of the window: