Does the error message on login (or logged to the error log) hold any clues as to what may be going on?

Does the account have access to it's default database?

You can write a script to look at sys.partitions and then call the alter index command only on objects with more than 1000 rows. A better bet may be...

Is this SQL being compiled by an outside script? If it is we'll need to know what value is in $(runDate) when it's passed to SQL when you're having...

You may need to modify this to suit your purposes but here you go. This will get server level logins:

select [AccountName] = sp.name,

...

Are you looking to report on that or to create that?

Using a CTE may work for this if that's an option. Get the count in the CTE and the sum it in the main query. If you want...

Probably not an option here but there are contained DBs in SQL 2012.

Adam Machanic wrote a great proc for this. You can read about it on his blog where he did a whole month on monitoring:

http://sqlblog.com/blogs/adam_machanic/archive/2011/04/30/twenty-nine-days-of-activity-monitoring-a-month-of-activity-monitoring-part-30-of-30.aspx

I tried creating a synonym for the function but that requires the schema as well so no luck there. I think you're completely out of luck on this one.

I would contact the vendor about this. If it is their software that's causing it they'll know it better than we do and will be able to change it....

This does require a bit of a redesign, but why not keep the warehouse inventory levels in a different table? It probably shouldn't be in the same table as...

It's certainly not the most elegant solution but this will work:

SELECT

Product,

SUM(CASE

WHEN Warehouse = 1 THEN Sales

ELSE 0

END) AS SalesofWarehouse1,

SUM(CASE

WHEN Warehouse = 3 THEN Sales

ELSE 0

END) AS SalesofWarehouse3,

isnull((select top 1 Inventory...

You have no idea how tempted I was to say, "as long as the update isn't an update," but I didn't want to do anything that could confuse the explanation.

So you would argue that behavior on forums or other social media sites doesn't...