python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - dbo

Prevent User Usage of "dbo" in User Databases SQL Server

I am attempting to prevent usage of the default schema of "dbo" in my SQL Server databases. This is being applied to an existing long term project with ongoing maintenance where the develope...
test-img

DarrenMB

sql-server

standards

consistency

dbo

Votes: 0

Answers: 2

Latest Answer

I feel like it would be 10,000 times simpler to just DENY ALTER on the dbo schema: DENY ALTER ON SCHEMA::dbo TO [<role(s)/user(s)/group(s)>]; That's not too handy if everyone connects as sa but...
test-img

Aaron Bertrand

How to find location in database of CPU intensive query?

I have a server called "Reporting" and looking at SQL Server performance reports, specifically "Top Queries by Total CPU Time". I have found the top CPU Time consuming queries. The...
test-img

Will

sql-server

database-administration

dbo

Votes: 0

Answers: 1

Latest Answer

As you have the object id you can just use the following to find the object USE Training; SELECT OBJECT_SCHEMA_NAME(1727285326) AS schema_name, OBJECT_NAME(1727285326) AS object_name; ...
test-img

Martin Smith

Posts

Questions

Blogs

Jobs