Try this conn. string

"Provider=sqloledb;Data Source=Srvr;Initial Catalog=DB;User Id=Usr;Password=PWD"

MW

This link has lists of assertion errors:

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q290/2/12.ASP&NoWebContent=1

MW

As Henery pointed out, its better to handle the situation at app. level

but if you must you can use this proc to view and kill processes

I use the combined...

quote:

---

Hey guys,

This is very interesting. The where statement influencing the quesry optimization.

Let's get real!!!! MIcrosoft is very stupid... they can have had...

Maybe you left out something when you pasted this query,

but I don't see this table joined with any of your other tables

(select poprj_uid from dbo.PO_Projects) as po_projects

The other thing I...

1, Yes, if any of your param. is NULL existing col. value will be used

But non of your parmas. can't be NULL as you have it now

...

Ref. article

http://msdn.microsoft.com/library/default.asp?url=/library/en-s/acdata/ac_8_qd_12_3164.asp

you can also use the openrowset function to update remote tables

Update

OpenRowSet('SQLOLEDB','SERVER';'UserName';'Password',

'Select au_id, au_fname

...

Select a.account_id, a.bill_contact, a.bill_address, cc.cc_number, cc.cc_type, cc.cc_exp

From Account a, (Select *

From Credit_Card) As...

Within your update event (click button event)

Make a call to your proc. passing it your variable value as a param.

First instantiate ADO's command objects to make your proc. call

...

quote:

---

Tim:

Index covering is for non-clustered indexes, but in this case the aggregate

function would force index covering b/c the optimizer in almost all...

In most cases, Index selection is based on SARGs

which is determined by your [WHERE] clause.

The rule is that for an index to be considered by the optimizer, at least

the first...

IF Exists(Select Billing

From Table

Where...

Check if your table has trigger or other constraints which may cause

Insert and update performance issue.

I run a test on a server with 1gig mem and a table that has...

You can use a derived table like this

Select Sum(T0.Docamnt)+T1.Docamnt_Sum As Total_Sum, T1.Docamnt_Month As Unique_Month

From Table1 T0,

(Select Sum(Docamnt) As Docamnt_Sum,...

DBCC CHECKIDENT will create a duplicate Identity values

Ex. Id_no, Name

1 Test1

2 ...