The most likely cause is that your firewall does not allow outbound connection to the gmail SMTP server. I'm assuming your SSIS package i running in a corporate environment.

You say...

You don't really need sys.indexes in the row-count query:

OUTER APPLY (
    SELECT SUM(p.rows) AS TotalRows
    FROM sys.partitions p
  ...

BTW, maybe you could edit your question and change references to Visio (which is a completely different Microsoft product) into Visual Studio?

That would make it much easier to know what...

I notice that the version of the SSDT you have installed seems to be 14.0.xxx - and I think for Visual Studio 2017 it needs to be 15.0.xxxx. This could...

Try this:

SELECT
    CONCAT(SCHEMA_NAME(t.schema_id), '.', t.name) AS TableName
    , t.create_date AS CreatedDate
    , t.modify_date AS LastModifiedDate
   ...

How about this, would this be helpful?

WHILE NOT EXISTS (SELECT  * FROM table1 WHERE Text LIKE '%fire%' ) BEGIN
    WAITFOR DELAY '00:00:10'
END;
THROW 50000,'Some error...

• This reply was modified 3 years, 1 month ago by kaj. Reason: Added comment about an alternative (better?) solution
• This reply was modified 3 years, 1 month ago by kaj. Reason: Typo: reate --> create

Sorry, I hereby withdraw my entry. I used a bit operator, not the power function, and that does work with the testdata, but is not a valid general solution. The...

I work on sql server 2019 i face issue i need to give unique number to every group of numbers without using string aggreagte or stuff

...

what i try

            
July 25, 2022 at 8:11 pm
            
#4068076

            
            
                                                
        

What OS version is the remote SQL Server 2012 running on?

If the server is runningWindows Server 2012 or older, it may not have the cipher suite to support a TLS1.1...

Yes, but do you have a copy of the database on a different server, and access the table in the remote copy from the view (using four-part identification and linked...

Are you absolutely sure of that?

Because according to the documentation the columns referenced_server_name, referenced_schema_name and referenced_entity_name are only not-null if an object is...

• This reply was modified 3 years, 1 month ago by kaj. Reason: Typo: shure --> sure

It does look strange. I notice that there are some implicit conversions involved - the parameter @p8 is converted/cast to nvarchar(4000) and the cid column is likewise implicitly converted/cast to...

Easy now! 🙂

He did...

• This reply was modified 3 years, 1 month ago by kaj. Reason: typo: you --> your
• This reply was modified 3 years, 1 month ago by kaj.

I'm no expert on Powershell scripts by a long shot, but I think you should try to do an explicit cast to NVARCHAR(MAX) or XML on your insert command.

As I...

(deleted)

• This reply was modified 3 years, 1 month ago by kaj. Reason: wrong question answered!!!