June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check

SQL SERVER – 2005 – List all the database

May 12, 2007
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Stored Procedure, undocumented SQL
List all the database on SQL Servers. All the following Stored Procedure list all the Databases on Server. I personally use EXEC sp_databases because it gives the same results as other but it is self explaining. ----SQL SERVER 2005 System Procedures EXEC sp_databases EXEC sp_helpdb ----SQL 2000 Method still works…
Read More
CLR Support

SQL SERVER – Fix : Error : Msg 6263, Level 16, State 1, Line 2 Enabling SQL Server 2005 for CLR Support

May 12, 2007
Pinal Dave
SQL
CLR, SQL Advanced Option, SQL Error Messages, SQL Scripts, SQL Server

Error:
Fix : Error : Msg 6263, Level 16, State 1, Line 2 Enabling SQL Server 2005 for CLR Support

1) Enable Server for CLR Support.

Read More

SQL SERVER – Explanation SQL Command GO

May 11, 2007
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Utility
GO is not a Transact-SQL statement; it is often used in T-SQL code. Go causes all statements from the beginning of the script or the last GO statement (whichever is closer) to be compiled into one execution plan and sent to the server independent of any other batches. SQL Server…
Read More

SQL SERVER – Download Microsoft SQL Server 2005 System Views Map

May 11, 2007
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Download
The Microsoft SQL Server 2005 System Views Map shows the key system views included in SQL Server 2005, and the relationships between them. It is available to download from Microsoft Site. It can be printed and mounted at Office Depot or Kinko’s. Download SQL SERVER 2005 System Views Reference :…
Read More

SQL SERVER – 2008 Katmai – Download Datasheet Final from Microsoft

May 10, 2007
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Download
Few interesting thing about Katmai. SQL Server “Katmai” will provide a more secure, reliable and manageable enterprise data platform. SQL Server “Katmai” will enable developers and administrators to save time by allowing them to store and consume any type of data from XML to documents. SQL Server “Katmai” provides a…
Read More

SQL SERVER – Fix: Error: HResult 0x2, Named Pipes Provider: Could not open a connection

May 10, 2007
Pinal Dave
SQL
Computer Network, SQL Error Messages, SQL Server

In this blog post we are going to fix the error which is related to Named Pipes Provider.

Read More

SQL SERVER – 2008 Katmai – Your Data, Any Place, Any Time

May 10, 2007
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, DBA, SQL Download
I was following up on the news of first Microsoft Business Intelligence (BI) Conference held at Seattle. Good news is – SQL Server 2008 code name ‘Katmai’ is announced. I went to the official website I like the catchy line “Your Data, Any Place, Any Time“. As per my opinion…
Read More
Previous 1 … 502 503 504 505 506 507 508 … 519 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2025 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version