Answer Posted / setaceo

In Workgroup Edition : 16 Instances
In Enterprise/Developer/Standard Editions : 50 Instances

Which trace flags are enabled in sql server?

989

---

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

939

---

What does it mean if @@cursor_row returns a negative number?

977

---

Why do we need different type of parameter?

1039

---

explain different types of constraints? : Sql server database administration

941

---

Tell me what is a linked server?

1025

---

Do you know the policy based administration feature of sql server 2008?

936

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

1127

---

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

962

---

What are the tables in sql?

1073

---

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

965

---

What is sql server replication? : sql server replication

965

---

How to fetch the next row from a cursor with a "fetch" statement?

1056

---

What is mean by dml?

986

---

Why I am getting this error when renaming a database in ms sql server?

1032

---