You can say that again.

Andy

Which part isnt working? The final group by looks weird but I have not tried it yet. Can you post ddl for the tables involved along with some insert statements...

I have not tried them, but they arent flagged as read only in the object browser.

Andy

Dont you think you have many options from EM. Take a look at script tab under options in Query Analyzer. Another way would be to use DMO and set the...

Hey, I didnt even KNOW there was a configuration collection. Found a different way to do it:

Dim oServer As SQLDMO.SQLServer

Dim o As SQLDMO.Registry

Set oServer = New SQLDMO.SQLServer

oServer.LoginSecure = True

oServer.Connect "."

Debug.Print...

Hey Joe,

Thats not a bad idea. Though Im sure there will be some who DONT want it as the default option! I'll put this in our queue of things to...

Is there a defined limit to the number of params you'd have in the array? Why not just declare them all as parameters...var1, var2, var3, etc.

Another method would be to...

Depends on what you call mastering. I'd suggest you be pretty darn comfortable with TSQL before taking the exam - along with all the other things MS lists as exam...

You're probably want to use transactional replication - but you need to take a look at your goals to make sure. Generally snapshot is too expensive in bandwidth and merge...

Havnt tested, but this shoudl be close - it should return the top level record where catid=1 and up to 3 levels of child records.

select L1.*, L4.* from...

If you KNOW the max depth of the tree, you can just do a select that has a series of self joins (left outer from top to bottom). If you...

I've run into a not really related problem - but you may find interesting anyway. We use transactional replication a lot, but with relatively huge latencies..30 mins to an hour....

Hey Trisha,

Thanks for the follow up. Im not against using identity col for primary keys - in many cases I find it simplifies maintenance. Hungarian though - cant support that,...

You've got to be executing that code a LOT to worry about the time it takes to evaluate nulls! Code it so that it works, cleanly.

Andy

Disks are the big thing. You need fast drives, but more importantly bandwidth. Fibre!

Andy