Asteroids

murthyvs (1/6/2016)

---

Think its my error. I was selecting db_datareader, db_datawriter, db_ddladmin under Owned Schemas section. I selected the same ones in Membership and its working as expected now. Thanks for...

Ray Herring (1/6/2016)

---

I am sorry that I fall short of your expectations and apologize for not meeting your standards.

I will of course, bow to your superior knowledge and refrain from...

george sibbald (1/6/2016)

---

allamiro (1/6/2016)

---

Never use maintenance plans for reindexing -

I was wondering why ? if the option is there and we have one database why maintenance plan wont suffice for...

Ray Herring (1/6/2016)

---

What's your point? The Original post still pops up in searches and is still valid.

I realize the first reply "solved"...

Hugo Kornelis (1/6/2016)

---

The statement "doesn't work or doesn't work well" is invalid.

But if you ask which is better, then my guess is that 99% of the experts will point you...

I thought I clicked the right answer, but I guess I'm not caffeinated enough yet.

Ken

ramana3327 (1/5/2016)

---

I started job manually it is showing like running but from job activity monitor not able to see the job and even from sysjobactivity

So I again click on start...

benjamin.reyes (1/5/2016)

---

This is the nifty old utility talked about in this article.

http://www.sqlservercentral.com/blogs/chadmiller/2010/05/15/sql-agent-visual-job-schedule-viewer/

It seems the company and the website no longer exist. Through replacement of several desktops I seem...

Sergiy (1/5/2016)

---

You do not need all those CTE's.

This simple query will do:

DECLARE @PartID_List VARCHAR(8000)

SET @PartID_List = '1,2,3,4,5,6,7,8,9,10,11,12'

SELECT pl.partDisplayName, pl.testerName, ce.testerId, partId as testId, 0 as resultCount, 'no implementation' as testStatus

FROM...

Check out http://www.sqlservercentral.com/Forums/Topic1160922-1550-7.aspx. Jeff posted his presentation he did at a SQL Saturday...

ramana3327 (1/5/2016)

---

Hi,

We are using standard edition.

When I execute a job manually and try to see the job running status from job activity monitor, I can't see anything.

Can we see the...

murthyvs (1/5/2016)

---

Thanks for your reply. Tried it but wont work. May be few more things needed? Please see below for my steps.

Steps:

0. Logged in as windows user (admin)

1. Create a...

sartis (1/5/2016)

---

Ed Wagner (1/5/2016)

---

sartis (1/5/2016)

---

Thanks MMartin1 and sean, I plugged this into SQl Server management studio and it appears to be kicking back results in the correct manner. Sorry for...