Can you call Notification Services APIs from unm

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Can you call Notification Services APIs from unmanaged code?

Answer
Yes, but only for simple subscriptions.
Explanation
Notification Services can be called from unmanaged code through a COM interface for simple subscriptions only. Condition based subscriptions are not supported through COM interop.

(Continued on next question...)

Other Job Interview Questions

• In SQL Server 2005, can you include a user-defined role as a member of another user-defined role?
• How do you recover the snapshot?
• How many users can be added to an application role in SQL Server 2005?
• How are modified extents tracked in SQL Server 2005 (which internal structures)?
• In replication, what is each set of the source data that is replicated from the source server called?
• You wish to configure event logging for your SQL Server 2005 Notification Services instance. Where would you make this change?
• If you absolutely need a report to look the same regardless of what OS or viewing software is being used, which of the following file formats would be the best choice?
• Clicking File, Save in Report Builder does which of the following?
• How can you you be sure that a SOAP queries that are looking for a WSDL response will be provided?
• What does the DEALLOCATE statement do in SQL Server 2005?
• More...