Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Jun 13th, 2012  |  syntax: None  |  size: 0.26 KB  |  hits: 23  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. lastwaittype frequently beocmes SOS_SCHEDULER_YIELD in SQL server 2008 R2
  2. SELECT 'SQL Server '
  3. + CAST(SERVERPROPERTY('productversion') AS VARCHAR) + ' - '
  4. + CAST(SERVERPROPERTY('productlevel') AS VARCHAR) + ' ('
  5. + CAST(SERVERPROPERTY('edition') AS VARCHAR) + ')'