New answers tagged

-2 votes

Is it possible to filter the list of databases in the Object Explorer of the SSMS?

I use SSMS 18 and yes, I can filter the list of databases. My first step every morning is to filter to show only databases with the _DEV suffix. Also, the above answer omits the ability to filter by ...
user avatar
0 votes

Run MSSQL stored procedures containing SSIS packages using Windows Authentication from another computer

You can use SQL Server Authentication / a SQL Login to execute SSIS packages, as long as that account has the appropriate permissions provisioned. This might be the simpler route to go for your ...
user avatar
  • 24.2k
-1 votes

What does a RED X on a database user mean?

Right click on the user, select menu: script login as - create to - new query editor window Delete all but this: USE [master] GO ALTER LOGIN [user] ENABLE GO For me this did the trick on a SQL server ...
user avatar
1 vote

Setting up reporting and alerting in SQL Server through TSQL and Powershell

Create agent event alert for the errors that are written to the event log. Here's a util I did that generates a bunch, and can serve as a starting point. https://karaszi.com/agent-alerts-management-...
user avatar
2 votes

I am facing difficulties in backing up a database in MS SQL Server

I see you are using SQL 2019, not SQL 2022. I can see this from both object explorer and also from the backup path. The number 15 is for SQL 2019. SQL 2022 is still in private preview and not yet ...
user avatar

Top 50 recent answers are included