This error can be caused by some of the following:

Do you have a bit field in the table that allows nulls?

Do you have a unique key on the...

I saw this error when the user I was signed on as in SQL Server didn't have read rights to the template file on the web server.

My first observation is that the fieldname year is a reserved word in SQL Server. Therefore, you should not name a field that. If you don't have control...

I have used this script in the past.

http://www.umachandar.com/technical/SQL70Scripts/Main32.htm

Check out the following on support.microsoft.com

kb 899761 - FIX: Not all memory...

kb 884525 - additions to...readme files

If there were uncommitted transactions or there was a rollback in progress, you might not be able to reattach without the log file.

I detach databases, change the name of the...

I can't recommend any books, but I have been reading through the following Learning Guide:

SQL Server Security Learning Guide:

Visit http://searchsqlserver.techtarget.com/general/0,295582,sid87_gci1102747,00.html?Offer=SQLwnlg85 to find out more.

What country are you in? I'm finding that book available both new and used at amazon.com I also see it available at http://www.bookpool.com

If you could post what you have already tried, I will try to help.

I have seen similar errors when one of these is happening:

a. fieldnames have spaces

b. fieldnames are over 8 characters

c. filename is over 8 characters

d. file is...

Hi Ben -

Unfortunately, I haven't had to use the loop in this way. I want all my files into one table. But I do want to know which...

If you don't have any objects highlighted, you can click on Package-->Properties. There is a Global Variables tab where you can set paths(gv_filelocation) and filenames, etc.

gv_filefullname seems to be...

I managed to get a seat for 71-431.

Uploading from Excel is tricky. I have had some success in uploading to Access first and then to Excel where I have columns that could be character or numeric....

When I use Query Analyzer, it generates a BEGIN and END statement. Does this matter?

if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbl]') and OBJECTPROPERTY(id, N'IsUserTable') =...