I run XP at work, Linux Ubuntu Feisty at home.

I don't see myself running Vista until I have to.

I like XP, its a decent OS. I'm not...

That query works and returns two records which are the two jobs I have listed under SQL Agent.

Do you want the records?

More info - problem (possible bug) found.

There appears to be a bug in SSMS. I profiled clicking on the maintenance plan. Here's the code SSMS generated:

/* ...

Hey Mark,

You're right but that not applicable in this case.

The message occurs when I expand Management | Maintenace Plans and then double click on the maintenance plan OR If...

Whenever I've seen this in the past, the user's account was locked out. (Ie. Too many pw retries, forgot their pw, etc.)

Chris.

Thanks, that worked.

Chris.

We have 3+ developers and myself. I'm the DBA but I do some development here and there.

We are in the process of switching over our way of working. We will have...

Well that was my original feeling too so I talked to the programmer while I troubleshot it. It turns out it is not, because in EM when I return the...

Will do - but I can't until tonight.

Something additional to note - write caching was enabled on the SAN drive assigned to the SQL server. I had that disabled.

Chris....

Here's some more information.

I have tried the following with the same results:

*backing up to the unc path

*Backing up to the UNC Path using IP address

*Creating a backup device via UNC...

Well not according to this: http://www.microsoft.com/traincert/mcp/mcdba/requirements.asp

Chris.

quote:

---

Hi, I am hoping to be sponsored by my company to do the exams this...

D'OH!

Right, there are duplicate records in there, probably causing their amount to be repeated and summed again.

Thanks!

Chris.

quote:

---

These queries are not...

Thanks for your help guys.

Chris.

quote:

---

Actually answered my own question (868 rows), sorry. Why are you using FAST FORWARD and not READ ONLY as the cursor...

What I did was install client access onto the server, reboot and patch it up to v4rm4.

Then I created a System DSN using the Client access drivers.

Then I created a...