Answer Posted / karthikeyan

SELECT IDENT_CURRENT('table_name') ;

How to run queries with sql server management studio express?

571

---

What is the maximum rows in sql server table?

512

---

What are the different types of collation sensitivity?

555

---

How to configure and test odbc dsn settings?

573

---

How will you monitor replication latency in transactional replication? : sql server replication

611

---

---

How to use group functions in the select clause in ms sql server?

537

---

How display code or Text of Stored Procedure using Sql query in Sql Server ?

607

---

What are different types of constraints?

509

---

What are basics of policy management?

608

---

in the physical file layout, where should the transaction log be stored in relation to the data file?

536

---

what stored procedure can you use to display the current processes? : Sql server administration

528

---

How to create median function?

118

---

Explain error handling in ssis?

570

---

Write a SQL command to insert and update only a particular field?

628

---

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

596

---