How to Move Master Database to Another Location – SQL Server On Linux
With the release of SQL Server 2017 CU4, you can use the mssql-conf utility to move the master database file...
2018-03-07 (first published: 2018-02-23)
2,083 reads
With the release of SQL Server 2017 CU4, you can use the mssql-conf utility to move the master database file...
2018-03-07 (first published: 2018-02-23)
2,083 reads
In my introduction to Extended Events blog, I mentioned that the xEvent is my favorite toy for performance troubleshooting. This blog may...
2018-03-05 (first published: 2018-02-20)
10,847 reads
In my previous post on new functions in SQL Server 2017, I discussed about the STRING_AGG function. Here, I am...
2018-03-02
1,369 reads
SQL Server 2017 introduces a set of useful functions like STRING_AGG(), STRING_SPLIT(), TRIM()… and many more. In this tip, I am...
2018-02-28
9,367 reads
Recently, I was working with the team and got stuck up with SQL Server Installation information. We got an urgent...
2018-02-27
17,019 reads
In my recent blog, I discussed about how to move master database to another location. One of the readers requested...
2018-02-26
742 reads
I continue blogging on extended events. Today, I will discuss about the top level containers (Package) that gives access to...
2018-01-25
498 reads
“How much time SQL Server is going to take to complete the database Backup or Restore” – This is one of...
2017-12-21 (first published: 2017-12-09)
34,141 reads
Since I started actively participating in SQL community, I found it is very common that people will approach to seek...
2017-12-19
2,190 reads
This article is about how to proceed when you forgot the password of your SQL Server “sa” account, Password was entered...
2017-12-11
39,710 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