Hi Thank for the reply.....

I went to the Surface Area Config Manage----->Remote Connections --->the option selected is "Using Both TCP/IP and named pipes".

Even Then I am still not...

I have added some servers successfully But I have a problem adding one particular server. The error message I get is this

TITLE: Microsoft SQL Server Management Studio

------------------------------

"The linked server has...

Thank guys Its Solved. This Web Site Is An Asset.

Thank for the reply. I did add a remote user in the SECURITY tab. In the SECURITY tab for local user I gave the username which has sysadmin server role(I...

Thanks For The reply and ur suggetions.

I just ran the query in analyzer and just copy pasted the results in Excel. It took some time but it did it.

Any way...

Thank You Buddy

Thank You Dude. I tired refreshing the view. It Dint Work. I will try the other two options u gave and get back to you.

This was really helpful. I...

Hi I have a new problem. In the above the view "dbo.vHVC_CustomerContactHistory" the base table for the view is "HVCE_3.dbo.HVC_CustomerContactHistory".

As mentioned above. What is puzziling is that when...

Hi I have a new problem. In the above the view is "dbo.vHVC_CustomerContactHistory". The base table for this view "HVCE_3.dbo.HVC_CustomerContactHistory" As mentioned above. What is puzziling is that when I...

Hi I have a new problem. In the above the view is "dbo.vHVC_CustomerContactHistory". The base table for this view "HVCE_3.dbo.HVC_CustomerContactHistory" As mentioned above. What is puzziling is that when I...

Yeah Thank You For The Advice. I will Discuss with my Manager regarding this and then only Will I go ahead.

Regards

Naz.

Ok Thank You for the help.

I have to Discuss this Issue with my team lead. If it works I will get back again and Thank u once again.

TC BYe

Oh I am sorry. I just wanted to get view from two differnt experts. I am new to the Forum Culture. Thats the reason I doono That I should not...

So I Think The Better Option Would Be To Change The Sizes In The View And The Target Table In Which The Data Is Being Inserted Into ....Right?

As The Data...

I More Thing I would Like to Add. I am working on 2005. I suppose that will not make any diff. Just in case I am informing because the Forum...