Yes, there are free versions of Visual Studio and the BI development workload is free.

You can also use developer of SQL Server for free, or Express.

What's the code you tried to do these?

What if you ran the first time as admin? Or did you?

It's not listed in BOL. Perhaps because there could be some issues with AGs/clustering and having the database move between nodes. In that case, the same database you connected to...

What's the error you get? Also, remove the insert and write the select. What happens here?

Thanks

Glad it made you think

Closing this thread as it has gotten off topic and a little out of hand. My apologies for not doing this sooner.

If you wish to discuss politics or...

The more data you delete in one batch, the larger the log records and and the more locks taken. Often easier and faster to delete in batches rather than one...

That's only a part of what auditing is. Auditing is deciding what information to capture, when, and for this objects. You have the last one, but what information needs to...

What do you need to audit? You still haven't defined this.

Reboot.

There isn't an expiration date, as noted, for licenses editions. For evals, use this:

SELECT

@@SERVERNAME SERVERNAME,

CREATE_DATE ‘INSTALALTIONDATE’,

SERVERPROPERTY(‘EDITION’) ‘Version’,

DATEADD(DD, 180, CREATE_DATE) AS ‘EXPIRY DATE’

FROM SYS.SERVER_PRINCIPALS

WHERE SID =...