SQL System Table Archives - Page 9 of 13 - SQL Authority with Pinal Dave

SQL SERVER – Query to Find Column From All Tables of Database

August 6, 2008

SQL Data Storage, SQL Scripts, SQL Stored Procedure, SQL System Table

One question came up just a day ago while I was writing SQL SERVER – 2005 – Difference Between INTERSECT and INNER JOIN – INTERSECT vs. INNER JOIN. How many tables in database AdventureWorks have column name like ‘EmployeeID’? It was quite an interesting question and I thought if there…

SQL SERVER – 2005 – Get Field Name and Type of Database Table

August 5, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL System Table

In today’s article we will see question of one of reader Mohan and answer from expert Imran Mohammed. Imran thank you for answering question of Mohan. Question of Mohan: hi all, how can i get field name and type etc. in MS-SQL server 2005. is there any query available??? Answer…

SQL SERVER – mssqlsystemresource – Resource Database

July 27, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Scripts, SQL System Table

Just a day ago I received following email “Dear Pinal, While I was exploring my computer in directory C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data I have found database mssqlsystemresource. What is mssqlsystemresource? Thanks, Joseph Kazeka” Simple question like this are very interesting. mssqlsystemresource is Resource Database. It is read only database and…

SQL SERVER – 2005 -Track Down Active Transactions Using T-SQL

July 24, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL System Table, SQL Transactions

Just a day ago, I was wondering how many active transaction are currently in my database. I found following DMV very useful – very simple and to the point. Following SQL will return currently active transaction. SELECT * FROM sys.dm_tran_session_transactions Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database – Part 2

May 8, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Scripts, SQL System Table

What I love most about this blog is active readers participation. If readers are becoming contributor is the true success for any blog or online community. Recently many readers have contributed their suggestions and script to this blog. Joffery has provided nice script which is modification to previous article of…

SQL SERVER – Find Table in Every Database of SQL Server – Part 2

April 30, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL System Table

Yesterday I wrote about SQL SERVER – Find Table in Every Database of SQL Server. Today we will see another method how we can achieve the same result using Information_Schema view. Refer my previous article here for additional information. CREATE PROCEDURE usp_FindTableNameInAllDatabase @TableName VARCHAR(256) AS DECLARE @DBName VARCHAR(256) DECLARE @varSQL…

SQL SERVER – Find Table in Every Database of SQL Server

April 29, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL System Table

Just a day ago, one of the Jr. Developer requested that if I can help her with finding one particular table in every database on SQL Server. We have many Database Server and on some of the Database Server we have nearly 200 databases on it. The requirement was to…