On which table is the column 'Active'?

For readability, please use IFCode formatting in future. Here is that code again:

SELECT

StationName

, AiredDateTime

, AiredISCI

, OrderNumber

, Line

, ...

What versions of SQL Server are you migrating from/to?

r5d4 (11/25/2016)

---

I’m running SSMS 2016 on the server itself via RDP.

When I open a script from the solution explorer or script a table as a SELECT, the query window opens...

A DACPAC is not something which can be edited directly, AFAIK.

Instead, you need...

Please give us some sample data and also show how you would like that data to be formatted.

The sample data should be in the form of INSERTs to a temporary...

reelnoncents (11/23/2016)

---

I assumed that may be questioned 🙂

What I mean is different data sets. So for example, let's say I have 5 "file types"...

1) Product Mix file

2) Sales file

3) Items...

Please describe what you mean by "file type".

jasona.work (11/23/2016)

---

Phil Parkin (11/23/2016)

---

chuck.forbes (11/23/2016)

---

The Network Team is still thinking that Automatic Windows Update was accidentally enabled on this server. Jeff, are you saying that even if that was the...

John Rowan (11/23/2016)

---

Guessing that the DTS.Runtime library is referencing the local SSIS instance. Not sure how you'd point that to another catalog. You may check the class properties...

pietlinden (11/23/2016)

---

Okay, this is getting pretty old. If you don't want to post some sample consumable data... a CREATE TABLE script and some INSERTs to populate the table(s), then I...

chuck.forbes (11/23/2016)

---

The Network Team is still thinking that Automatic Windows Update was accidentally enabled on this server. Jeff, are you saying that even if that was the case, only the...

davidvarga086 (11/23/2016)

---

Phil Parkin (11/23/2016)

---

davidvarga086 (11/23/2016)

---

Well I would like to know which one failed and why it failed. And maybe put that info in a table I guess.

And I might set...

davidvarga086 (11/23/2016)

---

Well I would like to know which one failed and why it failed. And maybe put that info in a table I guess.

And I might set up a mail...

davidvarga086 (11/23/2016)

---

Hi all,

I have hundreds of SPs and I was thinking that maybe I could do a SP that runs all of the other ones, instead of creating a separate...