That would get my vote.

Steve Jones

steve@dkranch.net

There are some good points of view on Slashdot this week. and one from Bill Joy as well as some discussion from the guy who is porting to Linux.

Steve Jones

steve@dkranch.net

clarification:

How to Buy

Multiple Instances

Licensing SQL Server 2000 Enterprise Edition enables customers to run multiple instances on a single server or processor and only...

Isn't app center supposed to replicate the info from one server to another? Not sure if this handles the stateless/stateful thing, but it adds overhead. I am for using either...

Can you post some XML document and I'll take a look.

Steve Jones

steve@dkranch.net

Sounds like security. Can you log in with QA using the SAME login as the app and open the database?

Steve Jones

steve@dkranch.net

Build multiple transforms. select * where col = A, etc.

You could build a generic package and then drive this with another package that checks for all values of your column...

ERWin is nice, but $$$$$, ERStudio is almost as good and less, but still $$$. Visio is $$ and it shows. It is cumbersome, IMHO, and seems to reach a...

Brian has a good explanation. I like stored procedures as they also promote resuse and encapsulate specific functions. I take the view that I'll build 10 sprocs to cover your...

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