Viewing 15 posts - 346 through 360 (of 13,879 total)
Comments posted to this topic are about the item GIT Configuration and Automated Release for Azure Data Factory, which is is not currently available on the site.
It's available to...
August 29, 2024 at 9:16 am
Drew's suggestion is the way forward. Here is an article which demonstrates the technique:
https://www.sqlservercentral.com/articles/the-output-clause-for-update-statements
August 28, 2024 at 2:17 pm
I ran into this issue using dbatools
WARNING: [09:31:34][Get-DbaDatabase] Failure | The certificate chain was issued by an authority that is not trusted
Set Trust Server Certificate to true to jump...
August 27, 2024 at 1:43 pm
thx phil, its tempting but then i have to wonder why the bogus pkg has no problems connecting to a different server from the vm using native.
True, I think...
August 27, 2024 at 12:58 pm
thx phil, its tempting but then i have to wonder why the bogus pkg has no problems connecting to a different server from the vm using native.
True, I think...
August 27, 2024 at 12:56 pm
When I connect to 2022 databases on an Azure VM, I use the MSOLEDB provider, because I had trouble connecting with Native Client. Maybe you could try that.
August 26, 2024 at 8:16 pm
When you say 'the catalog is there', what do you mean? SSISDB is the catalogue. The action of creating the catalog creates SSISDB.
August 21, 2024 at 3:54 pm
First of all you talk of having no Id or password, but then you all about updating a password. Which one is it?
August 20, 2024 at 7:11 pm
That is what I was suggesting. I also use SSISDB environment variables to override environment-specific items. But if the settings are the same regardless of environment (eg, the name of...
August 14, 2024 at 2:47 pm
Not quite what I asked, but good enough!
I'm wondering why the source of that message is 'Transact SQL Stored Procedure' and not from the connection manager, but I'm not sure...
August 14, 2024 at 2:18 pm
I tried that...
now I receive this error....
Invoke-Sqlcmd : Cannot open database "DB" requested by the login. The login failed. Login failed for user 'Domain\User'.
Seems like a reasonable error message...
August 14, 2024 at 10:12 am
Possibly because of this row:
and bk.backup_finish_date < getdate()- 1;" -ServerInstance "ABC" -Database "db"
Try changing it to
and bk.backup_finish_date < getdate()- 1;" -ServerInstance $ServerName -Database "db"
August 14, 2024 at 9:44 am
Out of interest, David, when hiring fresh out of college, did you filter depending on what they'd studied, or did you keep things completely open?
August 13, 2024 at 4:29 pm
Do you have the same version of SQL Server on your machine and on the server?
August 13, 2024 at 2:39 pm
Viewing 15 posts - 346 through 360 (of 13,879 total)