I've some troubles using the following T-SQL command in QA (I have the same error in enterprise Mgr):
ALTER DATABASE Applive MODIFY FILE(NAME = 'Applive_Data',MAXSIZE = 1GB)
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.