Youth Media Online

To get some more grounding in T-SQL I am going to be working through the 70-433 course material for 2008.  On page xx of the Introduction, the request that you work through the steps on the link:

http://msdn.microsoft.com/en-us/library/cc645923.aspx

While reading through the steps they were a confusing, so, I found myself figuring out this:

1. Launch SQL Server Management Studio.  There is a free copy of a 180 day trial in the book for 70-433.  
2. Connect to the local instance (assuming it is local).
3. Next, start the Configuration Manager.  You can access it by clicking: Start |  All Programs | Microsoft SQL Server 2008 | Configuration Tools | SQL Server Configuration Manager.
4. When the Snap-In lists the various objects, click the SQL Server Services item.  This will display all services running on the server.
5. Right click the one call SQL Server (MSSQLSERVER).  The instance name, here listed as MSSQLSERVER, may be different, but, the SQL Server text is what you need to look for.
6. A SQL Server (MSSQLSERVER) Properties panel will appear.  Select the FILESTREAM tab.
7. Nothing should, by default, be enabled, unless you did some preconfiguration at install time.  Turn on the first checkbox, where the text “Enable FILESTREAM for Transact-SQL access” to enable the others. This will may the first check box, “Enable FILESTREAM for file I/O streaming access”, visible, but, unchecked.
8. I enabled it and left the Windows Share name the same.  When I clicked the Apply button it created the new share.  I had opened the Server Manager to see if the share existed beforehand, and, it did not. After clicking Apply and refreshing the Shares item (found at Computer Management (Local) | System Tools | Shared Folders | Shares, I now saw a new share: MSSQLSERVER with a filepath of \\?\GLOBALROOT\Device\RsFx0102\\MSSQLSERVER.
9. To make life as simple as possible, I also enabled the “Allow remote clients to have streaming access to FILESTREAM data” option, clicked apply and moved on.
10. Finally, I opened SQL Server Management Studio (Start | All Programs | Microsoft SQL Server 2008 | SQL Server Management Studio), opened a new query and added the following: 
11. EXEC sp_configure filestream_access_level, 2
    RECONFIGURE
12. When I was done I F5 and everything successfully.  It printed the following the Messages tab, “Configuration option ‘filestream access level’ changed from 0 to 2.  Run the RECONFIGURE statement to install.

To get some more grounding in T-SQL I am going to be working through the 70-433 course material for 2008.  On page xx of the Introduction, the request that you work through the steps on the link:

http://msdn.microsoft.com/en-us/library/cc645923.aspx

While reading through the steps they were a little confusing, so, I found myself figuring out this:

1. Launch SQL Server Management Studio.  There is a free copy of a 180 day trial in the book for 70-433.  
2. Connect to the local instance (assuming it is local).
3. Next, start the Configuration Manager.  You can access it by clicking: Start |  All Programs | Microsoft SQL Server 2008 | Configuration Tools | SQL Server Configuration Manager.
4. When the Snap-In lists the various objects, click the SQL Server Services item.  This will display all services running on the server.
5. Right click the one call SQL Server (MSSQLSERVER).  The instance name, here listed as MSSQLSERVER, may be different, but, the SQL Server text is what you need to look for.
6. A SQL Server (MSSQLSERVER) Properties panel will appear.  Select the FILESTREAM tab.
7. Nothing should, by default, be enabled, unless you did some preconfiguration at install time.  Turn on the first checkbox, where the text “Enable FILESTREAM for Transact-SQL access” to enable the others. This will may the first check box, “Enable FILESTREAM for file I/O streaming access”, visible, but, unchecked.
8. I enabled it and left the Windows Share name the same.  When I clicked the Apply button it created the new share.  I had opened the Server Manager to see if the share existed beforehand, and, it did not. After clicking Apply and refreshing the Shares item (found at Computer Management (Local) | System Tools | Shared Folders | Shares, I now saw a new share: MSSQLSERVER with a filepath of \\?\GLOBALROOT\Device\RsFx0102\\MSSQLSERVER.
9. To make life as easy as possible, I also enabled the “Allow remote clients to have streaming access to FILESTREAM data” option, clicked apply and moved on.
10. Finally, I opened SQL Server Management Studio (Start | All Programs | Microsoft SQL Server 2008 | SQL Server Management Studio), opened a new query and added the following: 
11. EXEC sp_configure filestream_access_level, 2
    RECONFIGURE
12. When I was done I punch F5 and everything finished successfully.  It printed the following the Messages tab, “Configuration option ‘filestream access level’ changed from 0 to 2.  Run the RECONFIGURE statement to install.

online canadian pharmacy

• configuration option filestream access level changed from 2 to 2 run the reconfigure statement to install