There is also a standalone patch for this bug. Check out microsoft.com Q323875 hotfix.

Paras Shah

Evision Technologies

Mumbai, India

does this affect sql server 7 also? or does it affect only sql 2000 machines

Paras Shah

Evision Technologies

Mumbai, India

The first one seems to be perfect!

Thankx a lot!

Paras Shah

Evision Technologies

Mumbai, India

But by this query you are getting 3 people from dept 2. Only 2 wanted

13vijay140001Home

16hitesh140001Home

18kiran270002Office1

19gautam270002Office1

20abhi280002Office1

23amit3110003Office2

24sunilr3120003Office2

quote:

---

SELECT

*

FROM

Emp oQ

INNER JOIN

Dept

ON

oQ.deptid = Dept.deptid

WHERE

Salary IN (SELECT TOP...

if exists (select * from sysobjects where id = object_id(N'[dbo].[Dept]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[Dept]

GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[Emp]') and OBJECTPROPERTY(id, N'IsUserTable')...

this is what i'm hearing something new! Is it possible to create new response objects in ASP

quote:

---

You're sounding like a broken record.

A...

I have tried changing the contentype. But it does not change once set. I changed it first to image/gif and then when i want to write html text next to...

Is MS frightened of not revealing SPs codes? 😉

Then better they encrypt them. Whats your opinion!

Paras Shah

Evision Technologies

Mumbai, India

Is MS frightened of not revealing SPs codes? 😉

Then better they encrypt them. Whats your opinion!

Paras Shah

Evision Technologies

Mumbai, India

This query can be used if you plan to use INTERSECT

USE pubs

GO

SELECT pub_name

FROM publishers

WHERE NOT EXISTS

(SELECT *

FROM titles

WHERE pub_id = publishers.pub_id

...

Is this only to avoid CPU Overload. Or are there any other reason for such an advice from you?

quote:

---

In no case...

Thankx, shall check out BOL for more info.

quote:

---

The cutoff point is whatever you set it. If you don't set it, then all...

Ok, great! Thankx

quote:

---

In that case it really would be up to you. Sorry no help there but this runs into how much...

What if, I have the IIS and SQL Server on the same machine. That would avoid the trips over the hubs. Then what would have been your choice?