Shrink SQL Server Database

Method 1

ALTER DATABASE DatabaseName SET RECOVERY SIMPLE
use DatabaseName
GO
CHECKPOINT
GO
DBCC SHRINKFILE(transactionloglogicalfilename,TRUNCATEONLY)
GO
ALTER DATABASE DatabaseName SET RECOVERY FULL

Method 2

USE DatabaseName
GO
ABCC SHRINKFILE(, 1)
BACKUP LOG WITH TRUNCATE_ONLY
ABCC SHRINKFILE(, 1)
GO

PIVOT TABLE and SQL Query

Basic Example for PIVOT:
SELECT gid,
[1] AS cname1,
[2] AS Cname2,
[3] AS Cname3,
[4] AS Cname4,
[5] as Cname5
FROM
(SELECT gid,gpid,gpname,Name FROM test) s
PIVOT
(
MAX(Name)
FOR gname IN ([1],[2],[3],[4],[5])
) p
ORDER BY [gid]
GO

"Your Computer could not connect to another console session on the remote computer because you already have a console session in Progress"

Use Remote Desktop when Windows Firewall is on Because Windows Firewall restricts communication between your computer and the Internet, you might need to change settings for Remote Desktop Connection so that it can work properly. Click to open Windows Firewall. In the left pane, click Allow a program or feature through Windows Firewall. Click Change settings. If you're prompted for an administrator password or confirmation, type the password or provide confirmation. Under Allowed programs and features, select the check box next to Remote Desktop, and then use the check boxes in the columns to select the network location types you want to allow communication on. Click OK.

windows sharepoint search service existing database name changed

Resolution: Rename the database "WSS_Search_MIG" to some other name. SharePoint is trying to create a new search database and find the file already exists so its not able to overwrite the schema of that database.

And start the Search Service from Central Administration -> Operations -> Services on server -> Click on the Windows Sharepoint Services Search service.

Sharepoint interview Questions part 1

1.What is the difference between an Internet and an intranet site?
An internet site is a normal site that anyone on the internet can access (e.g., http://www.msn.com/, http://www.microsoft.com/, etc.). You can set up a site for your company that can be accessed by anyone without any user name and password.
An intranet (or internal network), though hosted on the Web, can only be accessed by people who are members of the network। They need to have a login and password that was assigned to them when they were added to the site by the site administrator.

2. What are the advanced features of MOSS 2007?
* User Interface (UI) and navigation enhancements * Document management enhancements * The new Workflow engine * Office 2007 Integration * New Web Parts * New Site-type templates * Enhancements to List technology * Web Content Management * Business Data Catalog * Search enhancements * Report Center * Records Management * Business Intelligence and Excel Server * Forms Server and InfoPath * The “Features” feature * Alternate authentication providers and Forms-based authentication

3. How can I raise the trust level for assemblies installed in the BIN directory?
Windows SharePoint Services can use any of the following three options from ASP.NET and the CLR to provide assemblies installed in the BIN directory with sufficient permissions. The following table outlines the implications and requirements for each option.
Option Pros Cons
Increase the trust level for the entire virtual server. For more information, see "Setting the trust level for a virtual server" Easy to implement.
In a development environment, increasing the trust level allows you to test an assembly with increased permissions while allowing you to recompile assemblies directly into the BIN directory without resetting IIS. This option is least secure.
This option affects all assemblies used by the virtual server.There is no guarantee the destination server has the required trust level. Therefore, Web Parts may not work once installed on the destination server.
Create a custom policy file for your assemblies. For more information, see "How do I create a custom policy file?" Recommended approach.
This option is most secure.
An assembly can operate with a unique policy that meets the minimum permission requirements for the assembly.
By creating a custom security policy, you can ensure the destination server can run your Web Parts.
Requires the most configuration of all three options.Install your assemblies in the GAC
Easy to implement. This grants Full trust to your assembly without affecting the trust level of assemblies installed in the BIN directory.
This option is less secure.
Assemblies installed in the GAC are available to all virtual servers and applications on a server running Windows SharePoint Services. This could represent a potential security risk as it potentially grants a higher level of permission to your assembly across a larger scope than necessary
In a development environment, you must reset IIS every time you recompile assemblies.
Licensing issues may arise due to the global availability of your assembly.

Sharepoint Real time Interview Questions

1.What are the different systems to connect business data catalog?
2.Can we connect MS Acees to BDC? Or not?
3.Business Data catalog write back to SQL database?
4.Have u used features?