The Connection Properties dialog opens. For my sample ITworld application, I changed the data source to Microsoft SQL Server (SQLClient), and entered the necessary Server, Log On, and database values.

The connection remains in effect until you issue a DISCONNECT statement or terminate the SQL procedure. Using the CONNECT statement is optional for some DBMSs. However, ... also known as an attach, to ...

Launch your SQL Server Management Studio. Click the standard toolbar and then choose the activity monitor. Locate the session identification number in your activity monitor for the connection you ...

Windows 7 includes an ODBC manager that lets you connect from your desktop to a SQL server. You create a data source name (DSN) to save database setup information, so you can open a connection to th.