Re: execute sql task / stored procedure

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 09/25/04 

Date: Sat, 25 Sep 2004 19:51:16 +0100

Just because it is DTS does not mean you should not do as you would any oher
way.

Stored procs have their advantages and they are well documented (cached
execution plans, parse plans, security, not black box etc etc) 

-- 
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com
"Michael Vardinghus" <michaelvardinghus@notexisting.com> wrote in message 
news:eVBPFHxoEHA.516@TK2MSFTNGP09.phx.gbl...
> is there some performance considerations when
> using execute sql task - is it better to use a large
> stored procedure compared to 10-15 execute
> sql task.
>
> michael
>
>

Relevant Pages

  • Setting sql result to global variable?
    ... .The below code is included in the "Use ActiveX Script" area of an "Execute ... SQL Task" in DTS. ...
    (microsoft.public.sqlserver.dts)
  • Re: Antwort: Re: SQL2K und Import von Daten
    ... > hätte ich den weg über dts eingeschlagen, aber mit files, die 50 MB ... Ich bin davon ausgegangen dass wären SQL Dateien mit einzelnen DML ... Execute SQL Task zu verarbeiten dürfte eher speicherintensiver ... durch ADO Execute schicken, ...
    (microsoft.public.de.sqlserver)
  • Re: SQL 2000 Windows Authentication - Same User Multiple Groups
    ... App1 contains CRUD functionality using stored procs (EXEC perms on ... UpdateResearch stored procs. ... execute UpdateResearch. ... view-level permissions such that we can permit/deny a database action ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2000 Windows Authentication - Same User Multiple Groups
    ... App1 contains CRUD functionality using stored procs (EXEC perms on ... Resarch group (of which he is also a member), ... execute UpdateResearch. ... view-level permissions such that we can permit/deny a database ...
    (microsoft.public.sqlserver.security)
  • Re: Is that OK to run a windows application using a DTS task?
    ... through DTS and the form came up. ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > execute a windows application which have a user interface awaitting user ...
    (microsoft.public.sqlserver.dts)