A good article:

http://www.sqldts.com/default.aspx?234

Object_ID not indicative of order of creation (sorry I changed names, but you might get the gist):-

SET NOCOUNT ON

DECLARE

  @Objects INT

 ,@Built INT

 ,@CurrentObject INT

 ,@LastUnbuiltObject INT

 ,@Build CHAR(1)

IF OBJECT_ID('Tempdb.dbo.#Objects') IS NOT NULL

 DROP TABLE...

This should give you your problem entries in Notes:

SELECT

 n.Customer_ID

FROM

 Notes n

LEFT JOIN Customer c

 ON n.Customer_Id = c.Customer_Id

WHERE

 c.Customer_Id IS NULL

Ok, in msdb we have dbo.sysjobs (not sys.jobs) but we do not have sys.jobactivity (nor dbo.sysjobactivity). Can you explain where this is located. It sounds like it has the information...

Sounds like your ODBC driver is not accessed through a system DSN. If you have access to your ODBC Data Source Administrator (Admin Tools), set the DSN as a System DSN...

Duh!

Can everyone ignore this as I find the answer lies with Dynamic Properties Task. Thanks for looking.

I pass exactly the same parameter values in the debugger.

Also, if I try in QA

DECLARE @strMessage varchar(255), @strResult varchar(2)

EXEC @strResult = dbo.upCheckSessionExists 2, '30 xxx 2004', @strMessage OUTPUT -- Date...

Try entering RSExecutionLog in Google or just go direct to here:-http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_rslogfiles_v1_88gy.asp

This is a tool that comes with Reporting Services, which basically provides various reports on itself. Very good indeed.

Sorry, result of DBCC CHECKDB was:-

CHECKDB found 0 allocation errors and 0 consistency errors in database.

I have SP3 installed. Looking at the knowledgebase article, I think the problem fix is for data modification in tables with indexed views on them. My problem is purely a...

Yes, it's better to have data residing in cache, but when we need to read/write.....

I guess ultimately it comes down to how often and in what size chunks the dB...

Can only give you the pass mark for 070-228, can't remember how many questions there were for sure, but the pass mark is 755 (out of 1000). Hope this helps.

For what it's worth, just throw this one in - I have just installed RC 2 of .NET Server Enterprise Edition, and although it isn't production, I have developer edition...