have you made sure that the sql agent is not started, if it is then that will be using your single connection and stopping you from using it.

If you want...

Ok ive done some further work on this today and have written a quick job to just check the table every 5 minutes and alert me if any of the...

nary (4/25/2008)

---

Hi Guys

40-431 is very easy exam might be if you are new to SQL Server 2005 then you need extra practice otherwise with 40-45 min you can...

Tim, you will be pleased to know there are no simulations in the 70-444 exam, its pure multi choice independant questions, no scenario's/case studys/simulations. I quite enjoyed revising for...

MS are running their secondshot now until June 30th.

http://www.microsoft.com/learning/mcp/offers/secondshot/default.mspx

You need to take the origional exam before June 30th and any retake before July 31st (i think).

You must make...

ankitwaitshere (4/23/2008)

---

Hello,

I am running into an ironic situation. Here is the description:

On a server X, I have databases named 'Sales' and 'ABCCom'.

Now - on a differrent server Y, I have...

good point 🙂

Yeah i managed to pass first time 🙂 I revised a lot to make sure i did.

Re: the certs, i think any manager would quickly pick out who was...

The same with the MS books in the UK, you get 15% discount too. its annoying you cant use it with second shot because they are completely unrelated vouchers.

I...

Thanks colin. Could you let me know where i would find the io completions counter, under which object? and also, what results should you be expecting on a...

you can change how often the alerts are delayed but i don't think you can change the maximum time they are "alerted"

For the replication issues i set the delay to...

Roy Ernest (4/21/2008)

---

SP3 and SP3a was soo bad that they had to keep on sending Hot fixes and patches for them. SP3 was the worst SP MS has ever released...

Roy Ernest (4/21/2008)

---

Animal Magic (4/21/2008)

---

Yes you can run then both side by side on the same machine. One thing i would say is make sure that the sql 2000...

Fair enough. All i know is there have been a few machines which had SP3 on which i also put SQL 2005 on that ran into little issues. ...

Yes you can run then both side by side on the same machine. One thing i would say is make sure that the sql 2000 instance is service packed...