Monday, September 13, 2010

Re-initialize an identity field seed

In order to re-intialize an identity field in a table, the following command is needed (SQL 2005):

dbcc checkident ('<<table>>',reseed,<<new seed>>)

Friday, September 10, 2010

MOSS 2007: cannot delete a question in a survey (Unknown Error)

Problem: In a MOSS 2007, when try to delete a question in a survey a message saying Unknow Error (before SP2) or Unable to validate data.   at System.Web.Configuration.MachineKeySection (after SP2) is displayed.

Resolution: in the web server browse to the path C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS, open the file mngfield.aspx (if MOSS is not installed in the default paths, browse for the file) in Notepad and add the following line:

<asp:Content ContentPlaceHolderId="PlaceHolderSearchArea" runat="server">
</asp:Content>

We have MOSS installed in a front end server and the database in a backend server. I don´t know if other configurations this solution could work.

Exchange 2007 mailbox room always Tentative Accepting reservations

Problem: when send a reservation request to an Exchange 2007 mailbox room, the resource always return a Tentative Accepted message saying: Your request was received and is pending approval.

Resolution:

Using an account with Full Access permissions over the mailbox room, access it using OWA, go to Options, Resource Settings, under Resource Scheduling  Permissions make sure the second and third options are selected to "Select Users and Groups"