syntax error

• John Tabor

  Old Hand

  Points: 381

  More actions

  January 21, 2005 at 2:41 pm

  #87372

  Server: Msg 170, Level 15, State 1, Line 1

  Line 1: Incorrect syntax near '2'.

  Server: Msg 170, Level 15, State 1, Line 1

  Line 1: Incorrect syntax near 'ersonName style="BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x">testersonName>'

   

  The database is "2test" and I have noticed that any database that starts with a number gets this error when clearing the transaction logs with:

  "USE 2test

  GO

  DBCC SHRINKFILE (2test_log, 1)"

  is there a work around for this?

• Kathi Kellenberger

  SSChampion

  Points: 11811

  More actions

  January 21, 2005 at 9:58 pm

  #538639

  See if this helps:

  USE [2test]

  GO

  DBCC SHRINKFILE ([2test_log], 1)

   

  Aunt Kathi Data Platform MVP
  Author of Expert T-SQL Window Functions
  Simple-Talk Editor

• John Tabor

  Old Hand

  Points: 381

  More actions

  January 23, 2005 at 9:06 pm

  #538690

  Great Thanks! Are you aware of this causing any other unforseen problems?

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  January 24, 2005 at 6:37 am

  #538717

  No.. Just the same problem over and over again. Can you rename the database so that it can't be an isse from now on?

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  January 24, 2005 at 2:04 pm

  #538826

  John,

  for your future postings here, please refrain from posting the same question in multiple fora. http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=157096

  Most members follow all fora, so there is no need for it. It actually makes it difficult for everyone to track who has answered what where already.

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]