I am closing this thread as it is going nowhere. If you have a real question, please take the time to write it out.

http://www.apexsql.com/sql_tools_log.asp

Looks like Lumigent doesn't just sell Log Explorer anymore, no idea on Quest.

Ugh, sorry, I was looking at the code block and didn't see the query above. I've put it back the way it was to keep Hugo happy 🙂

As jcdyntek noted, if you are getting this sorting, likely you have character storage.

"1" comes before "12" in terms of character values, and "1/10/2010" comes before "1/2/2010" as well. 1...

My apologies. It made sense to me, but really what is being asked is how many rows are inserted.

I have edited the question.

This one is pretty good, especially now.

Don't you think that you ought to become an apprentice first?

SQL Server is too wide for this question. If you want to learn about SQL Server, read an article. See...

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.