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 |
|---|---|---|---|---|
| Edit | Post #278771 |
Post edited: |
— | about 4 years ago |
| Edit | Post #278771 | Initial revision | — | about 4 years ago |
| 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) |
— | about 4 years ago |
| Edit | Post #277416 | Initial revision | — | about 4 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) |
— | about 4 years ago |
| Edit | Post #277415 | Initial revision | — | about 4 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) |
— | about 4 years ago |
| Edit | Post #277261 |
Post edited: |
— | over 4 years ago |
| Edit | Post #277261 |
Post edited: |
— | over 4 years ago |
| Edit | Post #277261 |
Post edited: |
— | over 4 years ago |
| Edit | Post #277261 | Initial revision | — | over 4 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 4 years ago |
| Edit | Post #277259 | Initial revision | — | over 4 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 4 years ago |
| Comment | Post #277249 |
+1 Also I think the last paragraph beginning **"This is an "everything programming" site because that is what it was founded as."** should be bold.
(more) |
— | over 4 years ago |
| Comment | Post #277235 |
@lundin, so things that would be in scope at https://superuser.com/ ? (more) |
— | over 4 years ago |
| Comment | Post #277243 |
@Lundin probably because they have a separate site for those questions [Server Fault ](https://serverfault.com/help/on-topic). They have many nitch sites, like for android which I believe would all be in scope here. (more) |
— | over 4 years ago |
| Edit | Post #277243 | Initial revision | — | over 4 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 4 years ago |
| Comment | Post #277235 |
Can you clarify "The use of computers or software for other purposes than software engineering."? Is this like hardware questions? (more) |
— | over 4 years ago |
| Edit | Post #277199 | Initial revision | — | over 4 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 4 years ago |