Tricky, I failed to realize the synonym would be pointing to the view instead of the table that had been dropped.

Great question!

GilaMonster (6/19/2014)

On dev servers, I'm very happy to give developers db_owner of the DB they're working in, alter...

Great scripts, thanks a lot! I've added them to my personal library, with you as the source.

Great article, very useful for getting started with MDX.

Fun questions, thanks!

Be sure to spend at least one day doing nothing but fishing!

In that case, I'd temporarily give the login the access it needs to connect, then run a sql trace on the login and see everything it's touching. There must...

I can tell you based on my time working ExcelForum.com a few years ago the issue of people asking questions and then not acknowledging answers is certainly not unique to...

If the added field in the select list is not in the index, the query optimizer only has two options:

1. Look up the rows you need with the nonclustered index,...

Make sure the behavior of each job step is "Go to the next step".

I agree with SQLRNNR, and to test this you can add the extra field you are selecting to the current nonclustered index as an included field and see if that...

If it should be autoincremented, can it be the identity field? What is the...

I believe this would do the trick:

INSERT INTO table1

( SECTION )

SELECT SECTION

...

Rod at work (5/22/2014)

So you...

When you run the query, what kind of scan/seek is being done on dbo.cb? Is there an index that contains begindate?