komal145 (12/8/2016)

---

hi All,

I have a package , where i get the results from a storedprocedure and send it to a file.

meaning OLED source ( sql command) ---> Flatfile.

Pacakge runs...

wow, I've heard of petty turf wars like this happening.

You've got to bring it all out in the open, with your DCD and all related supervisors; this is not the...

CELKO (12/6/2016)

---

Correct minor typos:

CREATE TABLE Forest

(node_name VARCHAR(20) NOT NULL PRIMARY KEY,

lft INTEGER NOT NULL CHECK (lft > 0),

rgt INTEGER NOT NULL CHECK (rgt > 1),

CHECK(lft < rgt));

INSERT INTO Forest

VALUES

('Root',1,8),

('first child...

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