I ran this on SQL 2000

create table MyTest ( MyID int, MyChar varchar(20) )

go

insert MyTest select 1, 'A'

go

select * from MyTest

go

create procedure myProc

@tbl char( 10)

as

declare @cmd varchar( 100)

select @cmd =...

Alternatively, you could install SQL 2000 and run it in v65 compatability mode. that will make the database run the same, though not the server.

Steve Jones

steve@dkranch.net

Thanks for the followup. Let us know what happens and I am sorry we could not be more help.

Steve Jones

steve@dkranch.net

One thing: Use roles!!!!!

http://www.sqlservercentral.com/columnists/sjones/wp_userrights.asp

Steve Jones

steve@dkranch.net

I think I understand. You want to give a user rights to bulk insert data using a stored procedure, correct?

If so, I would create a permanent table and use BULK...

You are welcome. Hope it helps.

Steve Jones

steve@dkranch.net

The linked server will access based on the rights of the server, not you. You need to check the rights that the server has, so log into the network as...

Search your WINNT folder. There should be a sqlsp1.txt or something similar. Find all files changed in the last day and you should find it. It will help clue you...

Yes, you can only do this with dynamic sql.

Steve Jones

steve@dkranch.net

greyed out in the help in Enterprise Manager? or in the BOL?

Probably you are missing files. If you let me know where, I will search my server and post a...

see other post

Steve Jones

steve@dkranch.net

Not clear what you mean (JAw1977)? You want to write a stored procedure that will insert what? The data from Tables 2 and 3? You would do a join from...

see other post

Steve Jones

steve@dkranch.net

I'll try to be clear and concise.

Public and System are roles, similar to groups in network administration. You can assign rights to either, both, or neither. I recommend neither and...

Try making a connection from Control Panel | Admin Tools | Data Connections. This should be the same driver.

Steve Jones

steve@dkranch.net