Use SQL 2008 Express As A Central Management Server
I had the chance to catch Brent Ozar's webcast last week on creating a poor man's CMDB. In it he...
2009-04-20
890 reads
I had the chance to catch Brent Ozar's webcast last week on creating a poor man's CMDB. In it he...
2009-04-20
890 reads
With every new version of SQL Server comes a set of deprecated features. Usually Microsoft gives fair warning that these...
2009-04-15
582 reads
As a production DBA I love to tweak things to optimal perfection. After all, if I paid for the hardware...
2009-04-01
537 reads
On Saturday, 3/28, I presented Useful T-SQL Statements You May Not Be Aware Of at the 2009 Orlando .NET Code...
2009-03-31
1,435 reads
I manage a lot of replication publications\subscriptions and when I get a latency or agent failure alert it always bugs...
2009-03-25
846 reads
Today is Ada Lovelace Day, an international day of blogging to draw attention to women excelling in technology. I don't...
2009-03-24
739 reads
I recently read a NYT article that highlighted how Google search data is being used to predict flu outbreaks at...
2009-03-23
842 reads
I've got three speaking engagements lined up in next two months:
Wed, March 11 @ oPASS: The Truth About Disk Performance & Configuration....
2009-02-26
1,400 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