For those who havent tried DW, more info here:

http://www.sqlservercentral.com/columnists/awarren/dependencywalker.asp

Im sure it's just querying system tables and skipping the object idea, almost always faster - but there are tradeoffs!

Andy

http://www.sqlservercentral.com/columnists/awarren/

Not trying to be offensive, though I think its semi-accepted practice for DBA's to complain about developers and vice versa. I'd like to think you're right that in large shops...

Some thoughts on defaults:

http://www.sqlservercentral.com/columnists/awarren/settingadefaultdatabaseforyourlogins.asp

Andy

http://www.sqlservercentral.com/columnists/awarren/

You may have better luck posting to a Access specific site. I use Access, but rarely the forms part of it. It should be a matter of binding the recordset...

I think that depends on whether you need both or just the deletes. Not sure exactly what you're asking I guess.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Please be careful posting or answering questions on Yukon. It's in very limited beta and definitely covered by NDA. You can still discuss things seen at conferences or on MS,...

MSrepl columns are added by replication, the problem is that it in this case the publisher doesn't expect to be inserting a value into that column. This happened because you...

You can always brute force by creating a temp table, setting a unique index with ignore dupes set, then appending the table into it. That will definitely give you uniques.

Andy

http://www.sqlservercentral.com/columnists/awarren/

I think you'll have to do your own. It looks like the DMO IsMember version might be more flexible, but that wont help in a select.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Not that I've thought of, but you could really stick any bit of data there that might help you troubleshoot. MDAC version? Client OS? Though you could log that stuff...

Couldnt ask for a better reply! I think QA probably does direct calls to get the data rather than going through DMO, it's definitely more responsive (with fewer features to...

Not bad. So you see the syntax as an an insert/values or insert/select type operation rather than an extra keyword on a trigger or stored proc? Create trigger update on...

I think Pass has the deepest content. VSLive and SQLConnections both have SQL content, but not as much. The offsetting factor is that Pass this year is in Seattle, the...

Reinitializing will destroy the data on the subscriber, if you push a snapshot.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Not exactly training, but the Pass conference offers a ton of content for a variety of different subjects/levels. Well worth attending. The nice part is if you pick a session...