i'd say look at the SQL server error log first. see exactly what time, and what errors occurred. the error might point to something obvious.

compare that to your job schedules;...

great job on providing the set up!

i'm a little unclear on what the rule is for the gracemarks, though;

if they have a Practical_mark > 30, they get get a 70...

darn i missed this one.

day late, dollar short.

duplicate post.

no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts" link shows us everything.

continue the thread here:

http://www.sqlservercentral.com/Forums/Topic1838607-360-1.aspx...

A Calendar Table is really handy for this.

As an Inline calculation

the way i would tackle it is with DateMath, and a case statement that checks for Saturday or Sunday

here i...

Thomas makes a good paint on the procedures being the way the GUI makes job changes; that means besides triggers, you could also modify the procedures themselves so that they...

i think job changes are actually DML changes, and not DDL changes; those are insert/update/delete to the tables in msdb: dbo.sysjobs, dbo.sysjobsteps and dbo.sysjobschedules for example.

you could put DML triggers...

you need a master list of all employees to compare against;

then you can use an EXCEPT operator and your existing code

I would stick your results in a temp table,...

tocy1980 (11/18/2016)

---

I have tried this:

and it doesn't work.

Get this error: he multi-part identifier "Linked Servers.DATA STORE LINKED.'ET NEW$'.Parts Used" could not...

yes you can.

I think in 2012, you had to hand script everything, right?

i used the 2016 GUI, which shows the GUI filtering criteria , and then scripte dit;

hope this helps!

CREATE...

i googled a bit to find reasons SSMS is slow sometimes;

i see SSMS can sometimes validate some .net packages;

https://www.virtualobjectives.com.au/sqlserver/ssms_slow.htm

this one implies a few basics: virus scanners, the default connection type...

I bet it's a cache in VS.

visual studio creates a local *.data file with cached data so that it doesn't have to go back and forth to the server a...

maybe the databases they are creating have large space assignments?

i know if you have not set up instant file initialization, you can see some delays, right?

https://blogs.msdn.microsoft.com/sql_pfe_blog/2009/12/22/how-and-why-to-enable-instant-file-initialization/

glad you've got it sorted out.

I have to use both in my environment;

we have some tunnels to another domain where the AD accounts are not trusted, so I've got to...

ElementZero (11/21/2016)

---

I don't see where it says that you may use Windows Authentication only...? In fact on the "Create a Registered Server" Page it even says you can use...