Microsoft SQL Server Front End Blog

The writers of this blog are a part of the Microsoft SQL Server Manageability team. We will be blogging about our tools, scripts, webcasts, and miscellaneous tips that will help you get the most out of SQL Agent, Data collector and other tools

Browse by Tags

Tagged Content List
  • Blog Post: SQL Agent Issue with identifiers delimited by double quotation marks

    The issue is related to default settings for quoted_identifier. In SSMS query window the default settings for quoted_identifier is ON. It means that the following code will work: DECLARE @Days INT SELECT @Days = 5 SELECT 'Test' , DateAdd ( "dd" , @Days , GetDate ()) But if you copy and paste...
Page 1 of 1 (1 items)