[SQL Server] PBM ExecuteSQL Query & Min Memory Settings

---

PBM ExecuteSQL Query & Min Memory Settings Posted: 04 May 2013 05:31 AM PDT Hi all, Im trying to use PBM a bit, but came into a few problems.Problem 1:Setting up a Min Memory setting policy, trying to find any servers that haven't been configuredServer Configurations @MinServerMemory > 0 But using this on a server with no configured min mem it returns 16??? Using [code="sql"]SELECT [value]FROM sys.configurationsWHERE [name] = 'min server memory (MB)'[/code]I return 0. Any ideas why? Problem 2:I tried to use ExecuteSQL to run the above code (mainly to try and learn using executeSQL) I get the error:'Property ExpressionNode is not set'The Cell is:[code="sql"]ExecuteSql('Numeric', 'SELECT [value]FROM sys.configurationsWHERE [name] = 'min server memory (MB)'')[/code]Hope someone can help.

You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server Newbies To stop receiving these emails, you may unsubscribe now.	Email delivery powered by Google
Google Inc., 20 West Kinzie, Chicago IL USA 60610