it depends on what you define as a duplicate; a few columns, or every column, including identities and CreatedDates?

also, is a duplicate in two databases, or must be in ALL...

I know the default is to search for a local windows user related to the server name;

You probably need to change toe location to to browse to find the...

mandavli (12/16/2016)

---

it is UNC path that I am using in the package,

with fail as I mean it's not able to find file, even if I have same proxy accounts...

mandavli (12/16/2016)

---

Thank you. Created the proxy and it worked on the native server (where the catalog exists)

But when I create a job on a different sql server. it fails, I...

did you already configure a credential and proxy operator in SQL Agent?

Did you configure that step to use that proxy operator?

the account that runs the SSIS jobs \is often a...

both examples were extremely helpful, folks, thank you!

I did it both ways as my proof of concept; I was already leaning towards Phil's example of a script task, but I've...

the key is to generate all possible combinations first..

Basically, you have to select from Your Calendar/Dates table,and cross join all possible employees, and then finally left join it to attendance.

WHERE...

what you are looking for is a Cartesian Product;

also known as a cross join

the syntax is pretty simple:

SELECT * FROM #Table1

CROSS JOIN #Table2

in the future, if you want the...

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