Viewing 7 posts - 241 through 247 (of 247 total)
If you are only calling the insert from an application, perhaps a stored procedure with parameters collection can be used. A parameter defined as a string should not need...
July 31, 2003 at 9:29 am
I coded a few triggers. Here's my 2 bits.
In the trigger you have access to the "inserted" and "deleted" tables. They will let you do set...
July 25, 2003 at 1:03 pm
This has happened to me also. Would a statement like
RAISERROR('FYI: This message should be sent without delay', 10, 1) WITH NOWAIT
work for you? The severity is...
July 24, 2003 at 9:51 am
The script library for this site has the code for a CDO proc called "sp_SQLSMTPMail". It might be worth checking out.
July 14, 2003 at 9:37 am
You might try bol (bools online) for the topics "sp_executesql" and "Using sp_executesql". The object (e.g., table) names need to be fully qualified in order for SQL Server to...
July 11, 2003 at 10:44 am
Make sure the table is ordered by the column in question unless you want the count to reset. The UPDATE statement does not permit the order by clause. ...
July 11, 2003 at 10:06 am
Do not trust xp_sendmail in a trigger. We (County of Marin) have use Exchange with an Outlook client and have had trouble from time to time with email. ...
June 25, 2003 at 9:12 am
Viewing 7 posts - 241 through 247 (of 247 total)