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...

without reinventing the wheel?

it's much easier to add it:

it's in the zip...

DelimitedSplit8K is a TSQL function.

Find the article with the string splitter named DelimitedSplit8K here on SSC and download it;

it makes spitting things like this a lot easier.

once split, you just filter for items that...

here's the script i use to generate the CREATE VIEW scripts for all extended events on the server:;

it has a reference to master.dbo.DelimitedSplit, which is a version i made of...