Answer Posted / mobin sathupally

When we install SQL SERVER totally we got six databases.
Among six four are system databases and remaining two are
user defined databases,
The system databases are 1.Master
2.Model
3.Msdb and
4.Tempdb.
The user defined databases are 1.Northwind and
2.Pubs.

How to fine-tune reports?

268

---

How will you hide an attribute? : sql server analysis services, ssas

958

---

Write a sql query to display the current date?

1093

---

Explain in brief about Microsoft SQL server?

1096

---

How can I change procedure name in sql server?

1050

---

what is spatial nonclustered index

992

---

Describe the functionalities that views support.

1099

---

Why do you need a sql server?

1111

---

How many levels of sp nesting is possible?

1056

---

What are the different types of cursor?

1096

---

What do you mean by recursive stored procedure?

952

---

Does sql server use java?

1076

---

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

906

---

What is the difference between a "where" clause and a "having" clause?

1160

---

How fixed length strings are truncated and padded?

980

---