i think this part of the query is contributing to the slowness:

AND a.LineNum <= D_BomCalcTrans_t05_t.LineNum

because that can't be resolved as...

you are going to kick yourself...you did all the work, and are just missing the UPDATE ...FROM part:

Update MyTable2 m

SET m.field1 = ##MyTempTable.field1

FROM ##MyTempTable

WHERE m.field2 = ##MyTempTable.field2

yes you are right; and this is wierd;

if the OS is 2003, then it should install 2000 standard version; if it is saying personal edition, that is not right....

is it...

in a nutshell, you can't.

you'll have to upgrade your operating system.... SQL 2000 standard or enterprise can only be installed on Server version operating systems...Win2000,2000 advanced server, 2003;

The cd gracefully...

see if this will help;

here i'm just taking a static value and casting it to binary, then casting it back again.

i believe that is all you'll have to do; it...

SQL Noob (11/5/2008)

---

once in a while we have weird problems like this and most times it's in a database that has been around since SQL 7 and continually upgraded across...

in another thread on a similar issue, where his 2005 server was slower than his 2000 with the same query, someone finally identified that in their case, they had seen...

you might need to review your web app for errors....

the identity is incremented even if there is an error in your code.

here's an example: the third insert will fail....the value...

David i don't know how useful it is, since for me it doesn't seem to be accurate;

I've updated statistics on a table for example, but this report give me results...

a lot of the information you ar elooking for(like IP address) is not stored in any database, so it can't really be done in TSQL without using something like xp_cmdshell...

i think if this query:

SELECT DISTINCT Cust_Num FROM fs_Unit

returns a null in the distinct collection, you'll get no results;

you might need

SELECT DISTINCT Cust_Num FROM fs_Unit WHERE Cust_Num IS NOT NULL

how about this idea:

turn each query into a view, then use sp_depends VIEWNAME, then drop the views when completed?

the issue you are running into is the account SQL server is running under is not an account that has access to the network. jobs (and xp_cmdshell, or anything that...

try this, it is slightly modified; if the dll cannot be created, an error will be raised....that would tell us that you need to register or re-register the RichText and...

Hi arun;

with 8 pages of RTF examples, using various methods, which function are you using?

if you are using something featuring sp_OaCreate, I'm sure the null gets returned if the richtextbox...