Answer / arvind rohit

SELECT IDENT_CURRENT('table_name') ;

Answer / karthikeyan

SELECT IDENT_CURRENT('table_name') ;

Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 Answers  

---

How to divide query output into multiple groups with the group by clause in ms sql server?

0 Answers  

---

Simple example for difference between select and cursor in sql

1 Answers  

---

Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

2 Answers  

---

List the different index configurations possible for a table?

0 Answers  

---

What are database states in ms sql server?

0 Answers  

---

Can a table be moved to different filegroup?

0 Answers  

---

What is the difference between cross join and Full outer join?

1 Answers   HP, Standard Bank,

---

What is the difference between mysql and sql server?

0 Answers  

---

What is the purpose of sql profiler in sql server? : sql server database administration

0 Answers  

---

How many categories of data types used by sql server?

0 Answers  

---

How to get the count of distinct records. Please give me the query?

8 Answers   Value Labs,

---