Are you sure you are using an ID that has 'sa' rights?

did you bounce SQL Server after you changed the password?

Make sure you changed the password in all places as far as MSSQL Server and...

Did you change the password of the SQL Server service to?

Steve Jones - SSC Editor (5/1/2013)

---

CO is leading the division, so I'm not sure how much we count a month of baseball. A few year ago the Yanks were 10...

roryp 96873 (4/29/2013)

---

Markus (4/29/2013)

---

Yea, it isn't how you start, it is how you finish. Games in April count just as much as ones in Sept though. Sometimes one...

Yea, it isn't how you start, it is how you finish. Games in April count just as much as ones in Sept though. Sometimes one game is all...

Oh I don't know. Hypothetical situation. The cost of upgrading if we had all of our dbs on SQL2005 to 2008 to the company would be tremendous. Licenses, hardware,...

To a degree I agree with you. However, with todays new technology a 'system' can live on indefinately with VM. when the old machine is becoming old you...

It has taken us almost 4 years to get all but 8 production databases off of SQL2000 to 2008R2. Yes, we still have 8 on SQL2000! We have...

Honestly it is probalby best to open a case with Microsoft Support on this. You might have the CU applied via into SQL Server as far as the...

Quite honestly I have never even looked at Powershell. Probably doing a mis-service to me but I just don't have the time.

Well, I have patched via SP and CU's on SQL2008 and SQL2008R2 clusters doing the passive node first, then failing SQL Server over and then patching the other node without...

Understand now. Thanks a million.

Great idea. I recreated the audit table just how you described and it works for inserts and updates.

However, I have the trigger selecting the first column in the identity......

Well, the apps guy says this:

That column can't be an identity column in the audit table. It needs to link back to the job_posting_num column in the job_posting table....