ALTER TABLE Full Option !

Below is a good link to know about all regarding the ALTER statement syntax in SQL.

http://dev.mysql.com/doc/refman/5.1/en/alter-table.html

Crystal Report Configuration Isuses in Vs.net 2008

I migrated one web application done in 2.0 to 3.5 framework. It worked fine after migration. So at the time of migration i had both VS.net 2005 and VS.net 2008 intsalled on my machine. Then i removed VS.net 2005 as i dont needed it anymore.

Then while building the solution, i got the following error:
the assembly 'CrystalDecisions.shared/Web/Engine, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' could not be loaded

Finally i managed to fix it by doing the following things:

1) Install the crystal runtime package that can be found on your local computer (I believe it is installed with visual studio 2008). It is located in:

\Program Files\Microsoft SDKs\Windows\v6.0A\Bootstrapper\Packages\CrystalReports10_5

Select the appropriate package for your machine.

2) Modify web.config with all crystalreport assemblies so that it will be of new version eg:



3) Build solution. Now the solution successfully builds up !!!

Database Mailing in SQL 2005

We may come across the situations that to send mails from SQL server automatically or manually in-order to retrieve some status or information. For that we can setup the database mailing feature of sql and all through sql query itself. Hmmm..thats great

--STEP 1 - CONFIGURING MAIL
--******************************************
use master
go
sp_configure 'show advanced options',1
go
reconfigure with override
go
sp_configure 'Database Mail XPs',1
go
sp_configure 'SQL Mail XPs',0
go
reconfigure
go

--STEP 2 - CREATING MAIL ACCOUNT
--*********************************
EXECUTE msdb.dbo.sysmail_add_account_sp
@account_name = 'PITSAccount',
@description = 'PITS Mail account for Database Mail',
@email_address = 'binukumar@MYWORLD.com',
@display_name = 'PITS Account',
@username='binukumar@MYWORLd.com',
@password='TESTPASS',
@mailserver_name = 'smtp.TESTWORLD.yahoo.com'

--STEP 3 - CREATING MAIL PROFILE
--*********************************
EXECUTE msdb.dbo.sysmail_add_profile_sp
@profile_name = 'PITS Profile',
@description = 'PITS Profile used for database mail'

--STEP 4 - Connecting PROFILE with MAIL
--***************************************
EXECUTE msdb.dbo.sysmail_add_profileaccount_sp
@profile_name = 'PITS Profile',
@account_name = 'PITSAccount',
@sequence_number = 1

--STEP 5 - setting up the role and making this defauüt mail account
--***********************************************************************
EXECUTE msdb.dbo.sysmail_add_principalprofile_sp
@profile_name = 'PITS Profile',
@principal_name = 'public',
@is_default = 1 ;

--STEP 6 - SENDING MAIL
--********************************
declare @body1 varchar(100)
set @body1 = 'Server :'+@@servername+ ' My First Database Email '
EXEC msdb.dbo.sp_send_dbmail
@profile_name='PITS Profile',
@recipients='binukumar@myworld.com',
@subject = 'PITS Mail Test from SQL',
@body = @body1,
@body_format = 'HTML' ;

Now go and check the account of the target person we intended to sent the mail. The mail will be there for sure. Please let me know if any troubles

Windows service instllation in VS.net 2008 with Windows sever 2008

While installing a windows service writtenin vb.net, to the windows server 2008 OS with VS.net 2008, if anybody recieves the below message in the Command prompt

Running a transacted installation.
:
An exception occurred during the Install phase.
System.Security.SecurityException: The source was not found, but some or all eve
nt logs could not be searched. Inaccessible logs: Security.

The only thing need to do is:

go to start > All Programs > Microsoft Visual Studio 2008 > Visual Studio Tools and right click on "Visual Studio version Command Prompt" and go to "Run as Administrator"

Enter the command you are using to install your service.

Running applications as a service on Windows 2008 or SBS 2008

Its really possible to intsall/register a windows service written in .net in a machine without using the INSTALLUTIL.EXE tool along with .net components.

Please check the below link to accomplish that:

http://blog.korteksolutions.com/running-applications-as-a-service-on-windows-2008-or-sbs-2008/comment-page-1/#comment-26

Create FTP site in IIS 7.0

The fact is FTP management is provided by IIS 6.0. So when we try to set FTP using IIS 7.0 it will ask us to Launch IIS 6.0. After that there is a series of steps to Configure a FTP which is clearly mentioned in the below link:

http://www.hostmysite.com/support/dedicated/iis/iisftp/

Predefined Escape Sequences in C# for ASP.Net

There are 11 predefined literals:

\’ single quote
\" double quote
\\ backslash
\0 null character
\a alert
\b backspace
\f form feed
\n new line
\r carriage return
\t horizontal tab
\v vertical tab

CRM 4 in windows server 2008

'Request IP Address has different address family from network address.'
Error while accessing CRM 4.0 in Windows Server 2008 Operating System

The fact is MSCRM 4.0 doesn't work with IPv6.

The fix for this is simple, open your hosts files
(:\windows\system32\drivers\etc\hosts)
and add a line for your server name there with an IPv4 address. Save and ping again to make sure it is working.
Once it is, do an IISReset and it will be working!

Refrence site: http://www.sadev.co.za/node/170

CRM 4.0 - Making & saving picklist values to CRM database dynamically

There is a common issue with picklist and CRM 4.0. If we add picklist items statically, while saving the values will be saved to CRM database properly. But while we add items dynamically it won't be saved with proper values but with NULL !!!

I have found a nice workaround for this issue as follows:

1) Instead of picklist type i declared the attribute as simple text
2) On the onLoad event i created a html select control dynamically and binded the values from CRM database.
3) i added this SELECT control to the innerHTML of our attribute
4) hide our CRM attribute (so now our CRM attribute is hidden and SELECT control is visible)
5) On onSave event i loop through the SELECT control and get the selected item
6) Set the selected item's value to the hidden CRM attribute
7) So while saving the correct selected value will be saved to database
SUCCESS

Limitations:

Can't declare the CRM attribute as business required
don't get any events like onChange for created SELECT control

Refered links are:

http://forums.microsoft.com/Dynamics/ShowPost.aspx?PostID=2839313&SiteID=27
http://www.stunnware.com/crm2/topic.aspx?id=JS1

CheckBox onChange() event in CRM 4.0

In CRM 4.0, the checkbox onChange doesn't work. it is the onClick() for checkbox that works. So we need to implement the onClick() event in the onLoad() event of the form. Sample code is as given below:

crmForm.all.new_check.onclick = function()
{
if ( crmForm.all.new_check.checked )
{
crmForm.all.new_from.style.display='none';
}
else
{
crmForm.all.new_from.style.display='inline';
}
}