I had to take the 431 twice too. What I found the most useful in preperation was going through the labs in the Microsoft Press book. The simulations took me...

OK, this is a first for me, I was able to answer my own post 😛

LEFT(Reference, LEN(Reference) - PATINDEX('%[.]%', REVERSE(Reference)))

Unless, of course, someone points out where this goes wrong. Haven't...

It happens when the file has no space left.

Fom BOL:

"Select or display the autogrowth properties for the file, which control how the file expands when its maximum file size is...

So I don't know why, but I know a what now. Reporting Service didn't upgrade and still shows up as version 8.0.1038.00. When trying to install additional components I get...

Thanks, that clears it up.

Tim

Found it!

Lynn, the path to those text files is C:\Program Files\Microsoft SQL Server\MSSQL\LOG and this is where I found the problem. Thanks!

The error is with the name of the database....

Thanks, I'll look around for that txt file.

I placed the database in single user mode and tried running the maint plan again, but still got the same error.

Tim

I think some of that got cut off. Here it is again.

Executed as user: [domain\user]. ... 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. ...

Here is the "Full" text from the Job History Log. Unfortunately there are quite a few "..." spots.

Date3/10/2008 1:39:12 PM

LogJob History (User Databases.Daily Transaction)

Step ID1

Server

Job NameUser Databases.Daily Transaction

Step NameDaily...

Jack, I ran the TSQL command backup of the database and also scheduled it as a SQL Agent job using the same user as the Maintenance Plan and it works...

Thank you!

I ran the profiler with the Audit Login Failed event class and got the application name. It was a monitoring application that was supposed to be removed prior to...

I have to agree with the mob with the burning torches, # 3 doesn't work.

Adam,

I'm not sure what application is using this account. The applications appear to be working correctly so I don't know where these attempts to login are coming from. I see...

DAB - This user is a Windows account, the Enforce Password Policy and other checkboxes are greyed out when I select the Properties from Security > Logins > user. Should...

Just muliple choice, no performance based section? I took 431 a little bit ago and expected the next two to be like that one.

Tim