Check the SQL service account permissions on the box that is working, versus the box that is not working?

http://msdn.microsoft.com/en-us/library/aa260689(SQL.80).aspx

When you grant execute permissions to users, the users can execute any...

mis-read post

TravisDBA (3/23/2010)

---

If you look on the Internet you can still find Braindumps that allow you to memorize these tests, and as long as they are available out there people are...

I like the idea of stepping stones in certifications. Maybe not steps up to MCM but somewhere half-way-there maybe. A cert with SQL Server that requires proof of...

Cluster Admin is built-in management console of Window Servers, it cannot be "removed". If you run the uninstall of SQL Server you should have an option to remove Desktop...

Quick note...I would take that email reference out of your post. Don't think you want alot of people emailing your phone all of the sudden 😀

Microsoft Press book was pretty good, but I also used the ExamCram book as well. It read very well and included 30-day access to MeasureUp.com practice test that are very...

I'm curious too GSquared...

http://www.sqlservercentral.com/Forums/FindPost883675.aspx

The other post seems to be with the same Access DB. I wold love to see what Mr. Bullhat's house looks like on 44 Egg Rd.:w00t:...

I would agree, if you are not the developer that uses the database, you may not understand why that 1 index is there and is only used every 3 months.

Brent...

asir83 (3/10/2010)

---

Hi,

I have some steps, but those are in vague format, I only know that I need to get the master DB on 2005 instance to single user mode from...

Create a maintenance plan within SSMS is your quickest way of doing it. It will allow you to select All user databases or those that you want to run...

This SCC post seems to follow along the same error you are having.

Active Directory Query

I don't mess with linked servers to AD much, but quick view of the post above...

The issue is probably with LiteSpeed. I would query their knowledge base.

Is the SQL Service account for 2005 using the same account as the 2000 instance? If not does the 2005 account have domain rights to that OU you are...

duplicate: http://www.sqlservercentral.com/Forums/Topic879475-145-1.aspx