I am trying to include the datetime column back into the result set after doing the except.

Add the date column after the except is excecuted along with the rest of the columns - A,C,D,E

ok.thanks

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

https://sqljana.wordpress.com/2017/09/22/powershell-save-millions-by-downgrading-your-sql-server-edition-partially-automate-it/

which says that it does not. Anybody tested it.

Thank you. That was really helpful

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...

yes

ok..but we are unable to see sqlagent.how can that be fixed

• This reply was modified 5 months, 3 weeks ago by mtz676.

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...

• This reply was modified 5 months, 3 weeks ago by mtz676.
• This reply was modified 5 months, 3 weeks ago by mtz676.

error attached.

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

it is enabled

Thanks Scott

• This reply was modified 8 months, 2 weeks ago by mtz676.
• This reply was modified 8 months, 2 weeks ago by mtz676.
• This reply was modified 8 months, 2 weeks ago by mtz676.

Thank you Jeff. Looks like my google search was not good enough. Thanks again.That helped.

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

• This reply was modified 8 months, 3 weeks ago by mtz676.