I am running simple DBCC CHECKDB ('DBNAME')
command on my machine every thing works perfect!
But when i execute same command on the live server the command executes without any error, but it creates one extra file int the same location as my mdf file. For instance, if my mdf file name is "mydatabase.mdf"
then this command is creating one more file with name "mydatabase.mdf "
. Additionally, I am not able to delete this file.
Whats wrong here?