I have a SQL Server table with X being a date column defined as varchar. I need to retrieve non-monday days from the column. Can someone help here to retrieve the information?

When creating a new view, using the drag and drop function, a prohibition symbol appears.

I’m encountering an error in SQL Server Management Studio 2019(SSMS) when I attempt to create a new Entity-Relationship (ER) diagram. When I right-click to create a new diagram, I receive the error message: “Index was outside the bounds of the array.”

In SQL Server Management Studio, is there a way to view/set extended properties on a stored procedure parameter (not on the procedure itself)?

In MSSQL Management Studio, is there a way to view/set extended properties on a stored procedure parameter (not on the procedure itself)?

I’ve been getting the “Key not valid for use in specified state” message in both SSMS versions 19 and 20. My understanding is that this error comes from an encrypted password stored as part of a registered server.

quick question,

How is it possible that ObjectID 885578193 is in two different databases? Please see the screenshot included.

I have executed a query in SSMS. After waiting approximately 15mins for any results to be returned I cancelled the query.

Created a new table in SQLServer. Need to see the table structure and data in SSMS.
When I execute