Viewing 15 posts - 1,561 through 1,575 (of 6,105 total)
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.
October 24, 2007 at 8:10 pm
Nisha N.Kumar (10/24/2007)
I had undergone training for some months but have never worked on live projects.
But they have put me in a project...
October 24, 2007 at 8:07 pm
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...
October 24, 2007 at 7:59 pm
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...
October 24, 2007 at 7:55 pm
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...
October 24, 2007 at 6:48 pm
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...
October 24, 2007 at 6:41 pm
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...
October 24, 2007 at 6:14 pm
Kenneth Fisher (10/24/2007)
One really nice feature of SQL Profiler 2005 is that it will let you export the script trace definition to a script for SQL 2000 or 2005.
This can...
October 24, 2007 at 6:12 pm
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...
October 24, 2007 at 6:09 pm
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...
October 24, 2007 at 6:07 pm
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,...
October 24, 2007 at 5:51 pm
Hi Robert,
have you tried querying sys.dm_os_waiting_tasks to see what the wait types are for the SPIDs?
October 24, 2007 at 5:48 pm
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...
October 24, 2007 at 5:37 pm
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...
October 24, 2007 at 5:32 pm
For those looking how to change this, in SQL Server Management Studio:
Tools | Options | Scripting
October 24, 2007 at 5:29 pm
Viewing 15 posts - 1,561 through 1,575 (of 6,105 total)