Sorry

The size of my *.LDF is 2 Go with log space used 26% (DBCC SQLPERF(LOGSPACE))

log file 2Go

When I ran dbcc loginfo() on my database I got 8262 rows.

Thanks John, :w00t:

Case sensitive on database

Table name : tblAdmin_Audit_DBSize

Column name : DBName

Old script :

INSERT INTO tblAdmin_Audit_DbSize (dbname, db_size, unallocated, reserved, data, index_size, unused)

select db_name(), db_size, unallocated,

reserved = ltrim(str(reserved * d.low...

I have several database on my server. I use the script just to follow database size. The script doesn't work only on this database. I don't understand.

USE [THERIAQUE]

GO

/****** Object: Table [dbo].[tblAdmin_Audit_DBSize] Script Date: 12/15/2011 15:15:30 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[tblAdmin_Audit_DBSize](

[DBName] [varchar](25) NOT NULL,

[db_size] [varchar](25) NOT NULL,

[unallocated] [varchar](25) NOT...

I executed the following script :

Use theriaque

SELECT '['+SCHEMA_NAME(schema_id)+'].['+name+']'

AS SchemaTable

FROM sys.tables

Result : [dbo].[tblAdmin_Audit_DBSize]

schema name of my database ?

Thanks,

Eric

Ok so basically I have to check for all databases if dbi_dbccFlags = 2 before moving them to SQL 2008 R2.

I know but the only thing I need is if it's necessary to perform again a CHECKBD WITH PURITY after moving databases.

I checked but I saw nothing about that !!

Thx

Hello,

I'm not a expert but there something tricky because I didn't get the right execution time for jobs.

First I replaced "INSERT #jobs_status EXEC msdb.dbo.sp_help_job" by

"select sj.job_id, sj.name, sc.name...

Hi,

I tried to populate a temp table via INSERT #jobs_status EXEC msdb.dbo.sp_help_job

but I have the following message :

"Server: Msg 8164, Level 16, State 1, Procedure sp_get_composite_job_info, Line 67

An INSERT EXEC...