This is just my two cents, but I think the statement :"NULL duplicates NULL" (but "NULL never equals NULL") is absolutely true, but is being interpreted differently than it was...

If you have a memory leak, it would be easy to find. Simply monitor your processes in task manager, and watch for processes where the memory continues to grow until...

It's interesting you bring up the money aspect of it, mromm. I've actually been denied raises before on the basis that it would cause me to be making more than...

The date value is held in the sysprocesses table, in the last_batch column. The times I've seen the situation you describe, was after a fresh install, or apply of a...

Wasn't a Mylex card, was it? If not, what Kind?

Before the advent of DTS or replication, we used scheduled stored procedures on each end. Keep in mind that replication is essentially just that.

Another method might be a third party...

Generally, its transactions the system batches executed by a system process. The "." is representative of a system internal function. There is no direct userid, though its related to one.

...

I use BCP for it through an EXEC. Since Sql 2000, the stored proc for exec, as it allows return values.

Yea, but be careful. Makes em REAL mad. I just keep in mind that they didn't hire me to draw a check, they hired me to tell em the truth....

Antares686,'s statement is correct. The system table containing this information has to have some date value to populate, so uses the default of 1/1/1900. Once a batch is run, the...

A very apt description, David, And follows what I see in the world very closely. Sums up exactly why I refuse management positions. I don't mind taking lead roles, but...

I'm far too outspoken to make a good leader. Besides that, isn't the point guy the one who takes the first bullet. (grin)

If it was that easy, I'd of done it by now.......LMAO

Hey, I know, if we all band together..........

I just realized you are the one who wrote the...

Sounds like something is trying to access something not on your local network (like that helps a lot). How are they attempting to do things...

Looking at records shouldn't prevent an update under the default transaction isolation level of read committed. Unless there is a holdlock, or the transaction isolation level has been changed, I...