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

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