I am rather curious as to who wrote the sprocs with a profix of "sp"? And named the tables with a prefix of "tbl"?

I fired some guy for prefixing all...

I would suggest getting rid of the proxy account, and setting the permission of your domain account to a simple user. That account does not need, nor should it have...

I have never had any issues with SSIS. Maybe it is time for a new server.

Andrew SQLDBA

Why not use SSIS for this? Why would you want to use those old batch files? And also from within SQL. That is just bad news waiting to happen. Use...

If that account is not a domain account, then you will never be allowed to write to a drive, any where. The service needs to be running on a domain...

Sorry about that. I just saw the word "column" in your post

Here is the code for specific column(s)

GRANT UPDATE (<ColumnName_1>, <ColumnName_2>, <ColumnName_n>)

ON <TableName>

TO <UserName>

Andrew SQLDBA

The syntax according to the SQL Books Online is:

GRANT UPDATE ON <TableName>

TO <UserName>

Andrew SQLDBA

What I would do is design the database in SQL Server properly, and then pump all the data in. I am sure that you will want to change and modify...

Thanks for the reply

I found the tables about 2 seconds after posting the message on here. What luck.

Thank you for the info, I will keep that handy

Andrew SQLDBA

The only command that I know that will solve the problem is

DROP Database <DatabaseName>

Sorry to hear that, good luck with it. You may try pumping the data out into some...

Your database design is all incorrect for something like that. You need more than one table. That way you can have more than one answer per user. And you would...

That would be the easiest way of accomplishing this task. Simple add more controls that do basically the same thing as the original ones. It would not hurt to hit...

I think that you may be confusing SQL Permissions with Windows permissions. You cannot interchange the two. What is the name of the user account that the SQL Service is...

Terry

I am sure that using VB.NET, you have some code that can read the files in the directory and come back with all the file names. Am I correct? 🙂

You...

Terry

SSIS can very easily do this. SSIS is an ETL Tool. You can eve make SSIS download the file from where ever and extract the 4 files from within. Some...