Showing posts with label ssms. Show all posts
Showing posts with label ssms. Show all posts

Thursday, February 16, 2012

Changing Fail-safe operator in SQL Server Management Studio

I have designated an operator as the fail-safe operator in SQL Server Management Studio (SSMS). I now wish to change the fail-safe operator to be a different operator. SSMS allows me to make the changes, but after selecting "OK" and re-opening the SQL Server Agent Properties in SSMS, the changes have not been made. Any idea how to change the fail-safe operator? As far as I can tell, there are no stored procedures available, and as I understand it SSMS is already using SMO. Any help would be greatly appreciated.

Thanks

John

Thanks for taking time to report this. I have opened a bug on this.

You can SMO to perform this operation or use SP_MSsetalertinfo .

Thanks,

Gops Dwarak

Tuesday, February 14, 2012

Changing default folder for saving query text

When I save a query (not a query result) in SSMS, the default root folder is
My Documents\SQL Server Management Studio\Projects
Is there any way to change this default and make it persist beyond the current session?

Hello,

Yes it is possible for you to set the default folder to your prefered location. Open Microsoft SQL Server 2005 Management Studio.

From the Menu select Tools -> Options. Select Query Results noted and enter your prefered location where you want to save your queries in the "Default locations for saving query results" text box.

Thanks

|||Yes, I'm well aware that this setting is available for query results, but I'm asking about the query text itself - how do I change the default save path for the query text?