Posted by Dan Guzman on 10/03/42 11:43

> Thanks, but it doesn't work.

The script Tom posted works for me: Please expand on what you mean by 'it
doesn't work'.

CREATE TABLE MyTable(Col1 int)
GO

CREATE TRIGGER TR_MyTable
ON MyTable FOR INSERT, UPDATE AS
PRINT 'Trigger fired'
GO

UPDATE MyTable
SET Col1 = 'x'
WHERE 1 = 2
GO

DROP TABLE MyTable
GO

--
Hope this helps.

Dan Guzman
SQL Server MVP

"John Smith" <nobody@nowhere.com> wrote in message
news:1143512881_10135@sp6iad.superfeed.net...
>
> "Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
> news:SL0Wf.1028$m35.96044@news20.bellglobal.com...
>> Try:
>>
>> update MyTable
>> set
>> Col1 = 'x'
>> where
>> 1 = 2
>
> Thanks, but it doesn't work.
>
>
> ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet
> News==----
> http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+
> Newsgroups
> ----= East and West-Coast Server Farms - Total Privacy via Encryption
> =----

• Next in forum: Re: Where to write XQuery statements?
• Prev in forum: Re: SQL Server 2005: Collation Conflict Error when selecting Database Properties
• Thread view: Re: How to fire a trigger without changing table data

[Reply to this message]