Steve Jones - SSC Editor (3/22/2013)

---

You are right, I did. I was thinking row and misread that. I've seen RBAC mostly as row based, not role.

In terms of roles, there...

I think you...

Erin Ramsay (3/20/2013)

---

As a follow-up example.

I have a table, call it tableA, that contains 1 million rows on my publisher and uses 103 MEGs of data space.

tableA in the...

Is this problem resolved?....I am curious.

SueTons.

Thank you so much for all of your feedbacks.

SueTons.

Thanks Michael, appreciate it.

SueTons.

What are different ways you can call a batch file within an SP?

SueTons.

Eugene Elutin (3/20/2013)

---

Well, this SP should be pulling the job tables every 5 min or so and seeing if any are running longer than defined SLA for that job, so,...

Eugene Elutin (3/20/2013)

---

SQLCrazyCertified (3/20/2013)

---

Thanks Eugene, what you mean by not really good idea?....what...

Thanks Eugene, what you mean by not really good idea?....what are the alternatives,...

anoop.mig29 (3/19/2013)

---

Hi for last two days at one of our client side we have been trying figure out a why its taking two days two restore database backup files on...

anoop.mig29 (3/19/2013)

---

hi i know that shrinking data base increase fragmentation , so logically shrinking data files would two result in fragmentation but does shrinking log file increases fragmentation. i hope...

Thanks for your reply.

If I have to monitor the performance/timing of a particular SP, can I automate this? If so, how?

SueTons.

GilaMonster (3/15/2013)

---

Exactly what it says, all logical log files are in use, so there are no empty ones. No empty VLFs = no shrink.

Check log_reuse_wait_desc in sys.databases for why the...

Lynn Pettis (3/15/2013)

---

If the (or an) active VLF is at the end of the log file, the file will not shrink. All I can suggest is keep trying after...