Standard to ease your work. by maintaining it, no one can drag you to their own standards. In addtions, Standard are always within your organzation. there is no global set...

Check this

http://www.sqlservercentral.com/columnists/dasanka/changemanagementinyourdatabase.asp

However, Community does not like this idea. you may read the comments from others as well

IDERA Diagnostic SQL Manager is a good tool

http://www.idera.com/Products/SQLdm/

Can you please paste the full error here so that it will be easy for all of us

I think it all depend on your business needs. check this

http://www.microsoft.com/sql/2005/default.mspx and identify what are the suitable features that will suit your business

Distributed Management Objects

You should have searched the net.

anyway

yes replication is a solution for it

 my name is nto addict, it is Dinesh Asanka

addict is label given by the site owners

what about using a cursor

create table temp#

(OrderID int,CustomerId varchar(10))

declare @CustomerId  varchar(10)

DECLARE cur_CustomerList CURSOR FOR

SELECT       

distinct CustomerId from orders

OPEN cur_CustomerList

FETCH NEXT FROM cur_CustomerList into @CustomerId

WHILE @@FETCH_STATUS = 0

BEGIN

 insert into temp#...

I am have ran out of ideas!!!

have you select the option of Force restore over exisitng database option

select top 0 * from <table name>

after selecting the backup file chekc the log and database path from the second tab of the restore window

thanks for voting

please vote if you haven't vote

http://www.sqlservercentral.com/columnists/darjun/deletingduplicaterows.asp

http://www.sqlservercentral.com/columnists/sramakrishnan/deletingduplicaterecords.asp