This script will change the owner of the stored procedure to dbo. It must be run in the same database as the stored procedures.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2001-10-28

1,631 reads

Blogs

Superheroes and saints never make art. Only imperfect beings can make art because art...

One feature that I have been waiting for years! The new announcement around optimize...

Following on from my last post about Getting Started With KubeVirt & SQL Server,...

Forums

Comments posted to this topic are about the item The AI Bubble and the...

Hi, in a simple oledb source->derived column->oledb destination data flow, 2 of my...

hi, i noticed the sqlhealth extended event is on by default , and it...

I am currently working with Sql Server 2022 and AdventureWorks database. First of all, let's set the "Read Committed Snapshot" to ON:

use master;
go

alter database AdventureWorks set read_committed_snapshot on with no_wait;
go

Then, from Session 1, I execute the following code:

--Session 1
use AdventureWorks;
go

create table ##t1 (id int, f1 varchar(10));
go

insert into ##t1 values (1, 'A');

From another session, called Session 2, I open a transaction and execute the following update:

--Session 2
use AdventureWorks;
go

begin tran;
update ##t1 
set f1 = 'B'
where id = 1;

Now, going back to Session 1, what happens if I execute this statement?

--Session 1
select f1
from ##t1
where id = 1;