Deleting a MS SQL Batch Object with single quote in the name
Posted on 2009-07-03
I am working with MS SQL Server 2005. Using a development tool, I have managed to create a batch object with single quotes in the object name. To wit: "Fix wo_srno item_srno_id's in wo's 1001-1007". Ugly name I know. In any case, I now find that I cannot drop this same batch object using that tool. I know it doesn't like the spaces and I suspect it also doesn't like the quote marks. I have tried using squarce brackets around the name to no avail. There has to be a simple way to delete this object, but I can't find it so I'm asking you fine people... Help!