Many people have this question “Does Sharepoint gets installed on Vista?”. The answer is yes. I installed MOSS on my Vista machine yesterday successfully.

All you need to install Sharepoint, WSS or MOSS, on Vista is

• You must select the Advanced option during install.
• If you want to run on SQLExpress, manually install it first.  Get it here.
• You have to manually enable IIS7 with the proper options. Web Management Tools and World Wide Web Services. Enable at least the following options in IIS.

Download Vista Helper file from here, and run the setup file WssVista.msi.

Sharepoint on Vista

You will see an UAC prompt select Continue to proceed with the installation.

Once the install has completed you will find the SetupLauncher.exe in the install location you selected. If you didn’t change the default option you will see it under the directory ..\Program Files\WssOnVista\

Sharepoint on Vista

Before starting the setup make sure you have enabled IIS with the following options, Web Management Tools and World Wide Web Services. Enable at least the following options and choose OK.

To set this Go to Control Panel and click Programs. Under Program and Features click Turn Windows features on or off.

Sharepoint on Vista

After completing the above steps it’s time for the interesting part. Locate SetupLauncher.exe and start it. You will once again see an UAC prompt, select Continue.

Sharepoint on Vista

After the SetupLauncher run, select the WSS installation file Sharepoint.exe, or the MOSS installation file, and click OK.  First, the package will be extracted.

Sharepoint on Vista

After the files have been extracted the WSS setup program will be started.

Sharepoint on Vista

The current version only supports the advanced installation option so select that one.

Sit back and relax while SharePoint is being installed, you are running Vista remember

Once installed you can configure your Sharepoint setup.

Sharepoint on Vista

Let the Configuration Wizard do it’s work.

Sharepoint on Vista

The final result is WSS running on Vista, Enjoy!

Sharepoint on Vista

Resource:

Bamboo Solutions

You can find more on their forums. Enjoy!!!

Today I just got went though this, this helps you to execute a string in SQL. This is how you can execute a string in SQL,

Declare @query Varchar(500)

Set @query = ‘Select * From Employees’

Exec (@query)

OR

EXEC (‘USE AdventureWorks; SELECT EmployeeID, Title FROM HumanResources.Employee;’)

This way you can execute a string in SQL.

This is extremely helpful when you need to add the Where clause based on some criteria. You can have your query in a string and based on that criteria you can append the clause in that string and finally execute the string at the end. This works perfectly.

However this does not work if you want to execute the query and get the result in the Dataset in your .Net application. For that you need to create a #Temp table execute the string and get the result in the #Temp table and then fire the select again on your #Temp table.

Note: Don’t forget to get the brackets ( & ) around your query else SQL will throw an error, Unrecognized stored procedure.