Sami, I have been working on this problem, off and on, for months!!! Today, I have the beginning to the answer. My production system will be SQL 2005 bitransactional replication...

That's interesting information but unless I am missing something about your point, it does not address the question of deferred updates. I am not asking about triggers and I have...

Michael - if you are still getting forum notifications, I am very interested in how you got your information about deferred updates. I need to know when updates are applied...

I've heard of PDFs that you can buy with lifelike Q&A but don't recommend going down that road. It's not a matter of "if" you'll get busted but "when". Anyone...

Congrats Richard! You are motivating me to get off my lazy butt and get ready for the test.

Regards,

David

Thanks for the solution guys. I have wanted to write DDL scripts that use variables on several occasions but ended up finding another solution. I will use sp_executesql on...

Thanks for the heads up...sounds like a feature to me. I ran across the same problem on my last trial server setup where VS Express took over SQL 2005 with...

SSC Addict, I think you hit the nail on the head...the 431 self paced training kit talks about installing VS express but I've been putting that off...I think that this...

Publisher = Microsoft Press

There are 7 Authors; Daren Bieniek, Randy Dyess, Mike Hotek, Javier Loria, Adam Machanic, Antonio Soto & Adolfo Wiernik

Thanks much,

David

There isn't a template. Can I download a template or start a console app from scratch?

Congrats Kiruba!

Any legal suggestions on exam prep (I have no intention of ruining my MCDBA status)? I posted this on another string but I am having difficulty with SQL...

Can I take this conversation back to the 70-431 self-paced training? I have the SQL 2000 MCDBA and just finished a nice 5 month contract as a DBA for a...