gururajan (11/10/2008)

---

I can able to add values in to table but the problem is i want to add distinct values to the table i.e the value should not be repeated...

madhu.arda (11/9/2008)

---

Hi,

I would like to test the following recovery scenario:

1.There is some activity has been done on database 'abc' from 3:00pm to 3:10pm

2.stop sql server delete ldf file of...

peter.a.day (11/7/2008)

---

I have a problem which I have simplified into the following example. Say I have a recording of events happening. My table might be:

[font="Courier New"]Id User ...

RichardB (11/6/2008)

---

How do you guys handle moving large files across networks - not just local networks but ones with a high enough rtt that ftp becomes a bit pointless?

Any good...

Vivien Xing (11/6/2008)

---

There are many different ways including 3rd party tools to recover lost data nowadays. I am trying to collect all the possible solutions for these scenarios:

A.Table has...

Mh (11/6/2008)

---

we are planning to set up database mirroring in sql 2005:

1. If a web application is running against the primary database and if the primary db fails, so it...

rathnamdamineni (11/6/2008)

---

Hi experts

in my table one column datatype is varchar(200)

in this column user can insert data in these form

('AA1000','2008-20000' , '2009@20000'.....)

i need to split those values as shown below

example:

1. 'AA1000'...

anam (11/6/2008)

---

i have been playing with date datatype for long but found this strange problem today. It could be i haven't noticed it before or this problem just popped up...

Shripad (11/6/2008)

---

[font="Times New Roman"]Is there any one who can help me in installition of sql server 2005 with unattended installition. We have built in files in sql 2000 but this...

My pleasure

not one client per server. it should be in the form of...

gator88 (11/5/2008)

---

This is on SQL Server 2000. We made a copy of our production server for development environment. The problem we’re having is with SQL Server Jobs. The jobs are...

tspot (11/5/2008)

---

[font="Courier New"]Hi,

I have these tables :

TABLE1

ID NAME PARENTID

=== ========= ========

1 SALES -1

2...

anoop.sakthidharan (10/27/2008)

---

anyway i don't want to use a error log , and track that log file, would like to know any other alternative way to debug a stored proc. make...

patr (11/5/2008)

---

hi

I have two table like as shown below

TABLE1 ...