create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,

---

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

0 Answers  

---

How to select true false based on column value in sql server?

0 Answers  

---

How to turn on the mssql api module in php?

0 Answers  

---

What is a print index?

0 Answers  

---

What is data source view or dsv? : sql server analysis services, ssas

0 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 do you understand by replication in sql server? Mention the different types of replication in sql server.

0 Answers  

---

What is RMS migrations?

0 Answers   Satyam,

---

What should we do to copy the tables, schema and views from one SQL Server to another?

3 Answers  

---

Where are magic tables stored ? Is it in the same database where it is created ?

4 Answers  

---

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers   Cognizant,

---