so I'm assuming you want a soft fix to the issue, where you are detecting and maybe truncating in the trigger to make it no more than 200 characters, even...

nal4236 (12/3/2016)

---

Sounds like we're basically saying the same thing, we're just getting caught up in terminology. You cannot buy a single SQL Enterprise license that covers one single CPU core....

does that trigger actually work for a non-sysadmin?

looks like you are just logging offenders, and not denying their connection.

any login would need insert permissions on insert master.dbo.CheckLogins , is that...

put your code in a try catch, and explicitly bubble up any errors that might occur;

you'll get a better error description than you are currently receiving:

public void Main()

{

[highlight="#ffff11"]try

...

Appending strings together to make a filename is tricky; if you are not careful/consistent with ending slashes, you'll get invalid paths.

i would suggest using Path.combine to handle that issue...

If a Procedure calls another procedure INSIDE it's code, any #temp tables are available to it that exist in the procedure;

if the procedures are called consecutively, then the temp...

a quick google shows me enterprise licenses for SQL2016 are $7,128 per core, so MSRP would be select 7128.00 * 16 = $114,048.00

At the PASS conference Glenn Berry noted...

it's a combination of being on the same subnet, and that sql instances that have the SQL browser service running.

the ODBC drivers poll the network for advertised services.

you can...

you can download it from the catalog:

start a new project File>>New>>Project

make sure you choose Templates>>Business Intelligence>>Integration Services>> Integration Services Import Project Wizard.

there you can choose the server,a dn then the...

typically something like this is due to an automated process, combined with not a lot of available disk space.

the dmv's will not be any help, as they are really run...

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