- Home
- Interview Questions
- MS SQL Server
Run Profiler
Profiler will work as long as you have permissions to profile the server and is the the best solution because it requires no change to the Report Server itself. There is a way to log all report SQL to a log file, but that option was not listed here and is better used if you want to do analysis rather than troubleshooting.
Saves the report to the report server. File|Save writes the report to the Report Server. Users have the option to also save the report to disk by using File|Save to File. Report Builder users cannot modify the model.
nscontrol.exe
The nscontrol application can be used with various parameters to administer a SQL Server 2005 Notification Services instance
Triple DES.
When you create a Database Master Key, it is encrypted using the password you supply with the Triple DES algorithm..
The Object Explorer for the server has a "Triggers" folder. The server-scoped DDL triggers will appear in Management Studio in the Object Explorer under the "Triggers" folder.
|
|
||||||||||||||||||||||||||||
