SQL Server 2012

  1. Restore was successful but deferred transactions remain. These transactions cannot be resolved because there are data that ...
  2. RESTORE WITH CONTINUE_AFTER_ERROR was successful but some damage was encountered. Inconsistencies in the database are possible. ...
  3. RESTORE WITH SNAPSHOTRESTOREPHASE=2 for database '%1!s!' failed because an earlier RESTORE WITH SNAPSHOTRESTOREPHASE=1 may ...
  4. Restored/synchronized database %{database/} should already exist on target machine and must contain master datasource pointing ...
  5. Resume call failed because the package is not suspended. This occurs when the client calls resume, but the package is not ...
  6. Retain partitions. Partitions for new measure groups will be deployed, but partitions for existing measure groups will be ...
  7. Retract event evaluates to an invalid event after AlterEventLifeTime. The new life time ({0}) of the event is greater than ...
  8. Retrieved backup settings. Primary Database: '{0}', Backup Directory: '{1}', Backup Retention Period: {2} minute(s), Backup ...
  9. Retrieved common restore settings. Primary Server: '{0}', Primary Database: '{1}', Backup Destination Directory: '{2}', File ...
  10. Retrieved copy settings. Primary Server: '{0}', Primary Database: '{1}', Backup Source Directory: '{2}', Backup Destination ...
  11. Retrieved database restore settings. Secondary Database: '{0}', Restore Delay: {1}, Restore All: {2}, Restore Mode: {3}, ...
  12. Retrieves the list of active connections on the server. In the above example DiscoverConnections.xmla should have the following ...
  13. Retrieving access control entry description to apply to a directory in order to configure the SQL Server Browser service. ...
  14. Retrieving directory path for adding of access control entries to apply in order to configure the SQL Server Browser service. ...
  15. Retrieving full path to the SQL Server Browser service executable using Windows Installer API for the SQL Server Browser ...
  16. Retrieving parameters for adding an access control entry to a registry key in order to configure the SQL Server Browser service. ...
  17. Retrieving parameters for substitution properties to generate access control entries in order to configure the SQL Server ...
  18. Retrieving run-time value of substitution property '{0}' in order to generate access control entries as part of the SQL Server ...
  19. Retrieving static value of substitution property '{0}' in order to generate access control entries as part of the SQL Server ...
  20. Retrieving substitution properties for adding access control entries in order to configure the SQL Server Browser service. ...
  21. Retrying the bulk-copy operation into table '%1' without load ordering hint because bcp data does not appear to be sorted ...
  22. Returns a boolean value indicating whether an INSERT or UPDATE attempt was made on a specified column of a table or view. ...
  23. Returns a character expression after replacing a character string within the expression with either a different character ...
  24. Returns a Date value containing the date information represented by a string, with the time information set to midnight (00:00:00). ...
  25. Returns a Date value containing the time information represented by a string, with the date information set to January 1 ...
  26. Returns a Date value representing a specified hour, minute, and second, with the date information set relative to January ...
  27. Returns a Date value representing a specified year, month, and day, with the time information set to midnight (00:00:00). ...
  28. Returns a Double specifying the depreciation of an asset for a specific time period using the double-declining balance method ...
  29. Returns a Double specifying the interest payment for a given period of an annuity based on periodic, fixed payments and a ...
  30. Returns a Double specifying the modified internal rate of return for a series of periodic cash flows (payments and receipts). ...
  31. Returns a Double specifying the net present value of an investment based on a series of periodic cash flows (payments and ...
  32. Returns a Double specifying the number of periods for an annuity based on periodic fixed payments and a fixed interest rate. ...
  33. Returns a Double specifying the present value of an annuity based on periodic, fixed payments to be paid in the future and ...
  34. Returns a Double specifying the principal payment for a given period of an annuity based on periodic fixed payments and a ...
  35. Returns a list of names, data types, and enumeration values for enumerators that are supported by the provider of a specific ...
  36. Returns a new DT_DBTIMESTAMP value after adding a number that represents a date or time interval to the specified datepart ...
  37. Returns a random number greater than or equal to 0 and less than 1, evenly distributed. Random numbers change on recalculation. ...
  38. Returns a set generated by dynamically totaling child members in a specified set, optionally using a pattern for the name ...
  39. Returns a set of counters associated with the Logical Disk performance object. The event occurs once every 15 seconds for ...
  40. Returns a set of counters associated with the Process performance object. The event occurs once every 15 seconds for both ...
  41. Returns a set of counters associated with the Processor performance object. The event occurs once every 15 seconds for each ...
  42. Returns a set of members (periods) from a specified level starting with the first member and ending with a specified member. ...
  43. Returns a set of members from the Month level in a Time dimension starting with the first period and ending with a specified ...
  44. Returns a set of members from the Quarter level in a Time dimension starting with the first period and ending with a specified ...
  45. Returns a set of members from the Week level in a Time dimension starting with the first period and ending with a specified ...
  46. Returns a set of members from the Year level in a Time dimension starting with the first period and ending with a specified ...
  47. Returns a string containing a copy of a specified string with no leading spaces (LTrim), no trailing spaces (RTrim), or no ...
  48. Returns a string which contains a delimited list of IDs, starting with the top/root of a hierarchy and ending with the specified ...
  49. Returns a table of zero or more rows for those columns containing character-data types for precise or fuzzy matches to single ...
  50. Returns a table of zero, one, or more rows for those columns containing character-data types for values that match the meaning, ...
  51. Returns a value generated by rolling up the values of the children of a specified member using the specified unary operator. ...
  52. Returns all the rows except blank row in a table, or all the values in a column, ignoring any filters that might have been ...
  53. Returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied inside ...
  54. Returns an integer containing either the number of characters in a string or the number of bytes required to store a variable. ...
  55. Returns an XML document containing information specific to this event. The document conforms to the schema at http://go. ...
  56. Returns information about a computer system using the Windows Management Instrumentation (WMI) Query Language. For example, ...
  57. Returns returns the number of items in a particular path string. This function returns 1 for the path generated for an ID ...
  58. Returns the current change tracking version for the database, which can be used with the CHANGETABLE function as the last_sync_version. ...
  59. Returns the current database system timestamp as a datetimeoffset value with the database time zone offset being perserved. ...
  60. Returns the location of the specified occurrence of a string within a character expression. The string parameter must evaluate ...
  61. Returns the member that is a specified number of positions following a specified member along the dimension of the member. ...
  62. Returns the member that is a specified number of positions prior to a specified member along the dimension of the member. ...
  63. Returns the nth item in the delimited list produced by the Path function, counting backwards from the last item in the path ...
  64. Returns the number of date and time boundaries crossed between two specified dates. The datepart parameter identifies which ...
  65. Returns the number of the characters at which a specific character or text string is first found, reading from left to right ...
  66. Returns the number of tokens in a string. A token may be marked by a delimiter in a specified set of delimiters. The string ...
  67. Returns the part of a character expression that starts at the specified position and has the specified length. The start ...
  68. Returns the property value for a given table identification number, index identification number, key identification number, ...
  69. Returns the rank of a number in a column of numbers. If more than one value has the same rank, the top rank of that set of ...
  70. Returns the rank of a specified tuple within a specified set, where the rank is based on the position of the tuple within ...
  71. Returns the rank of a specified tuple within a specified set, with the rank determined by the value of a specified numeric ...
  72. Returns the rank of an expression evaluated in the current context in the list of values for the expression evaluated for ...
  73. Returns the seed value specified during the creation of an identity column in a table or a view that has an identity column. ...
  74. Returns the set of descendants of a member at a specific distance away in the hierarchy, optionally including or excluding ...
  75. Returns the set of descendants of a member at a specified level, optionally including or excluding descendants in other levels. ...