Sometimes i am able to login in to my application and when i am doing some search function this error is coming.

this error is created from Front End. jst want to know whether this error is related to Sql server or .Net

i am able to connect to my sql server 2008...

With the help of this article

http://www.sqlservercentral.com/articles/Advanced+Querying/3122/

i am able to solve my problem.

d

thanks pradeep it really worked...can we do this task from SSMS without writing query

so i haveto first configure a VPN in my company and only then i can access my sql server remotely.

But i have one doubt...how i am able to connect to...

Thanks for the reply...we r using the firewall.but not VPN ..we can able to access our Client DB from our Sql server..but while trying to access our DB from home...

thanks for the help

thanks for the input ..

i implemented that and got the id and stored into the temp table .now i want to insert this ID's(2 or more ID's) into another...

thanks to jacob sir

i miss the <sequence> under first <complexType>

thanks Drew for replying..i got some idea this is exactly i want

IF (@x.exist('//ConsumerID[./text()]') = 1) AND (@x.exist('//RoleConsumerID[./text()]') = 1)

SELECT 'Exists' AS Result

ELSE

...

thanks dan..i like the 2nd option

thanks

thanks 4 ur valuable input...

thanks for replying

but i solve the problem this way

CREATE PROCEDURE [dbo].[CurrencyAmountIns]

(

@CurrencyAmountID int OUTPUT ,

@CurrencyCode CurrencyCodeType,

@CurrencyExponent CurrencyExponentType,

@CurrencySign SignCodeType

)

AS

BEGIN

SET NOCOUNT ON;

...