Here's a few of the new posts today on the forums. To see more, visit the forums.
|
SQL Server 2017 - Administration |
SSIS Proxy/Credential/Login question - I need a quick refresher on how the Proxy stuff hangs together. I know I created a Credential mapped to an AD account which has permissions to any file system resource I need to access in my packages. I know I then create a Proxy mapped to that Credential and grant the Proxy access to […] |
Timeout - System exception.Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at Source: .Net SqlClient Data Provider. Application team received the error. How can you troubleshoot? No information in error log or event log. We have default enabled but didn’t find any useful information from default […] |
Database backup sequence - Hi All, How the SQL server backup will work with scheduled job? What is the sequence it follows? What is the criteria it choose that it need to take this DB backup first, second .. like that? Is it possible before it complete the backup of the one database it will start another database backup? |
SQL Server 2016 - Administration |
Secondary database stuck in Not Synchronizing state - Hello experts, I am trying to restore a database that is part of an Always On availability group. As usual, I started by removing the database in question from its availability group. One secondary database properly went into the Restoring... state and I was able to delete it. For some reason, however, this time around […] |
SQL Server 2016 - Development and T-SQL |
Help with update on merge statement - Hello everyone, Needed to help with a merge statement. So based on what I've read about merge statements the syntax on this should be correct, but it's not. So my statement is below: merge dbo.qsr_store store using dbo.qsr_store_staging staging on store.id = staging.id and store.brand_code = staging.brand_code when matched then update set store.golive_date = staging.golive_date, […] |
Converting SSIS packages from SSIS catalog to File system in Job - Hello, I need some advise on how to convert SQL agent jobs run a SSIS package( SQL agent job has source as "SSIS catalog" and has a SSIS package as destination which is under path example.. SSISDB - Catalog -->Project and where you select specific package) Now, I want to change the SQL agent job […] |
Development - SQL Server 2014 |
Please help to get, Alphabet with underscore i.e special charecter - EMA_20210526T211254_0000_MRNMM0000001240_PMS110460PAT000001287_PID15235307_OR_Driver_Licensefrom.pdf In the above string, i would like to get as below like alphabet and '_', i tried to use the function fn_GetAlphabetsOnly but getting only alphabet. EMA_MRNMM_PMS_PID_OR_Driver_Licensefrom |
SQL Server 2019 - Administration |
query that will return the information of every table in a database - Hi, I'm seeking for a query that will return the information listed below for every table in a database. Any suggestions please. Thank you. |
SQL Server 2019 - Development |
How to setup Linked Server from SQL Server Express 2019 to Sage Line 50 - Hi there We have a Sage Line 50 Reports application located on one of our servers. This has been setup on our server as ODBC System DSN (Screenshots attached) Now Im trying to set up a linked server from this SageLine50 to SQL Server Express 2019 using the following programatically: EXEC sp_addlinkedserver @server='SageLine50Reports', @provider='SQLNCLI', @datasrc='ChrisSQL,1433', […] |
Count of word inside cell - Hello all, I am trying to find a query that bring me the count of the exactly word name: PageDefinition like on the example. Thanks a lot all and best regards, Gilad |
SSIS Web Service task SSL errors - I've tried different credentials, target server versions, etc. hitting our Primavera WSDL. Works great in any browser. Via the Web Service SSIS task, I get an error when running the package: Target Server 2016: --1. Connection manager "HTTP Connection Manager 1": SSL certificate response obtained from the server was not valid. Cannot process the request. […] |
Amazon AWS and other cloud vendors |
How to debug a StackSet? - We have a StackSet in our organisation that deploys config-central-logging. I wanted to change the regions this is deployed to and make sure it is deployed to new accounts. Any change I make to the StackSet is greeted with an error. Removing stacks fails, sometimes it says the OU is not part of the stackset […] |
General Cloud Computing Questions |
Please recommend me a cloud service based on description - I am working on an angular project and created a docker image for that.till now i only worked on the development side and never on full deployment side but I am willing to learn the process,can you please recommend me a cloud service where my docker container can be deployed with less/no fee charges as […] |
General |
SQL MAX of multiple columns? - How would you return 1 value per row of the max of several columns: TableName [Number, Date1, Date2, Date3, Cost] I need to return something like this: [Number, Most_Recent_Date, Cost] Can anyone help me out with this. Thanks in advance |
Powershell |
create file name with timezone CEST - Is there any easy script that will take current datetime and convert to CEST and account for DST also? I want to use that in my file name to help identify when process was ran. Thanks |