dbcc opentran?

DBCC will generate a report for you whether having issue or not.

msdb.dbo.sysjobhistory

msdb.dbo.sysjobs

msdb.dob.sysjobschedules......

Besides the above, plus Network, Security.....

1. check INFORMATION_SCHEMA.TABLE_CONSTRAINTS for those having FK constraints.....

2. then, check sysobjects for those w/o FK.....

Hint: using LEFT JOIN.

*********************************

EDIT:

Actually, you can just query sysobjects.:D

Nnada Kumar (6/5/2006)

---

If you are using the wizard to restore the database one thing you need to make sure is changing the name of "Move to physical file name" under...

Nice article, Jeff.:D

By default, every one (in public role) can see it. But, not every one can query against it.

And, those INFORMATION_SCHEMAs are on BOL. So, what's your purpose of denying that...

I happened to have one: :w00t:

declare @temp table

(

Createdate varchar(10),

IDColumn smallint,

CustNumber int

)

-- INSERT DATA for testing

insert into @temp values('12/1/2005', 2, 100)

insert into @temp values('5/1/2007', 1, 100)

insert...

The users can SEE the INFORMATION_SCHEMA, but, they get DENIED when they query INFORMATION_SCHEMA if you deny SELECT on those SCHEMA.

Is there any difference in 2005 for sp_readerrorlog and xp_readerrorlog? (because I got the same result)

Service Pack DOES matter for SQL Server's health.

You'd better test the SP before you move on.

Besides the INDEX part,

(convert(VARCHAR(6), CombinedTT.StartTime, 112)= '{?Period}')

---- this one takes longer in WHERE clause.....

Better move the CONVERT into your SELECT...UNION ALL....part

Is there any error message for Log Reader?

I use profiler or system sprocs to trace those kinds of activities.:hehe: