Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Activity for James Jenkinsâ€
Type | On... | Excerpt | Status | Date |
---|---|---|---|---|
Question | — |
SID to login for access via a group I have a query that returns the owner of jobs on an SQL instance, ``` select s.name as JobName , s.ownersid , ISNULL(L.name,'AccessViaGroup') as LoginName --Trying to figure out how to turn that into a name. from msdb..sysjobs s left join master.sys.syslogins L on s.ownersid = L.si... (more) |
— | over 3 years ago |
Answer | — |
A: Error: 18456, Severity: 14, State: 5; SSMS > Network sever from PC My team lead, pointed out the issue. As I could not find the issue/solution here, posting it for others. I knew I could not use windows authentication, so I was trying to use SQL Server Authentication, this was the problem. To access SSMS as a different user - When opening SSMS from your PC; S... (more) |
— | over 3 years ago |
Question | — |
Error: 18456, Severity: 14, State: 5; SSMS > Network sever from PC I just completed my first install of SQL as a server-based, Enterprise Edition. I wanted to check it out using SSMS on PC using my Admin Access. But could not connect. For security reasons my admin account and my Network ID on my PC are different, so I knew I would not be able to use 'windows ... (more) |
— | over 3 years ago |
Answer | — |
A: Multiple string concatenation in Excel In a new tab, type `A1` in cell `A1`, Type `A2` in Cell `A2` Use fill series to complete the values in column A Type `A1` in cell `B1` Use this formula in cell `B2` `=B1&","&A2` Copy the formula down. Copy and Paste Special, Values to harvest the string of values y... (more) |
— | over 3 years ago |
Question | — |
Multiple string concatenation in Excel In Excel I would like to concatenate several strings into one. I could type and fill in the blanks `CONCATENATE(A1, A2, ....)` but it is a lot of work This would be cool, but it does not work `CONCATENATE(A1:A255)` (more) |
— | over 3 years ago |
Answer | — |
A: Site scope - draft proposal I propose removing this from the off topic list > System/network/server administration. I am not an expert, but I believe a lot of this has software implications. For example, a SQL AlwaysOn cluster, is going to dependent on several areas of the points of all 3 of these items. For the per... (more) |
— | over 3 years ago |
Question | — |
Importing Selected Q&A? I personally have several (10s) of Q&A where I posted the question and\or answer, on related SE sites. These Q&A are ones I go back to for reference for myself and others. I know and understand that blindly bringing over tons of questions is not what this community is going to be built on. I am a... (more) |
— | over 3 years ago |