That's one of those movies that...

Instead of SSIS, google this:

sp_help_revlogin

The output from that will produce output to create the users.

This code will generate code to create the users and add them to...

How many actual users exist, and how are the permissions configured?

It seems as if generating a script to remove or disable users that exist in production, and the same for...

No Mimi, but while trying to explain to someone...

There are a couple things to think about.

One, are these jobs dependent upon the successful completion of the previous job? If Job 1 fails, does it go on...

In series:

Job 1

Step 1 = Run the code

Step 2 = EXEC msdb..sp_start_job @job_name = 'Job 2'

Job 2

Step 1 = Run the code

Step...

Actually, the way to collect the pot would be to call someone names, belittle their hard work, tell...

Grumpy DBA (2/4/2016)

---

Michael L John (2/4/2016)

---

GilaMonster (2/4/2016)

---

jasona.work (2/4/2016)

---

Man, there's a reply to one of my topics (which really already has been answered, although Gail raised an important point) by CELKO,...

GilaMonster (2/4/2016)

---

jasona.work (2/4/2016)

---

Man, there's a reply to one of my topics (which really already has been answered, although Gail raised an important point) by CELKO, and I can't read it...

The...

Stuart Davies (2/3/2016)

---

GilaMonster (2/3/2016)

---

jonathan.crawford (2/2/2016)

---

Now it's not a db design class, but still, we should at least be attempting to teach students rather than handicap them, right? They'll screw up...

Ed Wagner (2/1/2016)

---

jasona.work (2/1/2016)

---

Ed Wagner (2/1/2016)

---

jasona.work (2/1/2016)

---

Just read through the topic in question, sounded a bit to me as being more like "Please indicate that this may be OK as...

Grant Fritchey (1/27/2016)

---

Ed Wagner (1/27/2016)

---

Brandie Tarvin (1/27/2016)

---

Given that there are no instances, I assume there are other things that are not like normal servers.

How does the SAN features (if there...

Ed Wagner (1/23/2016)

---

Michael L John (1/23/2016)

---

Eirikur Eiriksson (1/23/2016)

---

Ed Wagner (1/23/2016)

---

Eirikur Eiriksson (1/23/2016)

---

Ed Wagner (1/23/2016)

---

jasona.work (1/22/2016)

---

So I just had an amusing moment...

I'm checking my servers for DBs that aren't TDE enabled...

Eirikur Eiriksson (1/23/2016)

---

Ed Wagner (1/23/2016)

---

Eirikur Eiriksson (1/23/2016)

---

Ed Wagner (1/23/2016)

---

jasona.work (1/22/2016)

---

So I just had an amusing moment...

I'm checking my servers for DBs that aren't TDE enabled and I come across a...

So, to understand, you have a varchar(50) column that contains values such as 8.00, "Bob", 01/01/2016, and so forth.

You want to only get the rows that contain dates contained in...