Access 2007 definitely has performance & stability issues in several areas.

Example: The user previews an Access report on-screen, and then sends it to Word in RTF format. With Office 2003...

Derek Dongray (4/18/2008)

---

Habit. 🙂

Novices start by firing up SSMS and...

Derek,

I wonder why it doesn't work the same way for you.

I am running MSSQL 2005 SP2 Developer on Win XP Pro SP2. I open SSMS, click New Query & connect...

Two more great tips, thanks.

BTW to run the query, you need to enable 'xp_cmdshell' in Surface Area Configuration.

The only correct answer is:

select * from sysprocesses where program_name like 'SQLAgent%'

on my dev system (MSSQL 2005 Developer) with Agent running, it returns status = "sleeping" and cmd = "AWAITING...

K. Brian Kelley (4/13/2008)

---

I don't think anyone has said there are no bugs. There are bugs. If you want to see the builds since SP2, here you go:

The SQL Server...

There is certain information that should never be included in a resume - age, weight, height, marital status, religion, or political affiliation. The only exception would be if any of...

The RESTORE command has been enhanced with an additional safeguard: SS2005 will check if the "tail" of the transaction log has been backed up. This tail refers to transactions that...

Thanks Wayne. You mention 2000, but does this work the same way in 2005? I know that some things have changed...

I use scripts to backup from production & restore to...

Yes, but - Steve also stated "You can ask the server to start a 2nd backup, but it fails." - but my test showed that it does not "fail" (e.g....

I decided to try this on my dev machine. I opened two new query windows:

Query 1:

BACKUP DATABASE [lampsPAR] TO DISK = N'C:\Bill\wm_LampsPAR_01.bak' WITH NOFORMAT, INIT, NAME = N'lampsPAR-Full...

I also agree that No is the correct answer. The question stated

"Can you start a second full backup running"

and the answer is of course No. However, it will "run" after...

I voted for SP3 but now I'm having second thoughts.

SQL 2000 had SP3 but then was followed by SP3a.

SQL 2005 had SP2 but then was followed by SP2a.

It seems to...

My interpretation of the phrase "maximum size of a row" was in the context of the 8060-byte limit. There was no mention of storage size in the question, so I...

I enjoy the QOD and would like to offer a suggestion.

Could you add a link to bypass answering the question & go straight to the discussion? Of course, you would...