Did you check sql server logs/error logs and event log (Windows) to see if you can

get more detail of the error.

Regards,

Sushant

Also,

maybe the server is configured only for Windows authentication. IF it is, Turning on Windows+SQL server authentication can solve the problem.

Regards,

Sushant

Hi,

Did you see error in sql server logs/error logs...

You might get more info from there.

Regards,

Sushant

+1 😛

Richard Moore-400646 (11/28/2011)

---

I should stress the fact that this will absolutely replace every occurance of the 1st character with 2nd character everywhere it exists in that column. So if...

no, they are equally good

Lutzm +1

Regards,

Skybvi

thanks a lot.

Regards,

Skybvi

Can it be done within the SSMS or AD ?

Can i know the steps please.

Regards,

Skybvi

Edition upgrade of 2008 R2 is quite different from what we used to do in SQL Server 2005, where we have to start installer from command prompt by passing the...

Have you tried searching on google?

There's no way you can't find the answers there...

Regards,

Skybvi

Jpotucek (11/18/2011)

---

Thank you!!!

I ran this and it worked:

;WITH cte

AS (SELECT ROW_NUMBER() OVER (PARTITION BY path, sortOrder,id, repname, repfilepath, language_cd, updateddate, repFormat

--add all column names col1,col2,...

ORDER BY ( SELECT 0)) RN

FROM...

Cliff Jones (11/18/2011)

---

Yes Sushant, I was...

Other than that, Does somewhere the 'sa' password is hard coded??

Regards,

Skybvi

;WITH cte

AS (SELECT ROW_NUMBER() OVER (PARTITION BY Col1, Col2

--add all column names col1,col2,...

ORDER BY ( SELECT 0)) RN

FROM table)

DELETE FROM cte

WHERE RN > 1

Regards,

Sushant