doss.tychicus (11/10/2008)

---

I'm trying to get the data from the table

between two dates and for the List of Doctors

select * from tbl_test

where convert(char(10),createdate,121) between '2008-01-01'

and '2008-12-31' and id_doctor in (1,2,3,4,5)

I...

chrish (11/10/2008)

---

I have an issue with a web application using a newly installed SQL Server

2005 database. All tables have an ID field that has an identity insert

assigned....

Paresh Prajapati (11/10/2008)

---

Is there any way to make script, which find oldest open transaction and kill those oldest Process.

I have tried dbcc opentran, but from that i can not got...

dva2007 (11/6/2008)

---

i do apologies if this question is very silly to you but i am just wondering when people send question and says problem with cube, working with cube. what...

oyen_kai (11/10/2008)

---

I have devDatabase and prodDatabase. prodDatabase is an out-dated version of devDatabase. I want to modify my stored procedures in prodDatabase based on the CLR stored procedures in devDatabase....

sid_sarkar (11/10/2008)

---

Hi,

I am new to this, I need to understand this script, can you tell me why we are using the xp_cmdshell, szVersion etc... here, what is its purpose. It...

ajaykini (11/10/2008)

---

Hi Experts,

I have developed a web based software for a Multi level Marketing Company where one member joins and then gets 2 members below him - one on the...

yes you can

use the function...

rbarryyoung (11/10/2008)

---

I am writing a client-called stored procedure that is (intentionally) leaving a Transaction open in xome caese, when it exits to the Client. In other cases it will...

kuka_99 (11/10/2008)

---

hi,

if you use import/export wizard, the indices are not copied because they are stored in sys table in sys.sysobjects and this table is not copied.

what you can do: script...

TVR (11/10/2008)

---

Hi there,

I read on the MS site how the licensing works, but I just want to confirm my understanding with those of you who have done some practical implementations....

Data Import/Export wizard

sanuj (11/10/2008)

---

Hi friends,

I want to keep more than one billion records in one table. I am facing performance issues with this table navigation. What would be the best method to...

yogaanand.me (11/10/2008)

---

hi friends

we are taking 2 days once full backup in week and every 3 hour diff backup

and every 15 mins log backup

suppose server failed in 3.20 Pm...

madhu.arda (11/9/2008)

---

thanks,

I did the steps as below:

I have the full backup at 2am, diff every 4hrs n log every 15 min

1.There is some activity has been done on database 'abc'...