sbvenkatesh77 (4/9/2009)

---

Hi,

One of our Production Server, we face the below mentioned problem.

We are unable to open the SQL Server Management Studio. It throws...

bvinay57 (4/10/2009)

---

Hi

i am developing birt reports from mysql database wen i am retriving data from the table SELECT advid , country , state, city

FROM...

Husain_Kachwala (4/10/2009)

---

Hi All,

I have a situation. I have a job in sql server 2005 which executes a stored procedure.The problem is that this stored procedure accepts two parameters @StartDate datetime,

@EndDate...

ramu4ind (2/25/2009)

---

Hi,

how to convert milliseconds into hours,minutes,seconds and milliseconds.

i have two dates from that i have taken milli seconds using datediff.now i want to display total hours,minutes,sec,millisec in that milli...

gyessql (2/9/2009)

---

I need to Insert or update the records into a table based on a condition. Can I use case statement for something like this:

select case isnew

...

lots of methods

- use jobs

- write a small application and put that in the...

yacobsbht (2/10/2009)

---

Hi Everybody!

How can I enter data being in MS access 2000 project to an SQL server 2000 table? I have tried it, but it does not allow me...

peitech (2/10/2009)

---

I have a table of contacts and a table of firms, I am trying to extract contacts at firms. Contacts can be tagged as a specific type - as...

jack_hc (2/3/2009)

---

Hi buddy,

i have a request from a user to pull out data hourly (9am-5pm) from statistics table sys.dm_os_wait_stats in SQL2005. the output can be either csv or a table....

slumdog millionare

PhilPacha (1/28/2009)

---

A former co-worker has asked this question; I admit, I'm a bit intrigued.

Given the name of a stored procedure, is there an “efficient” way to determine that...

jreyes (1/19/2009)

---

Hi I have the following situation with a new application I will design for a distributor.

They have sales people around the state and they need a way to enter...

gail is right. nolock will consider the uncommitted transactions, and deadlock graph will show the complete details.

ryp (1/19/2009)

---

in SQL server management studio, how can I edit a table's contents?

i can see the databases and the tables and the columns and so on on the object explorer,...

rfugikawa (1/20/2009)

---

Hi guys,

I need to open and to read a mdb file that is in a Windows 2003 Server 64-bit. But an error message shows when I try to do...