'95 Nissan Pickup ( but I'd really like to have my 1972 Gremlin back).

I agree.  The 'FIRSTROW' setting should take care of this.  I know it works in DTS, but it seems to have caused multiple people grief trying to do it the...

Deja Vu!

This question has been asked here before.  Here's a link to a thread with a script to strip the header line off a file.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=105041

HTH

Have you tried adding FIRSTROW=2 to the BULK INSERT command?  I don't have a system to try it on, but it might skip the header.

Maybe we'll find out that the best biomass fuel can be made with tobacco.  If the tobacco companies figure out they can replace the oil companies, we may be able...

How are you calling the proc?

If you put a 'select @intPlId ' at the beginning of the proc, does the integer argument show up as you expect it to?

What is the...

Try -t\t

My personal preference is to think about a database as a related colletion of data, having nothing to do with the applications that touch it.  It's been my experience that...

Is there another object in the database already named ProductRestrictions (proc,view,trigger,...)?  That's the only reason I can think of that it might accept one name but not the one you...

When you do

select column_name

it returns the data to you.

When you do

select @variable = column_name

it puts the data from the column into the variable, but it doesn't return data to a...

How busy is the server?  How much activity was there on the attached database?  If the attached database is trying to run through recovery and the activity level has been...

Does the failure happen before the plan executes (does the backup complete)?  I have seen instances where it's the notification that has the id problem, not the plan itself, and...

What authentication mode is the server set for (SQL, Windows, mixed)?

Your machine sends the SQL to the server to be executed.  The optimization and data retrieval happen at the server.  If you unplug from the network, you can't run the...

For a table this small, I'd script the table, indexes, and triggers then drop the indexes and triggers, copy out the data, rebuild everything and reload the data.

The errors on...