check out this evolution

select

Convert( char( 20),GETDATE(),120)

, replace( Convert( char( 20),GETDATE(),120), '-', '')

, replace( replace( Convert( char( 20),GETDATE(),120), '-', ''), ' ', '')

, replace( replace(...

if you want, you can write a parser for

exec master..xp_cmdshell 'ipconfig /all'

Steve Jones

steve@dkranch.net

I still don't think the instances are great, both from mgmt as well as $$. You still have to license as though you have 4 SQL Servers. If you use...

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 ...