SQL server registered server usage It is very useful for DBAs and junior DBAs to collect information from all the servers, reports etc. Example: Collect all the logins, jobs, larger database size from all the 300+ servers etc. It is per user, each one needs to create their own category version wise or environment wise. Make sure, the query will run all the servers, try to use select mostly, if you are performing and DDL or DML verify it before running, since it will make changes in all the servers. You can also use centralized management server, it is for all users.

How to delete rows in a table are same identical rows in all the fields where clause column. Recently, i got this from one of my friend.   create table tbl_delete (id int, name varchar(30)) insert into tbl_delete values (1,'Muthu') insert into tbl_delete values (1,'Muthu') insert into tbl_delete values (2,'SQL') insert into tbl_delete values (2,'SQL') -- Two rows are same with all fileds select * from tbl_delete WHERE id =1 Begin tran SET ROWCOUNT 1 DELETE FROM tbl_delete WHERE id =1 SET ROWCOUNT 0 -- Run this when you see (1 row(s) affected), otherwise rollback tran Commit tran Hope this help someone.