kevin77 (6/5/2010)

Does anyone have any suggestions or comments? Either on my example scenario or why the database isn't smart enough to acquire the locks that it needs all at...

Well with a little bit of math calculations you get the explanation.

...first the output from my instance of the master database...

Your state if the upgrade installation fails = screwed.

I've watched someone try an in-place upgrade and the installation failed for various reasons (mostly due to permissions not being...

What is your definition of "hung status"? Viewing sp_who2 will show you what processes are running, be it a SQL Agent job or otherwise. You will also see...

http://msdn.microsoft.com/en-us/library/ms188283(SQL.90).aspx

Make sure you understand that these roles are concentric in relation to one another. Meaning the higher roles automatically gain access to the permissions of the lower roles. If...

http://msdn.microsoft.com/en-us/library/ms187658(v=SQL.90).aspx

You must be a part of sysadmin fixed-server role.

*OR*

You can try to give the account SQLAgentReaderRole, SQLAgentUserRole, or SQLAgentOperatorRole fixed database role, but this path will give the account access...

My instance was not with mirrors but in a cluster environment where I continually got "Login failed for user '', with no user being listed.

Round about way I came across...

Bug got reported to Microsoft back in December 2008, although Microsoft did not post a response until April 2009.

https://connect.microsoft.com/SQLServer/feedback/details/387616/tables-node-does-not-show-all-schemas-in-ssmse-2008

It states the INNER JOIN is the issue, as Peter and Paul...

The example you gave is pretty close to what you need, you just need to figure out how to JOIN the tables together.

Truthfully, I don't know that you are going...

This guy seems to be having the same issue 😉

Have you tried the response from Geoff (aka SQLCraftsman)

You can also check here: Microsoft SQL Server Release Services[/url]

They post on the blog when cumulative updates are being released for SQL Server 2005/2008. So you will probably here about...

Fine, but what my past experience suggests me that the product, which in turns is the finite definite Data Base, can be managed well and optimized by the team designated...

Level 4: Expert

"Sought out by others for guidance in this area"

This sounds like the commercial were people called in to describe what they just saw, the person on the line...

WOW!!! They actually have Interview questions too:w00t:

Something new to reply to post for those looking for SQL interview questions.

Use GMAIL. you will just need to create an account. Their outgoing server requires user authentication so you'll need the account. You can forward to any email...