Viewing 15 posts - 1 through 15 (of 178 total)
Is the other instance running and not set to disabled start up mode when running the SP3 installer?
October 1, 2009 at 9:23 am
set the service start mode to manual or disabled under sql server configuration manager.
October 1, 2009 at 9:22 am
Interesting.. If restarting fixed it then I certainly wouldn't rebuild the perf counters 😛
Hope if doesn't reoccur, that could end up being a real intermittent pain..
October 1, 2009 at 9:01 am
I just ran this across all the servers I manager (from sql 2000 to 2008)
select (
select count(*) from master..sysprocesses where spid > 49) sysprocval,(
select cntr_value from master..sysperfinfo where counter_name =...
October 1, 2009 at 8:50 am
Did you try and search google on this???
You probably don't have named pipes enabled. Try connecting using TCPIP or enable named pipes.
September 15, 2009 at 9:54 am
After reading your post I was thinking how many times I go to this one database I "look after but don't manage" and find tonnes of views that are broken....
September 10, 2009 at 8:06 am
I've used this query before to pull service account & domain from the registry. Could work for you.
DECLARE @serviceaccount varchar(100)
DECLARE @domain varchar(1000)
EXECUTE master.dbo.xp_instance_regread
N'HKEY_LOCAL_MACHINE',
N'SYSTEM\CurrentControlSet\Services\TCPIP\Parameters',
N'Domain',
@domain OUTPUT,
N'no_output'
EXECUTE master.dbo.xp_instance_regread
N'HKEY_LOCAL_MACHINE',
N'SYSTEM\CurrentControlSet\Services\MSSQLSERVER',
N'ObjectName',
@ServiceAccount OUTPUT,
N'no_output'
SELECT @Serviceaccount, @domain, @@SERVERNAME
September 10, 2009 at 6:22 am
Did you try Google over the last week??....
search for this and click on the first link:
Retrieving the COM class factory for component with CLSID {B492C386-0195-11D2-89BA-00C04FB9898D} failed due to the following...
September 9, 2009 at 9:55 am
if you want to find out how unused space there is in a data file, just use dbcc showfilestats
1 Extent = 64KB
so the unused space (that you deleted)
(TotalExtents *64) -...
September 8, 2009 at 11:28 am
August 17, 2009 at 12:43 pm
I've never been able to get pivot to work for these types of situtations so I've resorted to dynamic SQL in the past. Here's a conversion of something similar...
August 17, 2009 at 12:33 pm
So rambilla being +5 hours, that would put the timezone at -6 (with DST)? Putting that server in Central time zone perhaps.
How long did the TL backup take to...
August 17, 2009 at 7:04 am
You also have to consider the time the jobs run and that 30 minute delay you have set.
Lets say you leave them all running every hour.
Your backup starts at 1:00,...
August 17, 2009 at 6:45 am
it's supposed to be UTC time (by design) I believe for consistency between servers in different timezones, etc. So I'd check the timezone on your server to start. ...
August 17, 2009 at 6:28 am
The database it's failing on isn't a snapshot, mirror or db running old compatibility level?
What sql version/edition/sp level?
August 14, 2009 at 11:50 am
Viewing 15 posts - 1 through 15 (of 178 total)