there is another parameter, @query_result_width, which i think is a default of 80 or 100, and anything wider wraps, which is what you are seeing

set it to a large number,...

just read and work through your errors; you seem to be changing stuff pretty quick to try and get it to work.

your latest error is just because you checked the...

the error message you pasted was

which would be an SMTP service exists, but is not available.

so the issue is not database mail, but...

the obvious fix is to set up a specific account for the SSRS account that does not password expire.

on my SSRS instances, all reports use shared data sources, so...

yes it could potentially cause problems. best practice would be to go ahead and schema-qualify all the scripts provided to avoid any issues.

The scenario i would worry about is if...

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