Answer Posted / sanjeev kumar

First Method:

select table_name from information_schema.tables


Second Method:

Select Name from sysobjects where xtype='u'

Note: here 'u' means user created

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

1269

---

Explain different types of index?

1064

---

What happens if you insert a duplicate key for the primary key column in ms sql server?

977

---

Distinguish between nested subquery and correlated subquery?

1045

---

What is the exact numeric data type in sql?

1003

---

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

1010

---

What is log ldf?

985

---

You want to use a perspective in an mdx query. How do you select the perspective?

239

---

Define msdb database?

1023

---

Explain datetimeoffset data type in sal server 2008?

910

---

How do we Backup SQL Azure Data?

108

---

How do I uninstall sql server 2014?

936

---

How to create a view with data from multiple tables?

1012

---

Explain the dbcc pintable command when would you use it?

921

---

How to enable tcp/ip protocol on a sql server?

1162

---