Viewing 15 posts - 5,956 through 5,970 (of 19,564 total)
Koen Verbeeck (7/12/2012)
You have to make sure SQLNCLI10 is used, as SQLNCLI11 doesn't support connections to SQL Server 2000. Which provider did you choose in the Linked Server menu?
Koen, have...
July 13, 2012 at 7:21 pm
dan-572483 (7/13/2012)
If SQL is clustered it should be shut down in Cluster Manager only. If it is not clustered, I prefer to use SQL Server Configuration Manager.
I agree, in...
July 13, 2012 at 11:15 am
mbova407 (7/13/2012)
Rich Weissler (7/13/2012)
Presumably, if I were to load SQL 2008 R2 Data Center Edition on Windows Server 2012... it...
July 13, 2012 at 9:28 am
capn.hector (7/12/2012)
SQLRNNR (7/12/2012)
And since the old style cannot be easily deprecated, it's best just to teach the new ways imho.
untill you run into a production system using sql 7 because...
July 12, 2012 at 3:51 pm
GilaMonster (7/12/2012)
SQLRNNR (7/12/2012)
GilaMonster (7/12/2012)
@SQLFRNDZ (7/12/2012)
Ther must be an open transaction that is filling your log, DBCC opentran.If there was, log_reuse_wait_desc would have returned "Open Transaction", not nothing.
In most cases. ...
July 12, 2012 at 3:48 pm
GilaMonster (7/12/2012)
@SQLFRNDZ (7/12/2012)
Ther must be an open transaction that is filling your log, DBCC opentran.If there was, log_reuse_wait_desc would have returned "Open Transaction", not nothing.
In most cases. Though the...
July 12, 2012 at 3:25 pm
This one
Database master: IO is frozen for snapshot
or this one
Database MF20: IO is thawed
Those can be caused by any number of backup agents (such as Windows NT backup).
July 12, 2012 at 2:54 pm
And since the old style cannot be easily deprecated, it's best just to teach the new ways imho.
July 12, 2012 at 2:51 pm
I don't see an error in that log output. I must be missing it.
July 12, 2012 at 2:29 pm
Lynn Pettis (7/12/2012)
SQLRNNR (7/12/2012)
Never heard of them and would not put too much trust into sites that promote "real answers to real questions"
Don't we offer real answers to real questions?...
July 12, 2012 at 1:00 pm
CREATE TABLE #FileProp (dbid INT,FILE_ID INT, SpaceUsed DECIMAL(14,2));
GO
EXECUTE sp_msforeachdb 'USE [?]; Insert Into #FileProp (dbid,FILE_ID,SpaceUsed)
SELECT database_id,file_id,FILEPROPERTY(name,''SpaceUsed'') from sys.master_files where DB_NAME(database_id) = ''?'''
SELECT DB_NAME(database_id) AS DBName,physical_name,CONVERT(DECIMAL(14,2),size)/128 AS FileSize, growth
,CONVERT(DECIMAL(14,2),max_size)/128 AS...
July 12, 2012 at 12:57 pm
Never heard of them and would not put too much trust into sites that promote "real answers to real questions"
July 12, 2012 at 12:52 pm
Viewing 15 posts - 5,956 through 5,970 (of 19,564 total)