T-SQL Tuesday #005: Smart Card Login Breaks SQL Server 2008 Reporting Services
T-SQL Tuesday #005: Smart Card Login Breaks SQL Server Reporting Services 2008
This blog entry is participating in T-SQL Tuesday #005,...
2010-04-13
3,426 reads
T-SQL Tuesday #005: Smart Card Login Breaks SQL Server Reporting Services 2008
This blog entry is participating in T-SQL Tuesday #005,...
2010-04-13
3,426 reads
5 Random Thoughts on the SQL Server MCM Program
I've had some random thoughts running through my head since I finished...
2010-04-10
3,508 reads
2010-04-10
588 reads
How do I Write a Backup Strategy?
DBA's harp about the need to have backups. The first thing many DBA’s do when they inherit...
2010-04-09
963 reads
Catching Transient CPU Spikes Using SQL Trace If there was one thing I wish everyone who works with SQL Server would...
2010-04-06
4,526 reads
SQL Server 2008 MCM Results
3 weeks of intense training, intense studying, 3 written tests, and one 6 hour lab exam....
2010-04-04
1,438 reads
Making Sense of Replication Errors in Replication Monitor If you've ever had to deal with errors in Replication Monitor, your first...
2010-03-27
12,071 reads
Measuring Transactional Replication Latency Without Tracer Tokens SQL Server 2005 introduced Tracer Tokens (SQL 2005 | SQL 2008), a new methodology for...
2010-03-25
7,086 reads
Finding Date Ranges for Calculating StatisticsI received the following question from a fellow DBA:
I need your input to derive the...
2010-03-17
1,763 reads
Finding Date Ranges for Calculating StatisticsI received the following question from a fellow DBA:
I need your input to derive the...
2010-03-14
1,701 reads
By Steve Jones
Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity...
By Steve Jones
I used Claude to build an application that loaded data for me. However, there...
End-to-end NVMe vs SCSI testing over NVMe/TCP to a Pure Storage FlashArray: TPC-C and...
Good Evening, Is there a simpler way to rearrange the following WHERE condition: [Column_1]...
Comments posted to this topic are about the item Which Table I
Comments posted to this topic are about the item Using Python notebooks to save...
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