Thanks Greg for your information.

Really very good stuff to know about version controlling in SQL Server and surely this way will help the developers to version their stored procedures.

Kodi

Thanks Gentlemen, i got your point.

Kodi

Not understood your point, could u please explain more?

Thanks

can u try this option, copy the source file to new file and try to access new one. one more option, restart the system and test it out.

Kodi

Hi,

You can try this option, start SQLServerAgent and MSSQLSERVER services in your account domainname\username by rightclick on the service and goto properties->logon tab.  The username should have the access permission...

Appreciate your alternative method to delete duplicate records.