Viewing 15 posts - 1 through 15 (of 348 total)
I am trying to include the datetime column back into the result set after doing the except.
June 3, 2025 at 3:45 am
Add the date column after the except is excecuted along with the rest of the columns - A,C,D,E
June 2, 2025 at 1:28 pm
Does this method ...
https://www.sqlskills.com/blogs/jonathan/downgrading-sql-server-editions/
work for SQL Server versions 2014 and above ?
There is this article
which says that it does not. Anybody tested it.
April 29, 2025 at 11:22 am
Once you use enterprise and enterprise features are being used by the databases are you stuck with enterprise forever ?
and cannot downgrade to standard ?
And if the databases on enterprise...
April 22, 2025 at 3:16 pm
ok..but we are unable to see sqlagent.how can that be fixed
April 2, 2025 at 10:49 am
yes. we see the function. but we do not have sysadmin.
SELECT roles.principal_id AS RolePrincipalID
, roles.name AS RolePrincipalName
, server_role_members.member_principal_id AS MemberPrincipalID
, members.name AS MemberPrincipalName
FROM sys.server_role_members AS server_role_members
INNER JOIN sys.server_principals AS roles
ON...
April 2, 2025 at 10:06 am
ERROR:cannot find either column msdb or user-defined function or aggregate msdb.dbo.fn_syspolicy_is_automation_enabled
When we right click on server/database .... we get that error
April 2, 2025 at 9:47 am
Thank you Jeff. Looks like my google search was not good enough. Thanks again.That helped.
January 2, 2025 at 7:44 am
How can I continously import extended events files into a sql server table as and when they are created and once imported remove them from the directory. Thanks
December 31, 2024 at 4:44 pm
Viewing 15 posts - 1 through 15 (of 348 total)