| 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? |
| ERROR: Could not find a login matching the name provided - Okay. This is an odd one that I can't quite figure out. I hope someone can advise. A user was having issues logging into a server with a new AD account. One of my coworkers verified the login was part of windows groups which had access to the server. For kicks and giggles, I added […] |
| SQL Server 2016 - Development and T-SQL |
| 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 […] |
| How to Refactor Code with CTE - Hello Community, Can someone show me how to refactor the following code with CTE's? My platform doesn't support CTE's WITH CTE1 AS ( SELECT *, ROW_NUMBER() OVER (ORDER BY ts_primarysecondaryfocus)RowNum FROM [dataverse_montagu_org5a2bcccf].[dbo].[account] ),CTE2 AS ( SELECT *, ROW_NUMBER() OVER (ORDER BY ts_primarysecondaryfocus)RowNum FROM [dbo].[OptionsetMetadata] ) SELECT C1.Id,C1.SinkCreatedOn,C1.SinkModifiedOn,C1.statecode,C1.statuscode, CASE WHEN ISNULL(CAST(C1.ts_primarysecondaryfocus AS VARCHAR(50)),'') <> ISNULL(CAST(C2.ts_primarysecondaryfocus AS VARCHAR(50)),'') THEN CAST(C2.ts_primarysecondaryfocus AS VARCHAR(50)) ELSE CAST(C1.ts_primarysecondaryfocus AS VARCHAR(50)) END AS ts_primarysecondaryfocus ,C1.customertypecode,C1.address1_addresstypecode,C1.accountclassificationcode,C1.ts_easeofworking ,CASE WHEN ISNULL(CAST(C1.ts_ukrow AS VARCHAR(50)),'') <> ISNULL(CAST(C2.ts_ukrow AS VARCHAR(50)),'') THEN CAST(C2.ts_ukrow AS VARCHAR(50)) ELSE CAST(C1.ts_ukrow AS VARCHAR(50)) END AS ts_ukrow FROM CTE1 C1 LEFT JOIN CTE2 C2 ON C1.RowNum = C2.RowNum Thank you |
| 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 […] |
| XML |
| Parsing a lange XML data-column from one server to another - Dear PS-scripters. As a newbee I encouter the next challange.... I have a PS script that needs to copy data from server A (table VV) to server B (table VV). One of the columns is an XML column. Now I run: Invoke-Sqlcmd -ServerInstance $DestServer -Database $DestDatabase -MaxBinaryLength 204850000 -Query $InsertQuery The $InsertQuery holds just one […] |
| 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 |
