dndaughtery (12/13/2016)

---

Hey guys, I'm using an execute process task to unzip a password protected zip file. I'm able to unzip and create the file in the target folder but it...

I think it's a column descriptor in master.sys.procedures;

I've confirmed that my proc, which sets specific trace flags, shows up in my results:

SELECT *

FROM master.sys.procedures

WHERE [procedures].[is_auto_executed]...

i believe it's suffering from the classic error: recovery mode is FULL recovery, someone took at least one full backup, and no one has ever run a log backup, nor...

pretty sure standard edition featureing multiple Basic Availability Group is supported, and if you have multiple databases, that kind of forces you into having to design one db per group.

...

I got my SQL2012/2014 MCSA in May 2016, which was probably a month before SQL2016 RTM came out.

The official books for the three new SQL 2016 MCSA come...

row_number featuring partition by will do what you are asking;

here's an old example, but you can see you get all the other values but it's logically grouped by the...

jbalbo (12/8/2016)

---

Thanks for the quick response and sorry for the lack of explanation on my part!!

I am using a Bulk insert via a txt file and...

yes, but you need a case statement to bulletproof the calculation for data shorter than your assumption.

CREATE TABLE EXAMPLE (

ExampleId int IDENTITY(1,1) NOT NULL PRIMARY KEY,

MyColumn varchar(30)

)

INSERT INTO EXAMPLE(MyColumn)

VALUES( ''),('1234567890')

ALTER...

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