2024-01-08
464 reads
default schema
Script to Set the SQL Server Database Default Schema For All Users
You may come across or even inherit a system where many of the users have different default schemas. Usually, this is easy to remedy - you go into Management Studio, right-click the user, and change the default schema through the UI. Or you write an ALTER USER command manually. But what if you have hundreds of users, across all of your user databases, that should all have the same default schema?
2013-11-22
3,684 reads
Blogs
Comparing My Current Schema with a Backup with SQL Compare
By Steve Jones
A customer asked if they needed to restore a database from backup to compare...
Improving Our Conversations
By Brian Kelley
If we aren't having the same conversation, we aren't going to be heard. That's...
How Do You Pick Events in Extended Events?
A while back I wrote about using AI to explore why people are not...
Forums
create a table with data capture for next 3 years
Hello, I would like to build a table capturing data starting from 1st day...
Is GenAI Coming Faster Than You Think?
Comments posted to this topic are about the item Is GenAI Coming Faster Than...
Local Storage Options
Comments posted to this topic are about the item Local Storage Options
Question of the Day
Local Storage Options
I'm setting up a SQL Server 2019 instance and we are planning on using SMB storage for our database files. However, the file share isn't ready, so the idea is to use the \127.0.0.1dbfile as the location to start and then move these files to the remote server. Can I do this?
See possible answers