Post reply

Error 5041 In EM & QA

  • 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.

  • 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.

  • 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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply