Vince wrote:I feel there is other reasons other than storing data in the C:\Program files, as Micro$oft SQL default instance data path resides in C:\Program Files\Microsoft SQL Server\MSSQL10.INSTANCE\MSSQL\DATA.(as an example)
I think its to do with 'Folder Virtualization' in Windows Vista.
Yes, and "Program Files" is one of those folders that get virtualized, even if the current user is an admin. Obviously Microsoft probably knows a way around it, but I'm not sure I've ever seen it. Microsoft says Isolated Storage is the way to go, at least in .NET-written code.