Install SQL Server Agent on Ubuntu (Linux)
With the release of SQL Server vNext CTP 1.4, the SQL Server Agent support is included. It enables DBAs to...
2017-06-16
3,071 reads
With the release of SQL Server vNext CTP 1.4, the SQL Server Agent support is included. It enables DBAs to...
2017-06-16
3,071 reads
As a continuation of “Database Monitoring using DMV” series, this blog will cover how quickly you can address the log...
2017-06-14 (first published: 2017-05-31)
5,760 reads
Installing SQL Server on Linux does not install SQL Server tools by default. You have to install it individually. In...
2017-06-13
1,669 reads
The release of Microsoft SQL Server 2017 brought a lot of very interesting new features. One of them is the...
2017-06-12
961 reads
Recently, I presented at Singapore SQL Pass Chapter on the topic T-SQL Fun, and the most of the attendees were...
2017-06-05
456 reads
In this blog, we are going to learn about the Distribution database, how to configure the Distribution database, and how...
2017-05-18 (first published: 2017-05-06)
12,065 reads
Recently, I was exploring SQL Server 2017 CTP 2.0 using SQL Server Management Studio V17. Till the time, I was...
2017-05-15
4,634 reads
In SQL Server 2017, you can use the new DMV sys.dm_os_enumerate_fixed_drives to identify free disk space. The DMV is replacement...
2017-05-15
1,522 reads
In the last two blogs, we went through Configure Distribution Database and Publication Creation. If you haven’t read them, I...
2017-05-10
3,602 reads
In the previous blog, we discussed how to Configure Distribution Database. Once you setup your Distribution database successfully, you can...
2017-05-09
2,843 reads
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...
By Steve Jones
I used Claude to build an application that loaded data for me. However, there...
hi , i know this is a sql server forum but i think my...
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
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