I agree with Andy. If you want to really work with the columns in some order select them in that order. Actually, doing select * everywhere is a bad idea...

no idea. I need a copy of v6.5 to test stuff like this. Sorry

Steve Jones

steve@dkranch.net

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