Restrict Anonymous Users to view Form Pages in MOSS 2007

If you enable the anonmous access in MOSS 2007 Site. The anonmous user will able to access the form pages like: http://server/pages/forms/allitems.aspx

If you want to restrict anonymous users to access those default form pages.

Enable the ViewFormsPagesLockdown Feature to restrict anonymous users to access the site

Syntax: stsadm.exe -o activatefeature -url -filename

Example: […]

How to Display RowNumber with Select Query in SQL Server 2005

rownumber() function is used to return the rownumber with select query

The Follwoing query will return the result set row number

Syntax ROW_NUMBER ( ) OVER ( [ ] )

Example Select row_number() over(order by productid) as SlNo,productname,unitprice from products

Live ASP.Net & VSTS Webcast for November 2007

Register Now for Free (limited seats available) and mark you calendar for three webcast series on Secure Data Access, Visual Studio Team System series and ASP.Net.

1. Secure Data Access We explore the new Data Encryption Toolkit for Mobile PCs, technical guidance and deployment tools that help you plan and implement EFS and BitLocker™ […]

Visual Studio 2008 and .NET 3.5 Released

Visual Studio 2008 and .NET 3.5 Released Today Microsoft shipped Visual Studio 2008 and .NET 3.5. You can download the final release using one of the links below:

If you are a MSDN subscriber, you can download your copy from the MSDN subscription site (note: some of the builds are just finishing being uploaded now […]

RollBack Transaction in SQL Server 2005

SQL Server 2005 newly intoduced the way to rollback the transactions in SQL Server 2005

SET XACT_ABORT ON

when XACT_ABORT is on. The T-SQL statements will automatically rollback the transaction when error occured in statements.

SET XACT_ABORT ON

USE Emp Begin Tran Insert into EmpInfo Values(1) Insert into EmpInfo Values(1) — This statement will raise […]

WSS 3.0 Permission Levels

By Default Windows SharePoint Services 3.0 provides the following permission levels:

Read -> In this level, a user can only view a site. Contribute -> In this level, a user can view, add, update, and delete the site content. Design -> In this level, a user can view, add, update, delete, approve, and customize the […]

Performance Point Server 2007 Available for Download

Microsoft Finally Announced the Public Release of Performance Point Server 2007

Microsoft Office PerformancePoint Server 2007 is now generally available. Product Information: Available in both 32 and 64 bit editions Evaluation editions are available are available on the Microsoft Download Center:

32 bit edition (http://www.microsoft.com/downloads/details.aspx?FamilyId=6372C24F-67DD-42DD-B034-748907B23420&displaylang=en)

64 bit edition (http://www.microsoft.com/downloads/details.aspx?FamilyId=3ADAC793-DEF0-4BA8-A9AB-228979B8DB40&displaylang=en)

Enterprise editions are available for MSDN/TechNet […]

Microsoft Technical Roll Up – November 2007

Hi, I got the follwing Technical Rollup information from Microsoft MVP Communitiy. Please make use of it.

Please find the latest Technical Rollup mail below. Feel free to share this with your communities. Quick Links Security – Platforms – Internet – SQL Server – Unified Comms – Manageability The TRM blog can be found here […]