Query Table Metadata
There will inevitably come a day when you want to take a look at the metadata of the tables inside...
2011-06-23
5,266 reads
There will inevitably come a day when you want to take a look at the metadata of the tables inside...
2011-06-23
5,266 reads
Configurations in SSIS are a lovely tool that when implemented correctly can greatly reduce package maintenance. It is very possible...
2011-06-14
878 reads
I want to say a huge thank you to everyone who attended the webinar from Pragmatic Works (website) that I...
2011-06-10
677 reads
If you were able to make it out to SQL Saturday in Pensacola this past weekend I want to say...
2011-06-07
635 reads
I know it has been almost a month since I posted last and this is not really a “real” post,...
2011-06-01
423 reads
Hopefully if you came to my session this year at SQL Saturday in Jacksonville, FL you came away with some...
2011-05-04
512 reads
There will come a day, if it has not already come and gone, when you will want to search through...
2011-04-26
1,065 reads
Checkpoints in SSIS are a great tool and they definitely have their place. The downside to them is that they...
2011-04-25
1,100 reads
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
By Brian Kelley
If you don't have a plan, you'll accomplish it. That's not a good thing.
By Steve Jones
Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity...
The thread for the league in 2026. Players from last year have priority.
The previous DBA created a certificate which expired 12/31/2025. I came in hoping to...
hi , i know this is a sql server forum but i think my...
I have this code in SQL Server 2022:
CREATE SCHEMA etl;
GO
CREATE TABLE etl.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT etl.product
VALUES
(2, 'Bee AI Wearable');
GO
CREATE TABLE dbo.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT dbo.product
VALUES
(1, 'Spiral College-ruled Notebook');
GO
CREATE OR ALTER PROCEDURE etl.GettheProduct
AS
BEGIN
SELECT ProductName
FROM product;
END;
GO
When I execute this code as a user whose default schema is dbo and has rights to the tables and proc, what is returned? See possible answers