Msg 102, Sev 15, State 1, Line 1 : Incorrect syntax near 'E6-COOP'. [SQLSTATE 42000]

hi i get this error in the error log can some one help please:
Msg 102, Sev 15, State 1, Line 1 : Incorrect syntax near 'E6-COOP'. [SQLSTATE 42000]

my job runs a piece of transact sql:
use master
GO
ALTER DATABASE "E6-COOP"
MODIFY FILE
   (NAME = "E6-Coop",FILEGROWTH = 200MB)
GO
ALTER DATABASE "E6-COOP"
MODIFY FILE
   (NAME = "E6-Coop_log",FILEGROWTH = 200MB)
GO
LVL 1
hraja77Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
Hello hraja77,





Aneesh R

ALTER DATABASE [E6-COOP]
MODIFY FILE
   (NAME = [E6-Coop],FILEGROWTH = 200MB)
GO
ALTER DATABASE [E6-COOP]
MODIFY FILE
   (NAME = [E6-Coop_log],FILEGROWTH = 200MB)
GO

Open in new window

0
 
hraja77Author Commented:
excellent thanks !!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.