In what circumstances?

As I've been asked for the set based solution here it comes :

--I use this table for many other string operations as well

GO

CREATE TABLE [Numbers] (

[PkNumber] [int] IDENTITY (1,...

Maybe you could export all the dts to vbs, then flag which dts use the sa account then manually change them on the server... I hope that there's a better...

An restarting enterprise manager??

Is there anything in the server's logs?

Update Perm set Perm.RegDate = Temp.RegDate from dbo.PermTable Perm inner join tempTable Temp on Perm.id = Temp.id

Make sure you have a backup of the table before you do the update......

Or maybe just refreshing the db list...

You can't include Forms!myform!myvalue in the proc code.

You must create a new form

set the data source of the form to dbo.ProcedureName

then in input parameters you must set it to Forms!myform!myvalue

Select case left(colname, 1) WHEN '0' THEN '20' ELSE '19' END + Colname as NewDateCol.

There probabely is a better way to do it but have you considered appending 19 or 20 to the begenning of the field so that sql server can have...

Yes it is .

Here's the article... maybe I missed something :

http://www.sqlservercentral.com/columnists/bkelley/procedurecache.asp

and another one in the same line :

http://www.sqlservercentral.com/columnists/mmetcalf/hitsandmisses.asp

I've read something interesting here on this site. There's a 3rd way to generate cache misses. You can either have a sp name sp_MyProc (cache miss because not...

Update x set x.a = Z.Code from TableX X inner join

(select code from openquery(select b,c,code from table y)) z

on z.b = x.b and

z.c = x.c

in the form source use dbo.ProcedureName

and in input parameters : Forms!myform!mytextbox

then separate each parameter with a comma.

What is the question?