I'm with Jeff.

There some sort of secret that makes this work, or keeps it from working.

I took your code, and try to run it in every way...

Monitoring is kind of standard for most companies that provide this type of service. What would be good to focus on is the specifics of what they are monitoring,...

http://www.rdx.com/

Take a look at these folks

TomThomson (3/23/2016)

---

Me too. I have endorsements...

rcooper 78099 (3/23/2016)

---

I have an SSRS report that runs with out error. However

It has a parametier called "FundId" which is not linking to the

rest of the report it displays it...

rcooper 78099 (3/23/2016)

---

Update- I got the error fixed. Not entirely sure what it was. However I can tell you the @StartD and @EndD are correct. It is my mistake for...

True story.

We were desperate to do some hiring. We received hundreds of resumes. 8 of us were sitting around the conference table passing the resumes in...

Also, this code will probably not do what you think it it should be doing.

Where

pc.accountnbr Not In ('Null', '') And

pc.checknbr Not In ('Null', '') And

...

rcooper 78099 (3/22/2016)

---

Msg 156, Level 15, State 1, Line 15

Incorrect syntax near the keyword 'join'.

Michael L John (3/22/2016)

---

Select

pc.accountnbr 'account number',

qf.description 'Fund Name',

pc.checknbr 'Check Number',

p.fullname 'Pay Provider',

...

Select

pc.accountnbr 'account number',

qf.description 'Fund Name',

pc.checknbr 'Check Number',

p.fullname 'Pay Provider',

pc.amountpaid 'Amount Paid',

replace (pc.paydiscount,'-',''),

pc.advanceapplied 'Advance',

pc.checkamt 'Check AMT',

pc.checkprintdate As StartD,

pc.checkprintdate As EndD

from

paycheck...

Declare @var varchar(3)

SET @var = '22'

SET @QRY ='exec dbo.sp_policeTest' + @var

Don't you need space after the sp_policeTest"

SET @QRY ='exec dbo.sp_policeTest' + @var

@Qry is "EXEC dbo.sp_policeTest22"

SET @QRY ='exec dbo.sp_policeTest ' +...

Currently we have Skype for Business, Slack, Yammer, and email. Not to mention the ticket tracking system.

it certainly can, and does significantly at times, detract from productivity....

Is this failing through SSMS or an application?

It sounds as if the credentials being used to run the the application have been denied access to this schema.

Try...

It's probably not a good idea to create a permanent table in tempdb. This table will not be there the next time the server re-boots.

If you are creating...

Do you want to move space on a volume, or do you want to move the database from one drive to another?

If you want to move space on a volume,...