June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – List All the Tables for All Databases Using System Tables

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Stored Procedure, SQL System Table, undocumented SQL
Today we will go over very simple script which will list all the tables for all the database. sp_msforeachdb 'select "?" AS db, * from [?].sys.tables' Update: Based on comments received below I have updated this article. Thank you to all the readers. This is good example where something small like this have good participation from…
Read More

SQLAuthority News – Gandhinagar SQL Server User Group Meeting April 24, 2009

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
DigiCorp, MVP, SQL User Group
Gandhinagar SQL Server User Group launch event was held on March 27, 2009. This successful, well-attended event received very positive and warm community response. Visit Gandhinagar SQL Server User Group Portal and register yourself now! We are going to meet again this month on April 24, 2009 Friday from 6:30PM…
Read More

SQL SERVER – FIX : Error: 18486 Login failed for user ‘sa’ because the account is currently locked out. The system administrator can unlock it. – Unlock SA Login

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server Security
Today, we will riffle through a very simple, yet common issue – How to unlock a locked “sa” login? It is quite a common practice that SQL Server is hosted on a separate server than application server. In most cases, SQL Server ports or IP are exposed to the web,…
Read More