D.Oc,

We have an F# review coming out this week of a book. Looks interesting.

Jeff,

C'mon, make it a resolution. Be good for you to stretch into SSIS, might even come up...

I agree with Jeff. The issue is that you could issue this:

bcp...

bcp...

bcp...

if errorlevel = 0 then notify

However there are many places things could fail. At any point before the IF...

I agree, we should be able to have all versions side by side. I voted and tweeted this one.

Hope everyone has had a great New Year, and a safe one.

CirquedeSQLeil (12/31/2009)

---

The jobs I have held followed this idea of "do the job" 24x7x365. Most had no compensation for on-call nor for holidays - the job had to be...

If you use BULK INSERT, you could check the table afterwards. I guess with bcp you could do the same. run a query and determine if the data was inserted.

Microsoft has changed the names of the certs a bit, and made them more specialized. The main information is here: http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx

There's a SQL Server TS, or Tech Specialist, which is...

I'll vote for "just wrong"

Enjoy the holiday tonight, everyone, and be safe.

That seems pretty fair. Good that they're recognizing holidays with extra pay for those working.

Thanks a lot for the kudos and praise. I appreciate it, but all of you add a lot to the site as well.

You can try dropping indexes and adding them back after the insert. That sometimes helps.

If you are adding a lot of records, it's possible that you're overloading the I/O system,...

Do you mean make a corrupt mdf on purpose?

Use a hex editor to scribble on some random part of the file.

The grammar has been corrected. Apologies for any issues.

I will also award back points for this question.

Try this: http://www.sqlservercentral.com/scripts/T-SQL/67368/

I think Jeffrey has some good advice. don't disrupt things if you don't have to.