From: Chris McMahon <christopher.mcmahon@...>
Date: 2006-01-12T07:13:04+09:00
Subject: escaping in MSSQL script?



Hi...
Can anyone suggest the proper way to escape the backslashes in the
directory name in the following script?


d = c.run("ALTER DATABASE fooDB MODIFY FILE (NAME = foo_log, FILENAME =
'C:\\Program Files\Microsoft SQL
Server\MSSQL\fooPlus\fooPlus_log.LDF'")

The obvious solutions yield either "Incorrect syntax..." or "Invalid
escape character syntax" messages.  

Thanks...
-CHris