Eric M Russell (12/4/2014)

---

I get the impression this is not commonly known, but a SQL Server authenticated user account, even a minimal user with nothing but default public permissions, can...

Ville-Pekka Vahteala (12/3/2014)

---

ScottPletcher (12/2/2014)

---

eric.notheisen (12/2/2014)

---

In our company sharing user passwords is a firing offense. As developers needing to troubleshoot user defined defects, we restore the production database to our...

jliu 81028 (12/3/2014)

---

Your number 3 option should work for me:

3) Ask to have the SQL Server client tools installed on your machine (including BIDS) and create the package yourself. Ask...

I...

psc032802 (12/3/2014)

---

I am not a DBA. Not a developer either. More of an end user of the data typically analyzing it.

I'm mostly interested in the data profile task...

jliu 81028 (12/3/2014)

---

i used to be able to use DTS to transfer data from source to destination in sql 2000. now we upgraded to sql 2008r2, my previlige is deprived....

BIDS is part of the...

jliu 81028 (12/3/2014)

---

i have a similiar question: i have SSMS 2008r2. Our database server has SSIS installed. I want to view the packages. Do i need to...

SQLRNNR (12/3/2014)

---

Jack Corbett (12/3/2014)

---

SQLRNNR (12/2/2014)

---

Chad Crawford (12/2/2014)

---

Stefan Krzywicki (12/2/2014)

---

How do you view the queries it generates? Are they persisted somewhere? Do you just see them through Perfmon?...

Brandie Tarvin (12/2/2014)

---

psc032802 (12/2/2014)

---

if the packages are to be run against a single database/server, then it would be best to install ssis on that same machine, correct?

then bids/ssis needs to...

psc032802 (12/2/2014)

---

if the packages are to be run against a single database/server, then it would be best to install ssis on that same machine, correct?

then bids/ssis needs to be installed...

Jack Corbett (12/2/2014)

---

We are all anti-RBAR, but I would bet at some point early in our careers we wrote RBAR code because we didn't know better, I know...

SQLRNNR (12/2/2014)

---

Brandie Tarvin (12/2/2014)

---

I feel for you, Gail. We're going 'round and 'round with our corporate tech department.

Us: We need a SQL Server 2012 deployment with X instances in this...

Ed Wagner (12/2/2014)

---

And reading that makes me want...

I feel for you, Gail. We're going 'round and 'round with our corporate tech department.

Us: We need a SQL Server 2012 deployment with X instances in this configuration, which is...