Don't worry. I just wanted to point it out so you would know the NEXT time.

-SQLBill

You say the dates aren't consistant. There's your problem. SQL Server has to know how to interpret the date values. It doesn't know what 01/02/2004 is. Is is Jan 02...

Let me answer them in reverse order and please remember this is only my opinion on the subject.

Procedures should not be used to control access to the data. That should...

Have you checked the Windows Event Viewer Logs for any correlating error messages?

-SQLBill

By the way, this forum is for discussing the Question of the Day not for individual's questions. The QOD is a test question that you can view by selecting Resources > Question...

By the way, this forum is for discussing the Question of the Day not for individual's questions. The QOD is a test question that you can view by selecting Resources > Question...

Jozef,

Find the link/button 'Resources'. Depending on which screen you are on it will be either in the menu bar or on the left side. Using that link will get you...

Good point Brian. My main reason for the post is to let everyone know about this issue with XP SP2. On another site I use, a poster wanted help with...

Simple mode is more like using an overwrite command. It will overwrite the inactive portion of the transaction log. It won't release it back to the OS, it just reuses...

Some ideas:

1. your network/sysadmin have a time-out on the network for lengthy connections. (or on the remote server itself).

2. something else is occuring on the network at the same time,...

SQL Server - No.

3rd Party tool - Yes.

Lumigent makes a log viewer tool, but it's not freeware and per my understanding, it has to be running already for you to...

This illustrates a misunderstanding about SIMPLE recovery mode.

Simple recovery mode DOES still use the transaction log, just like FULL mode. It all has to do with the inactive and active...

Wolford,

You say the question didn't have the ORDER BY as a possibility....but it did.

It asked if ORDER BY could be used in a view definition. That's all.....the answer is YES...

Is the drive partitioned?

-SQLBill

You are looking for sp_cycle_errorlog.

One thing you can do with this is create a job that runs the command once a week as part of your maintenance.

-SQLBill