syntax to specify domain

• jzhou

  SSCommitted

  Points: 1863

  More actions

  May 28, 2002 at 4:13 pm

  #157909

  I try to execute:

  DROP TABLE window_group_name\username.procedure_name

  and the got this error message:

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

  Line 1: Incorrect syntax near '\'.

  So how should I specify "\" for the domain?

  Thank you.

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  May 28, 2002 at 7:11 pm

  #429868

  Try adding brackets [] around it.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter

• jzhou

  SSCommitted

  Points: 1863

  More actions

  May 28, 2002 at 9:00 pm

  #429870

  got it! Thank you.