When you execute a proc in SQL Server, there must be a SQL Server login associated with that execution.

There should also be database-level users associated with the login and those...

It sounds like a permissions problem. When the Python script executes, what is its user context and does this user have the permissions required on MSDB?

Can you try executing the...

Does the update work OK when executed from Python? That is, is the only problem with the mail send part?

It should be.

Is there any easy way to :

Search Stored Procedures for a string (I can do this ok)

If say 10 are returned, just click on each one and  go into...

Click the New button and create the connection to the file. Then go ahead and use that.

I've never used avro files before, so cannot help with specifics.

Like this?

DECLARE @List VARCHAR(50) = 'item1,item2,item3';

SELECT
    @List
,   NewVersion = CONCAT('(', '''', REPLACE(@List, ',', ''','''), '''', ')');

The HDFS component is available from a native installation of SSIS and does not require the installation of a Hadoop server.

The HDFS connection manager allows SSIS to connect to the...

Or add the IDENTITY after the SELECT INTO

SELECT TOP (10) * INTO #Test FROM sys.columns c

ALTER TABLE #Test ADD SomeId INT IDENTITY(1,1)

SELECT * FROM #Test t

Is there a specific question there, or are you...

Hi Guys

I need to write a procedure to validate an SA identity number (a SSN in the west).  Please look at the attached doc for a detailed explanation.

Thank you...

Deleted

• This reply was modified 4 years, 11 months ago by Phil Parkin.

Excellent detective work there. I had not realised that file association arguments were stored like that in the Registry.

Unfortunately, it won't. It will instead try to execute locally.

But all is not lost, you can use Powershell Remoting...

Are you hoping that the script will execute on the remote server? Or is that just the place where you store PoSh scripts?