error web service hexadecimal value 0x0E, is an invalid character. what is soluation for this problem?

Regards, Rami Sa'id Abdalhalim Technical Team Leader Amman Commercial Complex Ommayah Str. Al-Abdali Tel: +962 6 5696500 Ext.235 Mobile:+962 79 5366016 Email:r.abdalhalim@alghanem.com.jo www.alghanemgroup.com

Error Webservice (hexadecimal value 0x0E, is an invalid character) how can solve this problem?

Regards, Rami Sa'id Abdalhalim Technical Team Leader Amman Commercial Complex Ommayah Str. Al-Abdali Tel: +962 6 5696500 Ext.235 Mobile:+962 79 5366016 Email:r.abdalhalim@alghanem.com.jo www.alghanemgroup.com

can you write how you call sp from VB

Regards, Rami Sa'id Abdalhalim Technical Team Leader Amman Commercial Complex Ommayah Str. Al-Abdali Tel: +962 6 5696500 Ext.235 Mobile:+962 79 5366016 Email:r.abdalhalim@alghanem.com.jo www.alghanemgroup.com

if you need too many operators you must use dynamic variable for example: -- this stored procedure used to search create PROCEDURE [dbo].[SP__Find_Country] ( @chv_Country_name varchar(150)=null, @Calling_no varchar(5)=null, @Short_Name varchar(3)=null ) AS set nocount on Declare @Condition varchar(8000) Set @condition ='' IF @chv_Country_name is not null set @Condition=' co_name like ''' +@chv_Country_name + '%''' IF @Calling_no is Not Null and @Condition ='' set @Condition=' co_Calling_code like ''' +@Calling_no + '%''' else If @Calling_no is not Null set @Condition=@Condition +' and co_Calling_code like ''' +@Calling_no + '%''' IF @Short_Name is not null and @Condition ='' Set @Condition=' co_Short_Name like ''' +@Short_Name + '%''' else IF @Short_Name is not null Set @Condition=@Condition+' and co_Short_Name like ''' +@Short_Name + '%''' if @Condition <> '' Set @Condition=@Condition+' and co_deleted=0' print @condition if @condition ='' select * from Country where co_deleted=0 -- Updated by Nabeel Adnan Order By Country.co_name -- Updated By Mahmoud Khalil else begin Exec ('select * from Country where '+ @condition + ' Order By co_name ') print 'select * from Country where '+ @condition + ' Order By co_name ' end

I CAN NOT ACCESS THE TABLES FROM QUERY ,CAN NOT ACCESS TABLES ,VIEWS AND STORED PROCEDURES I CAN NOT CREATE NEW DATABASE ...

when i open tables from sql server management studio i have on Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) The system cannot find the file specified. (Exception from HRESULT: 0x80070002) (Microsoft.SqlServer.ConnectionInfo)

can you explain your problems

you can use constraint on C# code to joid two tables

when create object from web service class and call any method event error (the operation time out)

can you post query

you can using isnull fungtion to check on null isnull([FIELDNAME], @Original_FIELDNAME,FIELDNAME)

how you connect on vs.net?

where add related tables automatically on diagram sql server 2005?

ok Thanks where r u from?

i want use dynamic sql in function not in stored procedure

this example : -------------------------------------- CREATE FUNCTION test_fn ( @x int ) RETURNS @table TABLE ( c1 int ) AS BEGIN EXEC('select * from @table') RETURN END ----------------------------- Msg 443, Level 16, State 2, Procedure _fn__Get_All_References, Line 35 Invalid use of 'EXECUTE' within a function.

hi IsrarMuhammadQ i have error to execute dynamic sql in function

i creating function when used execute statment in function i have error: Invalid use of 'EXECUTE' within a function. -- modified at 3:43 Saturday 1st December, 2007

how can that?

i used sql server 2005 1- create new query on server 1 2- add exec sp_addlinkedserver server2,'Sql Server' 3- add exec sp_addlinkedsrvlogin 'Server2','false','domain\user','user','password' 4- after that execute for query 5- this Error:(Msg 18452, Level 14, State 1, Line 11 Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. ) Rami Abdalhalim