Lynn Pettis (4/29/2016)

---

Brandie Tarvin (4/29/2016)

---

Umm, that won't work. SSMS has the memory limitation. Not my desktop.

Per Microsoft:

Note SSMS is a 32-bit process. Therefore, it...

jasona.work (4/29/2016)

---

Grant Fritchey (4/29/2016)

---

Just a follow up on my other post (and apologies for bring tech & real work into the Thread, but you guys have the answers so I...

Okay. This is what I ended up with in order to make everything readable and easier to find the jobs I need to delete from the script. Also, I ran...

I have not counted. I have to pull them from several servers down to one or two scripts.

Umm, that won't work. SSMS has the memory limitation. Not my desktop.

Per Microsoft:

Note SSMS is a 32-bit process. Therefore, it is limited to 2...

Luis Cazares (4/29/2016)

---

Just to be sure, I like to use the quotename function.

SELECT 'IF EXISTS (SELECT 1 FROM msdb.dbo.sysjobs_view WHERE name = N' + QUOTENAME( name, '''') + ')

...

HA! Even SSMS agrees I have too many jobs. Using just a part of the code from Lowell's second link (to create the drop job stuff), I got

An error occurred...

Lowell (4/29/2016)

---

just the drops scripts are pretty easy, you can just build the statements from sysjobs;

select

'IF EXISTS (SELECT job_id FROM msdb.dbo.sysjobs_view WHERE name = N''' + name +...

So I had my dose of mild frustration followed up by a funny this morning.

A dev asked me to restore two Test 2012 databases down to SQL 2k8. As I'm...

I think I found what I needed. I will know when I've tested it.

From BOL on Integration Services job steps:

Use 32 bit runtime

Indicate whether to run the package...

Can someone help me with "hacking" the Script Job As Drop code?

I don't really want to hack MS's version so much as look at it and adapt it to my...

Eirikur Eiriksson (4/29/2016)

---

BLOB_EATER (4/29/2016)

---

GilaMonster (4/29/2016)

---

GilaMonster (4/27/2016)

---

BLOB_EATER (4/27/2016)

---

GilaMonster (4/26/2016)

---

BLOB_EATER (4/26/2016)

---

GilaMonster (4/26/2016)

---

SQLRNNR (4/26/2016)

---

The sith lord is Supreme Leader Snoke and suspected to be Darth Plagueis (the one that can create life from...

I hope you're not giving up because of what I said. The intent was not...

GilaMonster (4/29/2016)

---

GilaMonster (4/27/2016)

---

BLOB_EATER (4/27/2016)

---

GilaMonster (4/26/2016)

---

BLOB_EATER (4/26/2016)

---

GilaMonster (4/26/2016)

---

SQLRNNR (4/26/2016)

---

The sith lord is Supreme Leader Snoke and suspected to be Darth Plagueis (the one that can create life from death according to...

mbraman (4/28/2016)

---

So the total is 700 not 1400.

The data flow is - data in sql server goes to tabular model to tableau.

The "Field..." are filters in table.

So what...