Yes, see here:

http://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&displaylang=en

There are also cumulative updates above and beyond SP2

Steve is of course correct... got into my head that you were referring to .TRN files, which is of course tran log backups, not the .ldf which is the tran...

Take a look at the view dbo.syslogins in the master database. This should give you what you need (at least for server roles - for database roles, look at...

vivekmang (6/2/2008)

---

Here is the first few pages of the logfile:

Its got the line in the end where it says error = 203 -- see if you can spot anything...

Have you ever had any other version (or a copy of this version) of SQL Server 2005 installed on this machine? (dev, xpress, etc)

What do you see in Add/Remove...

The first thing to check is your recovery model. Is it set to simple?

I don't believe you can get around having to make the user a member of the bulkadmin fixed server role, but I could be mistaken.

There is no way to grant...

No problem 🙂

This link is useful for diagnosing the specific cause of the error:

http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

Only when a database is unavailable/offline...

No, you can't set AutoShrink in TempDB.

You could try this link. It did work for at least one similar problem (although it mentions SP1, it's worth a shot).

http://support.microsoft.com/kb/926623/

Can you post the installation summary log? It should be a file named "Summary.txt" in a location similar to:

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\

See Books Online:http://msdn.microsoft.com/en-us/library/aa258803(SQL.80).aspx

Pages Scanned

Number of pages in the table or index.

Extents Scanned

Number of extents in the table or index.

Extent Switches

Number of times the DBCC...

Interesting, thanks for posting final outcome.