A Guide for Decrypting SQL Server Database Objects
Overview
The SQL Server 2005 and SQL Server 2008 provide a new feature for encrypting data to protect it from...
2018-02-28 (first published: 2018-02-16)
4,385 reads
Overview
The SQL Server 2005 and SQL Server 2008 provide a new feature for encrypting data to protect it from...
2018-02-28 (first published: 2018-02-16)
4,385 reads
Overview of SQL Server Error 3013
One of the most frustrating situations that a user experiences while working with SQL Server...
2018-02-17
17,501 reads
The Importance of Log Files in SQL Server
On the SQL server every day we perform many transactions and as we...
2018-02-05
3,424 reads
Introduction
Creating a good backup and recovery plan for SQL database is a very important task of a database administrator. A...
2018-02-02
2,421 reads
Overview
In our previous section we have discussed how to create an audit trigger in SQL Server and how it helps...
2018-01-29
1,724 reads
SQL Server is one of the finest database management system deployed by organizations for storing and retrieving their data. It...
2018-01-22 (first published: 2018-01-13)
51,315 reads
Most of the time users need to import their data into SQL Server for its proper management. Select from the...
2018-01-22
799 reads
REPAIR_ALLOW_DATA_LOSS is the repair level, which is recommended by DBCC CHECKDB when the database is found in a corrupted state.SQL...
2018-01-19
3,200 reads
Database Console Command CHECKDB (DBCC CHECKDB)is used to check the integrity (physical & logical) of objects in a SQL Server database.The...
2018-01-17
62,468 reads
Management of the database is very much essential in today’s date and for doing this, there is a need to...
2018-01-15
3,239 reads
By Brian Kelley
Following the advice in Smart Brevity improves communication.
By John
Microsoft has released SQL Server 2025, bringing big improvements to its main database engine....
By Steve Jones
A customer was asking about what certain items in Redgate Monitor mean. They have...
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...
Comments posted to this topic are about the item Your AI Successes
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