Re: Trying to creatively work around 8000 Character limit with sp_executesql

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 11/30/04 

Date: Tue, 30 Nov 2004 10:29:35 -0500

> I have a situation where it would be very handy to use a database
> trigger to dynamically re-create a stored procedure within our system.

I'd have to agree with Adam. You've already decided that you need to use a
trigger to dynamically create stored procedures. Maybe if you explain the
actual business need we can help you come up with a not-so-left-field
approach. 

-- 
http://www.aspfaq.com/
(Reverse address to reply.)

Relevant Pages

  • Re: Trigger, alternative way to pass variable to trigger
    ... You don't have to execute the setUser command in the master database, ... create trigger trigger name ... to call stored procedure or execute sql commands and let it handle it the ... Pro SQL Server 2000 Database Design ...
    (microsoft.public.sqlserver.programming)
  • Trigger Timeout Loop Issue
    ... In our database code, we have an AFTER trigger on a specific ... since the record is locked by the trigger, the stored procedure ... processing will the stored procedure (and thus the web service) ...
    (comp.databases.oracle.server)
  • Re: Question on Triggers
    ... If the trigger fires, it can either execute code directly or it can execute a stored procedure. ... Cross database does have security issues, but Erland Sommarskog's article discusses all the ways that you can get this to work, with the pros and cons of each. ...
    (microsoft.public.sqlserver.programming)
  • Trying to creatively work around 8000 Character limit with sp_executesql
    ... trigger to dynamically re-create a stored procedure within our system. ... We have many copies of a very similar database structure, ... than 8000 characters, contrary to what I have read on this newsgroup ...
    (microsoft.public.sqlserver.programming)
  • Re: Having Trouble with triggers!! ~ Please Help!
    ... >Try changing your trigger. ... >> master database and three satellite using triggers. ... >> I created two test databases, one on the same server ... >> the stored procedure, right?!... ...
    (microsoft.public.sqlserver.replication)
Quantcast