View logical log filename and physical location (current DB only).select physical_name from sys.database_files where type = 1 View logical log filename for all DBs: select a.name, b.name as ‘Logical filename’, b.filename from sys.sysdatabases ainner join sys.sysaltfiles bon a.dbid = b.dbid where fileid = 2
Category: Microsoft
Microsoft Web Platform Installer 2.0
The Microsoft Web Platform Installer 2.0 (Web PI) is a free tool that makes it simple to download, install and keep up-to-date with the latest components of the Microsoft Web Platform, including Internet Information Services (IIS), SQL Server Express, .NET Framework and Visual Web Developer. In addition, install popular open source ASP.NET and PHP web […]