Hallo

Why don't you try the method in the following example

SqlCommand cmd = new SqlCommand( " Insert into Customer (FirstName) Values ('Bruce');select @@identity as 'iD'", Conn );

  object iD...

Hallo

It seems to be that the textcopy.exe is not installed in sqlserver.  You can see this file in sql2000 CD.   Just copy this file into your binn directory and try...

storedprocedure

  Create procedure test_insert

  as  select  title_id  from mylinedserver.pubs.dbo.titles

exec test_insert         is working

but

create table #tmp

(title_id varchar(15))

insert into #tmp

exec test_insert                     is not working

Procedure give results without insert within 1 sec.

But when I use this procedure with insert is not working.

there is no error messages.  I have waited more than 30 minutes.  and nothing...

Both definitions and settings &  associated remote logins

following are the details of linked server connection.

security context remotelogin SA.

Local login-sa

remote login -sa

The linked server query is functioning well. The query gives error only used with xp_sendmail

Edited by - jma100 on 04/22/2003 08:22:49 AM

The error message seems to be that the spacified drive not found or the account which you are using to run Jobs does't have the required permission to...

open the dts in development server

clik the menu 'package','save as' and select the

SQL server you want to copy.

Regards

Joseph

I mean an alternative query using keryword 'JOINS'

Hello Antares

Thank you for the quick answer.

I forgot to told you that I have done the same thing that you told me. I have replaced new datafiles with old...

you are right

The collation construct of both databses are not same.

one database have the construct "SQL_Latin1_General_CP1_CI_AS"

and another having "Latin1_General_CI_AS"

How we can change this contruct ?

B.regards

Joseph

version :- SQL Server 2000 - 8.00.534 (Intel X86)