If people were cheating to achieve something I think it would be a different matter entirely, but how much are they going to truly learn by copying the answers. ...

Hi Khalid,

You can do the following to turn single user mode on/off

USE master

EXEC sp_dboption 'yourdb', 'single user', 'TRUE/FALSE'

To why this is automatically happening I'm not sure, maybe you could post...

Hi,

Which version of SQL have you got installed? If it's 7 then in my experience you can't rename the server without having to reinstall SQL afterwards. If you...

Hi,

I agree with you. But who are they cheating at the end of the day?? QOD is good cos it gives you an idea of what your strong/weak...

Hi Jigman,

quote:

---

'Transaction cannot start while in firehose mode'

---

One of our developers had this...

Hi,

Sorry wasn't very readable was it. Three singles each side.

Laters

*I didn't do anything it just got complicated*

Here you go

@SQLQuery = 'SELECT ErrorMsg FROM ErrorTable WHERE ErrorMsg LIKE ' + '''Critical%'''

Laters

*I didn't do anything it just got complicated*

Something I've learnt is when doing upgrades is never rush them!! This is a dark chapter in my life as a wannabe dba.

I had to upgrade a...

Bond007's right depends on the location. I recently saw a contract job for a Senior DBA in London, £500 an day.

Cheers

*I didn't do anything it just got complicated*

Thanks Mark,

*I didn't do anything it just got complicated*

quote:

---

Newinstallation, restore.

---

Ouch!

quote:

---

quote:

--------------------------------------------------------------------------------

*I didn't do...

I'm assuming blind panic took over for awhile

How did you correct it?

*I didn't do anything it just got complicated*

Abend Frank,

quote:

---

delete BUILTIN\Administrators without knowing the sa password

---

Thats a classic!!

Später

*I didn't...

Hi Sal,

4060 is a login failure. Not sure how sql copes with rights and permissions when restoring from access. Accoring to BOL