You mean where I have it in the script(s) I am trying to call, listed as:

USE [CarePro_MSCRM];

GO

I should have mentioned that I tried changing that 6 different ways, but the...

Just as a final note for this Stored Procedure...Both Sachin Nandanwar and mister.magoo's advice worked here (the original advice that I thought didn't work actually did end up working once...

mister.magoo - Thank you! That finally got it!

I will also look into how I can rewrite this with SQL Injection attacks in mind, and see if I cannot go...

Have now tried adding a GROUP BY 'Column' WITH ROLLUP, but still same error...

IF @Count = 1 -- when only 1 row, no need to...

This is another approach I am looking at, but I am not having much success calling it from the sp_SOS SP.

https://sql2012computeby.codeplex.com/

Reviving this thread in the hope of finding a solution. I have used a Stored Procedure by Richard Ding for the past few years called sp_SOS. It works...

That's actually good to know. I have been evaluating our performance gains using Data Compression in a test environment, for a while now, and was under the impression that...

Grant, thank you for that confirmation. I know it probably sounds very neophyte, but I wasn't able to find anything to fully confirm this (I am working on a...

Now I just get the same error with the word 'matching' correctly spelled. That is just the literal string that SQL calls if it does not find matching records.

Sachin - thank you for starting things out here with this logic. I appreciate it! I am still getting compile errors (though it will make the Stored Procedure...

Hi homebrew01 -

The reason I need to delete them is they are taking up a massive amount of space, and I literally have thousands of indexes on this database...

Hi guys -

Yes - it's Microsoft's CRM (sorry for the assumption that you knew what I was asking about). Specifically - CRM 2011.

I know that SharePoint...

Hi Sean - Not sure what you mean by Vendor. As best I know it's Microsoft's product still, but do you perhaps mean reseller?

We do not deal with our...

It looks as though the encryption of the database somehow became corrupted in the 2008 R2 install. Luckily we made backups of the Master Key before the user really...

It saddens me to see someone whom I respect so much (Gail is like a mentor to us all) be so blown off by a company that owes her more...