2 results found
-
Schema added to properties when not required
Currently when I use Query designer the resulting query is expressed as:
SELECT Hygiene360Log.Hygiene360LogId, Hygiene360Log.RequestDate FROM dbo.Hygiene360Log
Where what I want is the minimum length of text to correctly identify tables and objects, like this:
SELECT Hygiene360LogId, RequestDate FROM Hygiene360Log
It's very annoying
3 votes -
Set Compatibility Level to SQL 2022 (160) on Edit Database Page
Right click on a database on a SQL Server 2022 Enterprise Edition Instance and select Edit Database. Switch to the Options tab. Select the Compatibility level dropdown, I am only seeing up to SQL Server 2019 (150) as options, I am missing the SQL Server 2022 (160) option and need to manually write the ALTER DATABASE statement to set it.
1 vote
- Don't see your idea?