Viewing 15 posts - 2,446 through 2,460 (of 6,105 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?
January 6, 2006 at 7:18 am
Is MS DTC configured to run under Network Service on both servers?
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,...
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?
January 5, 2006 at 5:21 pm
Yes, you can. As a matter of fact, I have 'em both open right now.
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...
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,...
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...
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.
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...
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...
January 5, 2006 at 12:15 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...
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...
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...
January 4, 2006 at 10:53 am
Viewing 15 posts - 2,446 through 2,460 (of 6,105 total)