ok, since it appears the databases exist on the same server, you could do this:

Update DataBase1.dbo.MyTable2 m

SET m.field1 = ##MyTempTable.field1

FROM ##MyTempTable

WHERE m.field2 = ##MyTempTable.field2

Update DataBase2.dbo.MyTable2 m

SET m.field1 = ##MyTempTable.field1

FROM...

you can get a USB Terabyte and a half external drive for as little as 180 bux; whether you zip/rar an backup, or use a 3rd party tool, tha tmight...

if the table already exists:

INSERT INTO License_Audit(LicenseType,LICENSECOUNT,AUDITDATE)

SELECT 'MENU',COUNT(USER_ID) AS LICENSE_COUNT ,getdate()

FROM VMFG.dbo.LOGINS

WHERE PROGRAM_ID = 'MENU'

to create the table on the fly:

SELECT 'MENU' AS LicenseType,COUNT(USER_ID) AS LICENSE_COUNT ,getdate() AS AUDITDATE

INTO...

his query comes from a different system originally, not all dbms can use the UPDATE...FROM syntax, and instead use the style you see here....set somevalue = ([subquery referenncing the updating...

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