Error 5041 In EM & QA

• pruello

  SSC Veteran

  Points: 218

  More actions

  February 24, 2003 at 1:39 am

  #63260

  I've some troubles using the following T-SQL command in QA (I have the same error in enterprise Mgr):

  Use AppLive

  ALTER DATABASE Applive MODIFY FILE(NAME = 'Applive_Data',MAXSIZE = 1GB)

  GO

  I have the following msg: "Error 5041: MODIFY FILE failed. File 'Applive_Data' does not exist."

  I use sp_helpdb and I copy and paste the logical name of the file. So I don't see where's the trouble.I tried to stop and restart the server and there's no changes.If anyone could help.Thanks.

• Antares686

  SSC Guru

  Points: 125444

  More actions

  February 24, 2003 at 4:50 am

  #449551

  I just tried and had no issues.

  Run

  SELECT * FROM AppLive..sysfiles

  to verify the filename as well. But the syntax causes me no issues.

• pruello

  SSC Veteran

  Points: 218

  More actions

  February 24, 2003 at 4:56 am

  #449552

  I tried this before also and the result is the same that sp_helpdb: 'Applive_Data'

  quote:

  ---

  I just tried and had no issues.

  Run

  SELECT * FROM AppLive..sysfiles

  to verify the filename as well. But the syntax causes me no issues.

  ---