Thanks Allen.

That looks like a handy script.  Unfortunately it does not provide all the information I needed.  I tried all the options and columns in profiler that looked close, but...

Sure it may be the case that the question was not clear, and more than one answer was possible, but this does not prevent you from learning something new.  I...

Hi ft,

Try it like this:

SET KEYWORDS = Keywords + 'soap, ice, snow'

-Dan B

I think your performance should improve actually.  Just think about all those open transactions being held by sql server waiting for a commit that never comes.  Turning this off should...

Hi,

If you have Implicit Transactions turned on for your server, or if your application is turning this option on, try turning this off.  This will return you to 'autocommit' mode, which...

Jonathan,

You know, I was wondering why it was accurate to only 1/300 of second if it tracked time in ms... 

Part of me wishes there was an extendedDateTime datatype.  I feel...

bkelley,

Great link.  I spent a while geeking out over that page.  It is safe to say I don't fully understand the protocol, but it is really interesting to see how it...

Thanks for the response.

I have been in contact with the first ISP, and while friendly, they were unable or unwilling to provide the logs.  They did, however, shut the offending...

That's what I figured... Thanks Brent!

The key word in the questions is "not".

"Which of the following is not a method to do this in Windows 2000 Server"

So while that the method you list is valid...

Thanks fhanlon. I will see if I can apply that to my situation.

-Dan B

Thanks Brian.

Have a replacement in mind?

-Dan B

Are you using the simple recovery model? If so, then sql server will automatically remove the inactive log entries.

Perhaps you are referring to the physical file size?...

Brian - scratch the part of my last post about the posting a new comment. I was judging by this thread, and the comment box is actually centered over...

Few more things Brian... 🙂

When posting a new topic, it looks like the posting table is pushed right by the text of the current thread's title.

Also, in the...