Error Message

Arithmetic overflow error converting numeric to data type numeric

Cause and Solution


Arithmetic overflow will occur when you try to set the larger value in the lesser length variable , Just increase the length the field. This problem will be solved

Error Message

String or binary data would be truncated. The statement has been terminated.

Cause and Solution


Some time we will receive this kind of error from procedure while retreving data this is due to the overflow of any filed value , so just Turn of the Warnings using the System Variable as give below


SET ANSI_WARNINGS OFF

Error Message

Tables or functions 'bspl_detail' and ‘bspl_detail' ' have the same exposed names. Use correlation names to distinguish them. ...

Cause and Solution

This type of error will occur when you use the same table more then once in the join with out alias name,

Give the Alias name to the table so that it will be solved

Eric Traut talks Windows 7 and MinWin from Long Zheng on Vimeo.

Bill Gates' last day
At CES 2008, Microsoft Chairman and CEO Bill Gates and some of his closest friends debuted a comical look at what life would be like as Bill's last day approaches. Many of entertainment's biggest heavyweights, such as Bono from U2, actor George Clooney, and director Steven Spielberg, got some laughs..

Copied from : builderau

Find Colum present in the table or not

Hi,

 

if((select @count=count(*) from sysobjects tab,syscolumns col where col.id=tab.id  and tab.Name=<tablename> and col.name=<columnname>)>0)
begin
              print 'Column present'
end
else
begin
                  print 'Column not present'
end

 

Regards,

Sasikumar D

 

Direct - +91 80 41041751

Mobile - +91 9986080299

iGATE is Ranked No. 3 in DQ-IDC best IT employer survey and Ranked No.6  by Business Today-Mercer Human Resource Consulting-TNS  in a cross industry survey of Best Companies to work for in India ----------------------------------------------------------------DISCLAIMER--------------------------------------------------------- Information transmitted by this EMAIL is proprietary to iGATE Group of Companies and is intended for use only by the individual  or entity to whom it is addressed and may contain information that is privileged, confidential, or exempt from disclosure under  applicable law. If you are not the intended recipient of this EMAIL immediately notify the sender at iGATE or mailadmin@igate.com  and delete this EMAIL including any attachments

System restarts after i install Windows XP Service Pack 3

Good news is that Microsoft had released a service pack 3 for windows xp. as usual it comes with some problem . a week before i installed the service pack 3 after that it ask me restart then the problem starts it will boot and come till the welcome screen and then it will restarts .... even when i try thought the safe mode and all other modes which they had given nothing works .. then as usual gooooogleeee.. and found the solution , that’s is due to versioning problem to solve this

Put your windows cd and boot in repair mode and then copy the file gdi32.dll from c:\windows\servicepackfiles\i386\ to c: \ windows \ system32\ before coping this file make a backup of this file in c: \ windows \ system32\ this location and reboot it It works

Last week I got a chance to go to the VS 2008 Launch event in Abu Dhabi, It’s a nice time to be there. the event starts with all the basic formulates and the launch is for VS 2008, SQL Server 2008 , Server 2008 , there were 2 sessions one is for developer and another is for Professional , so I went for developer session . first they start with the features in framework and then they explained about the other features in asp.net and they are more concentrated on team server , that’s the very important feature, there is lot new in SQL server 2008 also with more features for reporting and charting . they had included chat and reports in SQL 2008 , I remember in my previous company we bought that , and its very powerful with gadgets with dashboard and they also launched a new product called expression suit , it has expression blend, expression media, expression web media and another one I forget it ..

We had a good breakfast in the morning and very good lunch … at last they gave a trial pack for VS 2008, SQL Server 2008, Server 2008 and expression suit , in the next once I will write deeply about the technologies

Writing the Error or any log message to Event log of the OS

string sSource, sLog, sEvent;
sSource = "Error Occur While Inserting Employee Record";
sLog = "Application";
sEvent = "Insert";

if (!EventLog.SourceExists(sSource))
EventLog.CreateEventSource(sSource,sLog);
EventLog.WriteEntry(sSource,sEvent);

Error Message

The Current time on this computer adn the current time on the network are different for moreinformation about Date/Time Propertoes, see Help and Support . To log on , Contact your system administrator

Cause : This error will occuer when you convert you client PC to the Domain sever . There is the date / time difference between the server and the client .

Solution : ASk your administrator to check the correct time in the server and the client or if your are the administrator log in to the client and set the time as if in the server