June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – 2005 – Find Database Collation Using T-SQL and SSMS – Part 2

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL System Table
Previously I have written two different ways to find database collation SQL SERVER – 2005 – Find Database Collation Using T-SQL and SSMS. One of blog reader jwwishart has posted another method for doing the same. SELECT collation_name FROM sys.databases WHERE name = 'AdventureWorks' Reference : Pinal Dave (https://blog.sqlauthority.com)
Read More

SQL SERVER – 2005 – Connection Strings For .NET

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Utility
SQL Native Client ODBC Driver Standard security Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase; Uid=myUsername;Pwd=myPassword; Trusted Connection Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase; Trusted_Connection=yes; Connecting to an SQL Server instance Driver={SQL Native Client};Server=myServerName\theInstanceName;Database=myDataBase; Trusted_Connection=yes; SQL Native Client OLE DB Provider Standard security Provider=SQLNCLI;Server=myServerAddress;Database=myDataBase; Uid=myUsername;Pwd=myPassword; Trusted connection Provider=SQLNCLI;Server=myServerAddress;Database=myDataBase; Trusted_Connection=yes; Connecting to an SQL Server instance Provider=SQLNCLI;Server=myServerName\theInstanceName;Database=myDataBase; Trusted_Connection=yes; SqlConnection…
Read More