I agree with Brian and like his philosophy. If you want to do this in the past, you will need Log Explorer. For the future, a number of good suggestions...

I think you will start to see more people that take a DBA class and then become a DBA. I hired such a young lady a couple years ago. She...

I've got DSL and for an extra $35, I got static IPs. It is nice, but you have to understand some networking, plus you want to secure your boxes.

I understand....

Check their terms, but in searching for colocation, I've found they are all about the same. Especially if you are the little guy, you will be low in the priority...

I believe this should be

DTSDest() = CASE DTSSOURCE = x...

Steve Jones

steve@dkranch.net

lookforanewjob is easy to remember also.

Steve Jones

steve@dkranch.net

Maximum ASP looks good. Never used them, but reasonable prices.

Data Return worked great, but a little $$.

This site runs is hosted by a friend of mine. Not sure he wants...

Brian, sounds like an article

Here I'm not sure I improved the SQL servers. I did upgrade from SQL 7 to 2000.

I also helped architect an inhouse...

Looks like this is not working in parallel. Perhaps there is some single threading behind the connections? Not sure.

Steve Jones

steve@dkranch.net

I've done something similar, but I include a datetime field in my sql staging. Then I track when the process runs and only work with rows that have a timestamp...

Let em add one more qualifier. If I had a good design tool, then I'd use that. At a former job, we had Er-Studio from Embarkadero and I did all...

This doesn't make sense? What does not work?

Assume server MAC is "AA" and you have clients with "BB" and "CC" as their MACs.

In sysprocesses, you will see:

SPID ...

perhaps. try formatnumber()

Steve Jones

steve@dkranch.net

You can use your select statement as a derived table.

select

article

, armazem

, quant

, sum(total)

, type

from ( insert...

You could implement a delete trigger to write this information to an audit table. However, keep in mind that the hostname is dependent on the client app to send it....