Grant Fritchey (4/29/2016)

---

Brandie Tarvin (4/29/2016)

---

So a coworker attended a gender diversity workshop. She forwarded me the presentation with a slide that says women constitute 40% of database administrators, the highest...

So a coworker attended a gender diversity workshop. She forwarded me the presentation with a slide that says women constitute 40% of database administrators, the highest of any computer science...

No. I meant it as a play on VLDBs as in Very Small Databases. But that's an interesting link. Thanks for posting it.

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