Hi All, Once I had to find out few details of available database snapshots in SQL Server. I wrote following script which helped me to find out following: how many database-snapshots are available & live whats the size1 of database snapshot as well as the allotted size2 for database snapshot What collation is assigned to it where it is physically located in my hard-drive 1. Size of database snapshot = Actual Size in query results 2. Size allotted for database snapshot = File Size in query results