That can definitly be arranged. 😉

Sounds like they really need you and really like you. Means, if you want to negotiate, you're doing it from a position of strength. There are worse positions to be...

Agreed. Sorry, but I don't think we're going to be able to help very much here, except to offer commiserations and sympathy. Much as I'd love to dive into your...

I've heard that the MS press self-paced training kit is very good.

Excellent. We should organise a...

Jeff Moden (7/2/2008)

---

Folks, meet my friend at work, Mr. Venkat Gotur... this man is not only an awesome thinker/developer/designer (Just got promoted to "Prime" Developer... makes more coin than most...

OleHank (7/2/2008)

---

DECLARE @retVal tinyint

DECLARE @truthTable char(42)

SET @truthTable = '111111012345201333330143444015345501234560'

SET @retVal = CAST( SUBSTRING( @truthTable,...

Congrats Jeff. When you get down from cloud nine, let us know. Don't rush though, this doesn't happen every day. :w00t:...

you need to concatenate the value of the variable into the string. This should more-or-less...

Try downloading process explorer and see if you can identify what is using that file. If you can find out and you can remove that open file handle, you should...

Ah. Now we get somewhere.

Do you have an anitvirus that may be (or may have been) scanning the file? Do you perhaps have a file backup that may be (or...

Are there any errors in the SQL error log?

Is the log file where SQL expects it to be? That error indicates that the log fle couldn't be read.

Have a look in the SQL error log, see if you...

Try using the query execution plan to see if the index is used o not.

Without more info on table structure, index structure and query, I can't even begin to...

Good point.