Take apart sp_helprevlogin to understand how it is extracting the password. Use that to update the password on the second server if the password has changed.

Nisha N.Kumar (10/24/2007)

---

Yes I am fresher just out of college.

I had undergone training for some months but have never worked on live projects.

But they have put me in a project...

Start SQL Server Management Studio with an alternate set of credentials. There are two ways of doing this:

1) Hold down the shift key and right-click on the icon. Choose the...

It's a tool. Unless there is a training impact, let them have the tool. From a security perspective, trying to keep them from using that tool means they'll go and...

SSRS's backend databases are a killer on disk I/O in general, so I am not surprised by this. A lot has to do with how the reports are...

For SQL Server Management Studio, do a search on Amazon.com for Dale Elizabeth Corey. She wrote a book on SSMS that used to be distributed via SSC. I don't know...

It might help you to spend a bit of time researching how mail servers like Exchange do threading. That'll give you a running start on designing your own system. There...

This can...

As you might expect, both consume resources. And it depends on how heavily both will be used. With respect to Reporting Services, however, the reporting services databases can generate a...

If you install SQL Server 2000 from one of the nodes, you can install a SQL Server 2005 instance to it.

Make sure you have your domain groups created ahead of...

If you're using SQL Server 2005, you should get away from using the sysusers table and other system objects from SQL Server 2000 as they are deprecated. In some cases,...

Hi Robert,

have you tried querying sys.dm_os_waiting_tasks to see what the wait types are for the SPIDs?

I don't know about modifying Reporting Services itself, but it should be fairly easy to do this with a .NET (or even ASP) page that gets the user's credentials and...

In doing a Google search, I saw some reports of this happening on several forums and blogs when the database and server collations don't match up. Could that be the...

For those looking how to change this, in SQL Server Management Studio:

Tools | Options | Scripting