The title says it all folks. Microsoft SQL Server 2008 R2 has now been released to manufacturing. The article says it will be available by download within the next couple of weeks.

However I went to the SQL 2008 R2 home page and clicked the try now button. I’m downloading something. I hope its not the CTP. I guess we will see when its done.

Hers the link the the SQL Server Blog

http://blogs.technet.com/dataplatforminsider/archive/2010/04/21/sql-server-2008-r2-released-to-manufacturing.aspx

As I am normally on my development machine I want to be able to run any PowerShell scripts as I need. By default I cannot do this because the Execution Policy for PowerShell is set to Restricted By Default.

There are 4 policies:

1. Restricted
2. AllSigned
3. RemoteSigned
4. Unrestricted

To see the current policy of your machine use the following command:
Get-ExecutionPolicy

To set the policy so you can run your all your scripts use the following command.
Set-ExecutionPolicy Unrestricted

By switching to this policy you make your system less secure. Probably not recommended for production machines.

See the Following URL for more information: http://technet.microsoft.com/en-us/library/ee176961.aspx

Today when I was trying to do a FullTextSqlQuery and I got the following error. It was very strange.

“Microsoft.SharePoint.SPException: Your search cannot be completed because this site is not assigned to an indexer. Contact your administrator for more information. at Microsoft.SharePoint.Search.Query.Query.CreateQueryProxy(SPSite site) at Microsoft.SharePoint.Search.Query.Query..ctor(SPSite site)”

After some research I found that I needed to change the reference Microsoft.SharePoint.Search.Query to Microsoft.Office.Server.Search.Query. After I did that the problem was fixed.

Microsoft.SharePoint.Search.Query must be for SharePoint Foundation 2010 and Microsoft.Office.Server.Search.Query for SharePoint Server 2010. So it makes sense.