Ahh, I didn't even think of that. Overlooked the single_blob in that query. QSquared is right, change it to single_clob and you're good.

There might be a better way to do this but I have always put the xml files in a table (I usually need them stored in SQL anyways) and then...

If it's a prize drawing you're going to want a weighted system with your employee id set with the highest weight. 😛

Well you fixed the iteration problem. Outputing the text in the format you specified is actually the easy part. You already have the data you need (most of...

Do you at least know what's wrong with the sql statement you wrote? Read up on the WHILE statement if you're not familiar with it.

Yeah, uniqueIdentifier is what you're looking for. I generally try to avoid them but I'm sure they have their uses.

A bunch of good ways to do it. Yours looks really close. Seems all you would have to do is throw it in a CTE and then do...

Not sure what else could be causing that. Hard to say without knowing your backup strategy. When was the last time you took a full backup?

The link I...

bill.akin (12/28/2011)

---

no it does not have a green arrow by it. if i want to do a point in time in the script would it look like STOPAT =...

OK well the only other thing I can think of is the backup is corrupt. Try running the below statement and let me know what it returns.

restore verifyonly from...

OK that looks better. Something still seems to be using your transaction log backup though. Is it possible that you tried to restore this database at an earlier...

Those are not backup files. Those are the data and log files for a BtcSystems database. That's why you're getting that error message. You need to restore...

Couldn't find the article that I was thinking of. Anyways, it could be a couple other things as well. I would check memory configurations, make sure statistics are...

So you're trying to restore a database with this transaction log backup and after doing so the file remains locked? How are you doing the restore? Can you...

I'm no applications developer but I do know their is usually a configurable timeout period specified in the calling app. It sounds like you're hitting that threshold now. ...