Posting this in case it ends up helping someone else.

Client requested in-place upgrade of SQL 2012 to 2019.  Upgrade ran flawlessly.  Ran CU24 update, update had no problems until the...

Have you checked the NTFS permissions (not just the share permissions) for the folder you want to check?

Mark

Lawrence-136504 (3/18/2010)

---

Yes. I was manually starting this job so there was no schedule.

I created a schedule that runs every 1 minute. This job has one step that has WAITFOR DELAY...

Lawrence-136504 (3/18/2010)

---

I re-copied the logic and then pasted it into ssms (query window) and removed some hidden characters and I'm getting below error now.

EXEC [master].dbo.xp_sqlagent_enum_jobs 1, 'DomainName\lawrence', 'B508F33F-8C69-42B9-9635-4CA66C05548D'

Msg 241, Level...

Lawrence:

I have this...

Date/time calculations can be a pain, especially if the components are stored as INT's, VARCHAR, etc. The below code will take (presumably an INT representation of time), CAST it...

mbrady, I am a visual learner 😛

Could you post a quick CREATE/INSERT script with some dummy data and the results you expect to see? Most likely the issue is...

meichner (10/9/2009)

---

Option #1 - Question

The problem with this option is that everytime a new table is created that depends on the Customer table, I would need to change this stored...

I should remark that I did this on SQL 2008 EE. SPARSE columns types are new in that version...try comenting out that column or running a profiler session on...

Thanks, Jeff - good catch. Depending on your specific requirements, you can also look into using the CAST function on the dividend to get the specificity needed (e.g. NUMERIC(19,5),...

Yes sir, it does 😀

Here is what the SSMS UI uses to generate the...

Yes, trust him ^^. Usually if there's any kind of purge occuring in a system (an actual DELETE, especially for customer data) I...

Here's the (anonymized) script I use to set up Database Mail on all new SQL installations. Please change the variables to ones appropriate for your environment.

MJM

--******************************************************************************************

--Purpose : The purpose...

Try this...the two additional columns I added are set apart with a carriage return before and after.

SELECT [CWS Division],

[Zone],

...

That depends on your definition of "Restored Completely". If you can access the database (period), then your database is recovered. Could you give us some details on the...