Jaya Chitra (11/19/2008)

---

Dear Friends,

In my application, I have the below requirement.

When the user specifies a keyword, I have to search the complete database tables and column values which matches the...

Mike Levan (11/19/2008)

---

Does any one has a script where it gives all logins the instance , db's associated with it and the server role it has. something like this

Login ...

yes distinct applies to the whole record and sql created the duplicates where it requires to fill the...

pratyush.singh.chandra (11/19/2008)

---

i have a select statement and through this select statement i want to create txt file .if is a possible give a better suggestion to me as...

jsnv (11/18/2008)

---

Hi,

I have a problem to find closest match data inputted with the one in Table.

eg. In my Table, i have data like this.

0010 ...

deepak.spiral (11/18/2008)

---

i am using SSRS in a Report i have a colomn Cotaining Date in dd/MM/yyyy Format

11/12/2008

11/12/2008

12/12/2008

12/12/2008

12/12/2008

15/12/2008

15/12/2008

15/12/2008

by this colomn i need to find Max and Min at Runtime/Report Preview.

as...

Nandy (11/18/2008)

---

Hi All,

I have used the cursor in the stored procedure to delete the data from the table. I'm deleting the data from table where I used the same table...

Database mirroring can be simpler to implement. When using its synchronous mode, the mirror database is...

thanks for knowledge updation

Yes , it takes time

first query processor tried to find out where your...

Rohit Chitre (11/18/2008)

---

Hi Thanks for the reply. It is one time task. But I have to delete the records before users start using it i.e. before putting it on production.

Thanks...

arnold (11/18/2008)

---

Hi Experts,

Need your help on how to display my 3 columns coming from 3 different tables. I have 3 Tables with 1 column.

create table DimLab1 (idno int,

WidthData float...

karschnike (11/18/2008)

---

I am not a programmer by any stretch, so although this is a very simple question for most (if not all) on this site, it is beyond me. ...

Rohit Chitre (11/18/2008)

---

Hello,

I have a table of 3.7mn records. I need to delete 37,000 records from it.

I have created a temp. lookup table (not # or ## table) which...

Paresh Prajapati (11/18/2008)

---

I have to implement Database Mirroring or Log shipping on different server in which one server is located in USA and other in Hongkong..

So, which option is best...