Issue on database name is numeric

[mvvilleza]

Hi all,

I recently run

backup log dbname with no_log

where dbname is a number, and i got a syntax error message. Is there a document from microsoft regarding this error?

 

[onpnt]

backup log [3] with no_log

Do the [ ] resolve the error?

Why is your database named with a number?

[sub]____________ signature below ______________
You are a amateur developer until you realize all your code sucks.
Jeff Atwood[/sub]

 

[mvvilleza]

That's the convention used by our vendor, anyway your suggestion worked. Thanks a lot

 

[ptheriault]

You should never start any object name with a number. I have the same problem with one of my vendors. I have to use [] for almost everything I do with them. I finally think they are starting to come around though. Their latest updates didn't have numbers. : )

- Paul

- If at first you don't succeed, find out if the loser gets anything.