Clive Strong (9/8/2009)

---

nazaninahmady_sh (9/8/2009)

---

i should say that i forgot my password, and i tried to change it when i use new pass this error is occured ,i think i...

Are there any other SysAdmin accounts created?

If you have forgotten the SA password and dont have any other SysAdmins, I'm not sure what you can do, other then rebuild. Its...

Assuming (as Gail suggested) that SQL is running, follow the instructions in http://dbaspot.com/forums/sqlserver-server/357071-sql-server-2005-login-connection-error-233-a.html and ensure that you can logn to the server.

I'm guessing your not using SSMS on the server...

How are you connecting? SSMS or SQLCLI (comman line).

Have you verifyed through event veiwer that the physical server did restart?

It may have been that that 1 sql server (instance) rebooted. If all looks ok, then you should look...

joeroshan (9/3/2009)

---

Is there a way to create a group in AD and add all DBAs to the group so that they can access all SQL Servers in the domain.

How to...

sanketahir1985 (9/2/2009)

---

i m having sql2000 & sql2005 both servers

now i want to make daily monitoring sheet which should be automated.

i want a sample sheets if u have it.so that i...

Backups, backups, backups!

Firstly i cant beleive your still running RTM. Have you not noticed how your maint plans tend to corrupt each time you change them?

Have a good read...

No. otherway around. do 2 then 1.

Hey there,

Ok where to start. Firstly I think you may be over complicating things for yourself. I'll start by saying what we do and hopefully someone else will be...

I'm with Jack, Elliot and Jeff; you absolutely have to know this stuff. Other then what everyone has said so far, depending on the company, the DBA is generally the...

Network Error: duplicate post removed

Network Error: duplicate post removed.

nikhil.verma (8/20/2009)

---

Yes , i tried using the options mentioned in that forum but no luck . Seems these options were valid till sql server 2000. For SQL SERVER 2005 do...

As in even though they are selected by default they dont do any thing (on or...