I ended up using the standby db to refresh the production database and then sync'ed the 2 databases back together.

This request is no longer urgent and is solved.

Reports I deploy say that my account does not have enough permissions, and the Report Manager page is blank save for the title on the top.

Note that I have done...

I have been trying to solve this problem for many weeks. I have read books, scoured the web and posted many questions on many forums. I really need help with...

Ok, let me ask an even simpler question, can anyone who is using SQL Server Management Studio Express perform the steps as laid out in:

http://msdn.microsoft.com/en-us/library/aa337471.aspx

If so, does your UI...

Ok, I am still struggling with this issue and have been scouring the forums here. I think I have narrowed down what I think is the crucial issue. I need...

But after some further reading, Express Advanced does.

I'll respond in case others stumble on this old post.

Express does not support full text search.

Ah, I see now!

I also see that I need to study GROUP BY more thoroughly. Thank you all. Not only do I have the solution to my problem, I...

Ah, yes, of course, thank you. I did not expect that to work.

Am I to assume that by using MONTH(), that there is a type of layered aggregation so the...

Thank you for your double-whammy reply. I will chew on the CREATE code before posting more t-sql questions.

Concerning your query, it does offer some solution, but doesn't seem to...

So sorry, I did not realize that the T-SQL was so different between the Server and Access versions. If one was to desire the outcome I specified above, how would...

As an added bonus, I would like to better understand the code in the "best practices" link. How would I re-create what I posted with that code? If I knew...

I do apologize, I am working with sensitive data and must re-create the situation with test data. I would love to use the code in the "best practices" link, but...

Ho do you map existing Windows domain user and group accounts to predefined role definitions? I have been through many texts and the BOL and I have not been able...

I have, and the Admin can connect remotely.