Tell about MOM Tool(Microsoft Operator Manager)?

741

What are the dis_advantages of stored procedures, triggers, indexes?

1029

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

366

You are doing log shipping due to some reasons it is failing. How you will proceed from there

885

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1198

how can you attach more than 20 ldf files in sql server

889

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

1632

What is the difference between NOROW and LOCKROW?

1367

whats new about truncate in sql server 2008?

1366

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

768

sql database suspect We have a sql database that is showing as suspect. How can we recover?

773

how to do partition in sqlserver

1359

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

732

what is isolation level at dead lock?

1069

how to overcome kernel isssues

519