Is it possible to view the contents of a local temporary table, created on a different connection?
Say we run this code on connection 1:
CREATE TABLE #Private
(
[data] nvarchar(30) NOT NULL
);
GO
INSERT #Private
(
[data]
)
VALUES
(
N'Only I can see this'
);
Is there a way to see the contents of the #Private
table from connection 2?
It isn’t particularly easy, but a user with sysadmin
permissions, a bit of internal knowledge (and some patience) can do it.