It seems from my testing that both the '' and ' ' are treated the same. This doesn't seem right since I'd expect a '' to be stored as ...0000000...

John,

a couple things. First simple logging does clear the transaction log, but only of committed transactions! So if you run 100,000 deletes as a "set rowcount 100000 delete from mytable...

Mike,

I don't think there's anything to take you from start to guru. You'll probably end up with a variety of materials.

For books, I think any of the "SQL Server in...

rao's solution is the best.

if (x = y)

raiserror ()

return

else

-- continue

I think this is one of those cases you'd be better off controlling it. Do you know how big a row can be? If so, I'd calculate how many you...

Did that work? Have one machine where this is my problem.

Simon,

Congrats and that sounds like a job I left years ago. Don't really regret it, it was a good decision at the time, but I miss it.

Besides, I have...

It has been removed. Sorry about that.

Some very interesting responses here and I can see the other side from many of you.

I guess I'd still stand by my point for the conference/seminar presentations since time...

SQL Server 2005 is a great move forward for security in the MS world.

Charles, I've read about a few of those tricks before and it's certainly made me rethink the...

Thanks for the professional answers and I have emailed directly to the original poster regarding the less than professional behavior.

Updates here: http://news.com.com/Searchers+believe+they+are+nearing+missing+CNET+editor/2100-1028_3-6141107.html?tag=nefd.lede

and why you should carry a cell phone: http://news.com.com/2100-1039-6140794.html

Profiler is a utility that comes with SQL Server. You should read about it in Books Online and experiment with it. If you configure it to capture minimal data, users,...

The job should show failure, and you should have a notification set up to let you know. Check the logs for teh maintenance plan, not the job history for the...

Do you have someone measuring bandwidth usage? Possibly from individual machines? What about running Profiler and seeing how much and how quickly traffic is being sent to and processed by...