HI ALL , one guy ask me in interview for sql dba post.
que1: What are the Status of database when you got some problem( quit)during upgradation from sql server 2005 sp1 to sql server SP2????
If you 'll get problems then wht 'll you do with installation? means you install again SP2? or if you want to keep sp1 then wht 'll you do?( are you REinstall SP1 for same situation)
plz help me out with this question
que 2:-- you have 10 tables as Articles in Tran Replication, if some one drop 1 table from Publisher (which is part of Articles) so wts are the circumtances come across ?
---> it 'll stop replicating that table or we have to create/define that table as new article in replication????/
plz help me out guys