Changing Account/Password Policy on Windows Server 2003


Windows Server 2003 requires Secure and complex password. If you want to disable this policy you must follow these tasks

  1. Go to the management console:
  2. Start > run > type MMC > enter.
  3. Click on file > add/remove snap-in.
  4. In the add/remove snap-in window click the add button.
  5. In the Add standalone snap-in window scroll down and highlight Group Policy Object Editor and click add.
  6. In the Select Group Policy Object window make sure or browse and choose the Local Computer group policy object is chosen and click finish. click close then click OK for the next to boxes.In the console window, expand Local Computer Policy, expand Computer Configuration, expand Windows Settings, expand Security Settings, then expand Account Policies.
  7. Setting for 5 try’s for a correct password is under the Account Lockout Policy and Setting for not use a complex password structure is under Password Policy.This would be for the local machine. If the users are logging into the domain then you will need to change the Domain group policy.

Query to Get Information About Enterprise Calendars


If your Project server environment has enterprise calendars you can collection information about all the calendars from project server database.

The Query below collects information from MSP_Calendars, MSP_Calendars_Data, MSP_Projects tables of project server data and show information about each calendar separately.

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[INTECHCalenders]’) and OBJECTPROPERTY(id, N’IsUserTable’) = 1)

    drop table [dbo].[INTECHCalenders]

    print ‘table deleted’

GO

SELECT DISTINCT dbo.MSP_CALENDARS.CAL_NAME, dbo.MSP_CALENDARS.Cal_UId

INTO INTECHCalenders

FROM dbo.MSP_CALENDARS INNER JOIN

dbo.MSP_PROJECTS ON dbo.MSP_CALENDARS.PROJ_ID = dbo.MSP_PROJECTS.PROJ_ID CROSS JOIN

dbo.MSP_CALENDAR_DATA

WHERE (dbo.MSP_PROJECTS.PROJ_ID = 207)

Delete from INTECHCalenders Where CAl_name is NULL

DECLARE @Cal_UId varchar(10)

DECLARE CAL_Cursor CURSOR FOR

SELECT CAL_UID FROM INTECHCalenders

OPEN CAL_Cursor

FETCH FROM CAL_Cursor

WHILE @@FETCH_STATUS = 0

BEGIN

FETCH CAL_Cursor INTO @Cal_UId

    SELECT dbo.MSP_CALENDAR_DATA.CAL_UId, dbo.MSP_CALENDAR_DATA.CD_WORKING, dbo.MSP_CALENDAR_DATA.CD_FROM_DATE, dbo.MSP_CALENDAR_DATA.CD_TO_DATE,

dbo.MSP_CALENDAR_DATA.CD_TO_TIME1, dbo.MSP_CALENDAR_DATA.CD_FROM_TIME1, dbo.MSP_CALENDAR_DATA.CD_FROM_TIME2,

dbo.MSP_CALENDAR_DATA.CD_TO_TIME2, dbo.MSP_CALENDAR_DATA.CD_FROM_TIME3, dbo.MSP_CALENDAR_DATA.CD_TO_TIME3,

dbo.MSP_CALENDAR_DATA.CD_FROM_TIME4, dbo.MSP_CALENDAR_DATA.CD_TO_TIME4, dbo.MSP_CALENDAR_DATA.CD_FROM_TIME5,

dbo.MSP_CALENDAR_DATA.CD_TO_TIME5

    FROM dbo.MSP_CALENDAR_DATA

    WHERE dbo.MSP_CALENDAR_DATA.CAL_UID = @Cal_UId

    ORDER BY CD_TO_TIME1 ASC

END

CLOSE CAL_Cursor

DEALLOCATE CAL_Cursor

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[INTECHCalenders]’) and OBJECTPROPERTY(id, N’IsUserTable’) = 1)

    drop table [dbo].[INTECHCalenders]

    print ‘table deleted’

GO