tag:blogger.com,1999:blog-2437651727370625818.post6673073992022826136..comments2023-11-25T00:44:31.814-08:00Comments on Ram's Blog: Rename .MDF File...BI_Buffhttp://www.blogger.com/profile/06254495164438608712noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-2437651727370625818.post-83523735623963643242012-08-23T21:04:25.550-07:002012-08-23T21:04:25.550-07:00Thanks a lot.. it worked for me..Thanks a lot.. it worked for me..Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2437651727370625818.post-62228627218017993032011-09-13T11:28:37.075-07:002011-09-13T11:28:37.075-07:00Thank you Michael for your comments. I should incl...Thank you Michael for your comments. I should include the note you mentioned about not working in SQL Server 2000. The features listed in the post works in later versions of sql server.BI_Buffhttps://www.blogger.com/profile/06254495164438608712noreply@blogger.comtag:blogger.com,1999:blog-2437651727370625818.post-91539109082270172332011-09-12T12:04:37.290-07:002011-09-12T12:04:37.290-07:00As a note this doesn't seem to work with MS SQ...As a note this doesn't seem to work with MS SQL 2000. The error message is "Database 'databaseName' cannot be opened because it is offline.'<br /><br />I couldn't find a good description of what 'offline' really means. I could understand it allow you do manipulate the filename. And I can understand it not allowing you to do much. Seems like MS might have moved from one idea to the other over time.Michael Hunterhttps://www.blogger.com/profile/08707643863169053383noreply@blogger.com