I have not. Andy is out of touch for the holidays for the most part, but I will try and contact him.

Steve Jones

steve@dkranch.net

I might try installing the update to MDAC instead. Perhaps a driver got corrupted. The MDAC drivers are what you used from the control panel.

http://www.microsoft.com/data/

Steve Jones

steve@dkranch.net

Incorrect. Local System is a local system account for the workstation. It is not the same as your login. The local system account has NO privledges off the machine. If...

Piece of #$%% tool. It hangs for me for various amounts of time depending on the server. 10 mins is pretty long, but I know I've seen it hang for...

What type of program? Something in SQL or something on the server?

Steve Jones

steve@dkranch.net

You mean actually use the product on the exam!!!! Oh My!!!!!!!

You should have to use the product on every exam.

Steve Jones

steve@dkranch.net

Volume in drive C has no label.

Volume Serial Number is 07D0-0419

Directory of C:\Program Files\Microsoft SQL Server\80\Tools\Books

07/20/2000 10:44a <DIR> ...

If you are holding this lock for any period of time, then you have a desgin problem. You should not begin a transaction that needs to wait for any input...

select @somvar = Top 1 AnswerID from Answers_Eligible

Then use this in hte update and return it.

Steve Jones

steve@dkranch.net

csv is comma separated values. What you proposed is the same as nigelrivet, except you chose a # instead of a ,. Both will work.

Steve Jones

steve@dkranch.net

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...