How to know the physical location of a databse in SQL?

Go to SQL Server Management Studio and open a new query pane.

Copy and paste the following querry to verify the physical path of 'mydb'

Replace 'mydb' with your database.

SELECT name, physical_name
FROM sys.master_files
WHERE database_id = DB_ID('mydb')

Cick Execute.

In the physical_name column, you should see the path to the new location

How to check the Database compatibility level in SQL 2005?

Use the below commands to check and change a db compatibility level

To check compatibility level exec sp_dbcmptlevel 'yourdbname'
Eg: exec sp_dbcmptlevel 'yourdbname'


To change compatibility level exec sp_dbcmptlevel 'yourdbname',80
Eg: exec sp_dbcmptlevel 'yourdbname',90

Page cannot be found" when browsing aspx pages in Windows Server 2003 with IIS 6.0

You may get a Page cannot be found message when you browse aspx pages in a Windows Server 2003 environment.

That is because in Windows 2003, all the webservice extensions are "Prohibited" by default to ensure security.

To resolve this, do the following steps:-

1. From your Run command, type inetmgr and press enter.
2. Expand the appropriate nodes in the IIS to locate the "Webservice Extensions" Node
3. Click on the same.
4. You will find a list of "prohibited" extensions in the right.
5. Click on ASP.NET and Active Server Pages and "allow" it

That should resolve this issue.

This article applies for Windows Server 2003, IIS 6.0 environment

Happy Supporting

Rajesh Kamalakshan