This project is read-only.
SQL Server Task
The SQL Server Task is used to check for access to a specified database server and database. You can optionally check for the existence of a table or test the results of a simple query as well.

General Format
<Task name="SqlServerTask" description="" connectionString="" tableName="" scalarQuery="" scalarValue="" failAsWarning="" />

Attributes
  • name: specifies the task name - "SqlServerTask".
  • description: (optional) specifies the text to be displayed in the Task column within the user interface (UI). If you ommit this attribute the tasks name will be used.
  • connectionString: specifies the connection string of the SQL Server database to check. NDiagnostics must be able to connect to the specified database server and database in order for this task to be successful.
  • tableName: (optional) if specified, this table will be queried to determine if it exists within the database. If this table does not exist then this task will fail. NOTE: the SQL Server credentials specified in the connection string (either Integrated Security or SQL Logon account) must have the appropriate permissions to SELECT from the specified table.
  • scalarQuery: (optional) specifies a query that returns a single row with a single value (if the row contains multiple columns, only the first column is checked). The results of this query are compared against the scalarValue attribute. If the values do not match, this task will fail. NOTE: the SQL Server credentials specified in the connection string (either Integrated Security or SQL Logon account) must have the appropriate permissions to perform the specified query.
  • scalarValue: (optional) used in conjunction with the scalarQuery above. The value specified in this attribute must match the value returned by the query specified in scalarQuery in order for this task to be successful.
  • failAsWarning: (optional) if specified, and has a value of "true", "yes", or "1", then any errors caught by this task will be treated as warnings. NOTE: This attribute can be applied to any task.
  • disabled: (optional - not shown) if specified, and has a value of "true", "yes", or "1", then this task will not be loaded and will be ignored. NOTE: This attribute can be applied to any task.

Last edited Nov 27, 2007 at 4:38 AM by jbramwell, version 4

Comments

No comments yet.