Formated Serial Number like TS-001

Hi friends , i need to generate a serial number like TS-008 for many entities , So to resolve this i used Triggered , i create a filed (sn) at tebel level & increment this by one. and create one other attribut - varchar through MSCRM. and write trigger like.
Create Trigger "abc"
on table
as
Begin
declare @x as int
select @x = SN from Table where created on = max(createdon)
Upadate table set attrib = 'TS-0' + @x
where SN = @x
end

MSCRM - Even Capturing (Resolve Case etc)

Hi friends , Recently my client has a need to check some fields-population on case before resolution of case. it's very easy to implment , just go to MSCRM instaltion directory and change aspx page of case.In aspx page you need to add a java script function that ll validate all fields.
the syntex and name of function you can get in same folder .js file.It's given by MS.
So use thses to capture events.
Danish

MSCRM - Security Role

Hi friend , I came across a requirement , it was something like , user would not able to write a entity record but able to associate a other entity with that record (1:m). So i solved this by using append property of security roles. :-)

MSCRM 4.0-Data Migration tool

Hi friends,Today i do R&D on a new Microsoft-Utilty for data import in MSCRM 4.0 system. It's very fantastic tool compare to MSCRM 3.0 Data Migration tool.It's work for all entities (outerbox/customized) including customized fields.It does not come with CD but you need to download this utility from Microsoft Website.It can work from anywhere not needed server computer. It ask for a SQL server and by using MSCRM services it can push data into MSCRM.Even in siebel , there is no such fantastic utility.Great , I would like to say thanks to MS for this.