GRANT with GRANT was listed at the top. This permission was given.

I don't think you're going to master something. You're doing to dip into a stream, get some skill and competence, and much of that will continue to be valuable over...

Can you explain more what you are doing and seeing? What differences do you see? When you look in the folder, it's unclear what you are checking here. Is it...

This works for me:

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE OR alter PROCEDURE spPackageHistory_Tblu
AS
SELECT GETDATE(), 'test', 'test'


GO

IF EXISTS ( SELECT 1 FROM tempdb.dbo.sysobjects WHERE ID = OBJECT_ID(N'tempdb..#PackageMainTblu') )
DROP TABLE...

There are no service packs anymore, only cumulative updates. The non SA license does get CUs, but it doesn't give you upgrades, and some HA rights. The SA allows you...

I would have thought most people would look to adopt a PaaS approach, often because of cost, but that's not the case. PaaS often requires more application changes and code...

Yep, apparently testing and copy/pasting doesn't work well.

answer edited.

with your permission set, if I grant that to a user, I get this error for the grant for a procedure:

Msg 15151, Level 16, State 1, Line...

A number of people have asked for more programmability, but the QO/QP team needs to support this. They tried functions, but the implementation wasn't good. Even with the changes in...

I've thought about that myself. Power is a big issue out here, but I was considering trying to make a zero energy space with solar, a few batteries, etc.

Honestly, use something like FlywayDB Community or a similar framework. No need to reinvent this stuff.

Mostly agree with the above. Use a SAN. VPNs tend to be fairly cheap and work well, but in the long term you might want some type of app. I'd...

If you don't want second alerts, what I might do is log alerts as they are sent based on a silo and time. If you have sent an alert in...

How can you tell if there is more data in the table? You can count rows, but if someone adds a row and deletes a row, you won't be alerted.

As...

This might also help: https://www.sqlservercentral.com/steps/stairway-to-xml-level-4-querying-xml-data