Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
976What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
1207How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
1070Does a specific recovery model need to be used for a replicated database? : sql server replication
953Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
1042
Where in ms sql server is ’100’ equal to ‘0’?
What do you understand by sql server agent?
tell me the disaster recovery plan
Give a example to search fr a string in all stored procedure in sql server.
What are the different types of stored procedures?
What are the main differences between #temp tables and @table variables and which one is preferred?
What are the 2 types of classifications of constraints in the sql server?
Why use identity in sql server?
What is the difference between writing data to mirrored drives versus raid5 drives
What is 2nf in normalization?
what is blocking? : Sql server database administration
How can we check the sql server version?
What are the restrictions while creating batches in sql server?
Do you know what are the differences between lost updates and uncommitted dependencies?
What language is sql server written in?