DBA > Job Interview Questions > Microsoft SQL Server FAQs

Can you re-associate the application with the sa

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

(Continued from previous question...)

Can you re-associate the application with the same SSNS instance?

You accidently delete an application from an instance of SQL Server 2005 Notification Services. However you have not removed the database, nor the application objects. Can you re-associate the application with the same SSNS instance?

Answer
No
Explanation
You cannot re-assocaite the application because when you add the application, SSNS recreates the objects. If they already exist, the create fails.

(Continued on next question...)

Other Job Interview Questions