Answer / Arun Kumar Jha

In SQL Server, to create a new Trace you can use the sp_trace_create stored procedure. Here is an example: n```sqlnEXEC msdb..sp_trace_create @TraceID = 1,n @Name = N'MyTrace',n @EventClass = ALL_EVENTS,n @Filename = N'C:MyTrace.tdf',n @MaxFileSize = 20,n @MaxLength = 4096n```

write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 <Null> 2 <Null> Solution : emp1 names are updated in emp2, write a query?

8 Answers  

---

on line cluster can we make if yes tell me the procedure

1 Answers   Microsoft,

---

How to run queries with sql server management studio express?

1 Answers  

---

What is the difference between function and stored procedure in sql server?

1 Answers  

---

What are the differences between char and varchar in ms sql server?

1 Answers  

---

How to stop log file growing too big?

1 Answers  

---

what are default? Is there a column to which a default cant be bound?

1 Answers  

---

I have Two table First have UserName and second is address, in address table more than value relegated to UserName table, i want to fetch 2nd address if exist other wise 1st address access

4 Answers  

---

What does it mean to be in union?

1 Answers  

---

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

---

What is The Use Of TIMESTAMP DataType in SQL Server 2005?

6 Answers  

---

I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?

2 Answers   Techno Labs,

---