on INSERT, of course Columns_Updated returns 3...ALL columns (column 1 and column2 )are affected on INSERT, even if a null gets inserted.....

but if you UPDATE, using jeff's same example,

UPDATE TriggerTest...

you can't use a variable for an objectname..so you cannot stick something in to replace a tablename or fieldname directly in a statement...you have to use dynamic sql:

fails:

if not exists('select'+@Fieldname...

--[Inserted] And [Deleted] tables are special virtual tables that contain all the records affected by the insert or delete; it is critical that in a trigger you use a set...

SELECT

CASE WHEN LEVEL1 = 'PLEASE SPECIFY' THEN '' ELSE LEVEL1 END +

CASE WHEN LEVEL2 = 'PLEASE SPECIFY' THEN...

i got the same error on one of my databases when i tested your code;

adding collation to the first field fixed it for me:

select 'DROP INDEX ' + object_name(s2.object_id)...

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...