Viewing 15 posts - 2,446 through 2,460 (of 6,104 total)
Are all the computers trying to connect from the same network? From the machines that cannot connect to the SQL Server, are you able to ping it?
K. Brian Kelley
@kbriankelley
January 6, 2006 at 7:18 am
Is MS DTC configured to run under Network Service on both servers?
K. Brian Kelley
@kbriankelley
January 5, 2006 at 7:04 pm
In the case of Audit Logout, the duration is approximately how long (in ms) the connection had been open. In this case the connection had been open about 6447 seconds,...
K. Brian Kelley
@kbriankelley
January 5, 2006 at 7:01 pm
Has the BUILTIN\Administrators group been removed from being able to logon to the SQL Server? If so, do you have the full text search service installed?
K. Brian Kelley
@kbriankelley
January 5, 2006 at 5:21 pm
Yes, you can. As a matter of fact, I have 'em both open right now.
K. Brian Kelley
@kbriankelley
January 5, 2006 at 3:15 pm
I've got both sets of client tools installed, if that's what you mean. There are a few things to consider, like checking your path and deciding whether the SQL Server...
K. Brian Kelley
@kbriankelley
January 5, 2006 at 2:22 pm
Was there a previous install (canceled) or uninstall run since the last reboot? If so, that might explain the error. As for being able to do anything without the reboot,...
K. Brian Kelley
@kbriankelley
January 5, 2006 at 1:50 pm
I don't know if there is a reference or not, but I know Profiler doesn't work, either. You've got to use Profiler90, which comes with the SQL 2005 tools. Third...
K. Brian Kelley
@kbriankelley
January 5, 2006 at 1:41 pm
There's also a maximum "throughput" on INSERTs, but I forget what that number is. Far greater than what most of us see, though.
K. Brian Kelley
@kbriankelley
January 5, 2006 at 1:39 pm
I don't have the combo box issue, but I have had the viewing additional pages issue. What I typically do in these cases is scan the forum groups I normally...
K. Brian Kelley
@kbriankelley
January 5, 2006 at 12:22 pm
Pivot being primitive in 2005... I'd have to agree. Can't stick a subquery where you specify the columns for the PIVOT operator, meaning you have to hardcode them. That means...
K. Brian Kelley
@kbriankelley
January 5, 2006 at 12:15 pm
Can you post the exact error?
K. Brian Kelley
@kbriankelley
January 4, 2006 at 3:21 pm
SQL Server 2000 or SQL Server 2005? The reason I ask is there's a new PIVOT T-SQL command in SQL Server 2005.
If 2000, something like the following works (and I...
K. Brian Kelley
@kbriankelley
January 4, 2006 at 3:19 pm
Actually, the most expensive part is always maintenance. And this is where VMs can reduce cost. Case in point: you want to apply SP4 to your SQL Server. You've run...
K. Brian Kelley
@kbriankelley
January 4, 2006 at 10:58 am
Even some larger organizations have DBAs wearing all the hats. They may make a separation that says, "Because you were the DBA assigned to development in this project, you can't...
K. Brian Kelley
@kbriankelley
January 4, 2006 at 10:53 am
Viewing 15 posts - 2,446 through 2,460 (of 6,104 total)