June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Introduction to SERVERPROPERTY and example

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Function, SQL Scripts
SERVERPROPERTY is very interesting system function. It returns many of the system values. I use it very frequently to get different server values like Server Collation, Server Name etc. Run following script to see all the properties of server. SELECT 'BuildClrVersion' ColumnName, SERVERPROPERTY('BuildClrVersion') ColumnValue UNION ALL SELECT 'Collation', SERVERPROPERTY('Collation') UNION…
Read More

SQL SERVER – Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Data Storage, SQL Download
Note: Download Here by Microsoft Microsoft SQL Server 2008 Reporting Services Add-in for SharePoint Technologies Release Candidate (RC0) (Reporting Services Add-in) enables you to take advantage of SQL Server 2008 Release Candidate (RC0) report processing and management capabilities within Windows SharePoint Services (WSS) 3.0 or Microsoft Office SharePoint Server 2007.…
Read More