Yeah, Same problem when I using SSIS Package.

Regards,

Naseer Ahmed

Hi,

No, simple value with the above format. when I convert this column to General format it working fine in both format means ( by query and with SSIS) and column...

THANKS FOR REPLYING,

I will check with SSIS also same problem is there. I also check the range the range is fine.

Regards,

Naseer Ahmed

How I find whos are using this table

Thanks in Advance.

Regards,

Naseer Ahmed

It solve my problem

Thanks for helping me.

Regards,

NA

I tried

select *

from sbtrading.dbo.Customer_PhoneDetails

where customerid = 1

SELECT CustomerID,

[1],[2],[3],[4]

FROM

(SELECT CustomerID,??,ContactNumber

FROM sbtrading.dbo.Customer_PhoneDetails

...

A network outage And SQL Server Browser Service is running

Other people easily connected with this server.

Regards,

NA

Thanks for reply

This happen with me when I make new connection with SQL Server and all My previous connections disconnected.

Now I cant connect.

Regards,

NA

Thanks to all

It really helpful for me and solve my issues.

Regards,

NA

Thanks for replys

No I just execute this simple command

ALTER TABLE EMPLOYEE

ADD Is_Employee_Updated BIT

And find this issue.

How I investigate what SPID 118 is doing.

Regards,

NA

Thanks, It resolve my problem.

You guys are marvelous.

Regards,

Naseer Ahmed

I got this while running on changing schema

session_idstart_timestatusblocking_session_idwait_typewait_resourcewait_time

1412012-03-02 16:03:13.400suspended97LCK_M_ISOBJECT: 11:1795537480:0 10022

532012-03-02 16:03:10.040suspended97LCK_M_ISOBJECT: 11:1795537480:0 13459

972012-03-02 16:03:09.600suspended118LCK_M_SCH_MOBJECT: 11:1795537480:0 13900

what to do ??

Now

I also try so many times through commands also same result so much time it takes I donot know why

Regards,

Naseer Ahmed

Thanks for reply.

It not work for me . I tried to done with Merge Statement. can I Use CASE Statement and IF-ELSE in Merge Statement.

Regards & Thanks in Advance,

Naseer Ahmed