Lynn Pettis (9/13/2016)

---

So a coworker HipChats me saying he needs some advice. Here is his question:

i have a stored procedure but the initial table is about 10million records, what...

rkelly58 (9/13/2016)

---

Thanks Lowell, that worked.

I didn't need to add the userid or password, I just added the path to the file like u said and scheduled it.

tested and works...

jasona.work (9/13/2016)

---

I suspect the batch file is most likely working (the Task Scheduler when calling a batch file will run it, even if you don't see the CMD window) and...

I suspect the batch file is most likely working (the Task Scheduler when calling a batch file will run it, even if you don't see the CMD window) and instead...

Presuming you've got the Task set to use your login / password for the task, it should run as you and work.

As it's not, I'd likely try combining kreuzer and...

What a way to return from a weekend...

We've got a vendor who's coming out tomorrow (despite our trying to push them back to have more prep time) to install an...

Inconceivable!!

:hehe:

So, if you've got a slow database and you know it's a disk issue and the boss wants it fixed yesterday and he wants it to blaze along for some...

You can also try using a couple of the DMVs to determine the IP address of the originating server, then work with your network team to find the computer name.

The...

RonKyle (8/29/2016)

---

Actually, I wouldn't have said that. I agree that is a downside...

RonKyle (8/29/2016)

---

RonKyle (8/29/2016)

Don't the service accounts make this issue moot? I think they came about in 2012. I've used them in a couple of SQL 2014 setups now. They don't...

RonKyle (8/29/2016)

---

Don't the service accounts make this issue moot? I think they came about in 2012. I've used them in a couple of SQL 2014 setups now. ...

/Me raises...

GilaMonster (8/29/2016)

---

Brandie Tarvin (8/29/2016)

---

And giving people a list of subjects to study would help them to get to know the material, because it's more than just memorizing an answer....

So much *fun* working someplace where you have a (virtual) server in an environment where every GB of storage, every GB of RAM has to be accounted for and justified...