Sorry for the previous question.

The point that I had mentioned is that we do not use this statement when working with ADO 2.5 and ADO.NET.

What I missed out there was...

We never use this option while using the ADO 2.5 or the latest ADO.net. Does this mean that these object libraries do it on their own.

Pay Respect to People on...

Try this.

select student from

a

where number of tests >=30

group by student,percent

having count(marks)>=2

union

select student from

a

where number of tests >=40

group by student,percent

having count(marks)>=1

Pay Respect to People on your way up. For...

Have u by any chance set value of IMPLICIT_TRANSACTIONS to on

Pay Respect to People on your way up. For you will meet the same People on your way down.

Just a guess.

The user under which the new tables are being created is different then the one previously used.

Pay Respect to People on your way up. For you will meet...

Since you cannot drop a database when some one is connected to the same, you need to keep the store procedure in some other database and connect to that database.

you...

Visual Basic Part

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

on error goto error

Dim oCommand As New Command

oCommand.ActiveConnection = <connectionobject>

oCommand.CommandTimeout = 100

oCommand.CommandType = adCmdStoredProc

oCommand.CommandText = <storedprocedurename>

oCommand.Parameters.Append oCommand.CreateParameter("@status", adInteger, adParamOutput)

oCommand.Execute

Exit Sub

error:

...

Try this out..

select customers.customerID,sum (case when orderdate < '1997-01-01' then 1 else 0 end) as a,

sum (case when orderdate > '1997-01-01' then 1 else 0 end) as b...

Are you sure no one else is updating the same set of records during the time you are executing the queries.

I mean in a multi-user scenario this might be the...

Firstly I am sure you are connecting to a database other than the database you need to drop while executing the drop command from the front end.

If this is true...

If you are using more than one column in the where clause, try using covering indexes

i.e. composite index on both the columns.

Relationships are like Banks.You Invest the Principal and...

Sorry for the confusion.

Suppose my text files had this data

1|Deep|5000

2|Anil|5000

....

and so on

I would create a sp like this

create proecure @c1 varchar(8000),@c2 varchar(8000),@c3 varchar(8000)

To this store procedure I would...

Recently I had a similar issue. I had to upload around 1 lac record from a text file into the sql server database. I will let you know what I...

Have you tried.

sp_help <table_name>

It will return two recordsets. The second recordset will return you column details.

I am not sure whether this will help u?

Relationships are like Banks.You Invest the Principal...

Refer to BOL

It says that

If the compatibility level is 80 or higher, SQL Server allows the update of text, ntext, or image columns through the INSTEAD OF trigger...