The Heap™ – Consultancy ©®

5:35 AM

Good ...

Andriy M

6:02 AM

... morning

6:22 AM

;-)

6:58 AM

morning

Andy K

7:20 AM

morning and evening

Any mods awake?

I vtc on this question DBCC job fails - Msg 1823, Msg 5123, Msg 7928 with the wrong DBA.SE article CheckDB Operation failing and returning error.

Should have been: SQL Server CREATE FILE encountered operating system error 5 (Access is denied.)

Can it be changed?

or alter-voted?

Jack Douglas

7:41 AM

@hot2use I've closed and reopened the post which has cleared your close vote

and tweaked your comment which we can leave, but I don't think you can vote again now

8:08 AM

@JackDouglas Thank you

Tom V

8:18 AM

@hot2use Couldn't you just retract your close vote?

ypercubeᵀᴹ

@hot2use are you sure it's a permission issue? (not doubting, just checking because my vote will close the q)

Tom V

@ypercubeᵀᴹ I don't think it's a dupe

it's a dupe in the sense that both are a permissions issue

but one is creating a database an d the new one is SQL Server auto-creating a snapshot when performing dbcc

I think the answer to the new question could do with some extra clarification as to why the file is being created

@ypercubeᵀᴹ I sure sounds like a permission issue with the second error message

the first question I added as VtC reason was related to a snapshot file being created, but that had a different error number.

As a combination of both questions, I thing the OP is trying to run the DBCC with a (proxy/other) account that doesn't have access to the drive where the file would be created.

So we could wait for clarifications.

@TomV Yes, possibly would have been easier in retrospect.

3 hours later…

dezso

11:58 AM

@McNets I was wondering where you did get the reference to the strange Hungarian habit of moving business days around from - then I checked the post history.

12:17 PM

Sorry @AndriyM, I missed the tags in that post. Thanks for the feedback in the comments.

Andriy M

No worries

12:31 PM

@hot2use I VtC'd that question as "unclear" since the OP states his belief that the problem is not permission related, yet he hasn't said anything at all about what he thinks the issue is, or why it's not permission related.

12:55 PM

@MaxVernon I‘m ok with that.

@dezso ;)

I'm having some issues with a windows 10 service, it does nothing else than start and stop, no code, on_start() simply write one entry in app event log, but it refuse to start due to: Error 1053: "The service did not respond in a timely fashion"

@McNets I'd bet it's not processing Window messages properly. I'll see if I can dig up something but generally, you need to ensure you return control to Windows within the service startup timeout parameter, which is typically 30 seconds.

^^^ I'm assuming you've written this service in my comment there.

if it's third-party, then something else is wrong.

1:15 PM

I write it. Usually it worked fine on Windows 8, but after installing Visual Studio 2017 on a new VM it refuses to start after 3 or 4 seconds. I write a new one this is on_start() method:

protected override void OnStart(string[] args)
{
RequestAdditionalTime(5000);

try
{
this.EventLog.WriteEntry("Service started.", EventLogEntryType.SuccessAudit);
}
catch (Exception ex)
{
this.EventLog.WriteEntry("CUSTOM ERROR: " + ex.Message, EventLogEntryType.Error);
}
}

@MaxVernon No more code.

No dependencies

so the app is not creating a thread and keeping it running. Windows sees this and reports that the service had a problem. Admittedly, it's been a while since I wrote service code ;-)

you should probably ask a question on Stack Overflow if you can stand the hand-grenades and mortar-fire.

@MaxVernon The service (original) doesn't use threads, it uses a System.Timer

Paul White

I hear SO is extremely patient and welcoming to all

@PaulWhite that's what I meant to say

Paul White

1:20 PM

@McNets which is almost the same thing as creating a thread. The timer object is a thread.

@MaxVernon ok, let me try with a simple thread.

@McNets maybe the thread can just do threading.thread.sleep(1) inside a loop. That way Windows won't think the service is freaking out.

(of course, that is VB syntax, so ymmv)

@PaulWhite it seems you get either no response at all, or you get 9 million downvotes and comments saying you're doing it wrong and you should be writing it in CoffeeScript or using Lambda expressions, or ....

Paul White

closed as a duplicate of "Should I Use JQuery?"

1:52 PM

@MaxVernon I've tried this: stackoverflow.com/a/4865893/3270427

same error

2 hours later…