how to indicate if error exisits

I have created a package.Is there an option if you can know if the package had executed successfully or with the error...how do i need to set?how are you planning to execute the package? I think SS Agent has alert/notifications you could use...|||ok with sql server agent how do i include email address on error in my package..And what i am intrested is how send email task works...it shows errors witht this task.|||

Well, my sugestion was simpler than that. I was thinking to let the SS agent to sen an email when the job fails; so you don't have to modify the packages. The only thing is that the SS agent may not give a very detail reason of the failure.

You are right, you could use event handlers and send email task to do this, but it requires to modify the packages. In both cases, you can find information in these forums.

How to index tune 15 minutes of live activity?

With SQL 2005 Std. I once saw there is a way to use PerfMon (I think), or
some other logging tool, grab 15 minutes of data being executed on the live
SQL Server, and then do an index tuning analysis on that. Can someone
please tell me how?There is a tutorial on Database Engine Tuning Advisor on BOL. Go to SQL
Server 2005 Tutorials, SQL Server Tools Tutorials, Database Engine Tuning
Advisor Tutorial.
Ben Nevarez, MCDBA, OCP
Database Administrator
"D. Patrick" wrote:
> With SQL 2005 Std. I once saw there is a way to use PerfMon (I think), or
> some other logging tool, grab 15 minutes of data being executed on the live
> SQL Server, and then do an index tuning analysis on that. Can someone
> please tell me how?
>
>sql

How to index tune 15 minutes of live activity?

With SQL 2005 Std. I once saw there is a way to use PerfMon (I think), or
some other logging tool, grab 15 minutes of data being executed on the live
SQL Server, and then do an index tuning analysis on that. Can someone
please tell me how?There is a tutorial on Database Engine Tuning Advisor on BOL. Go to SQL
Server 2005 Tutorials, SQL Server Tools Tutorials, Database Engine Tuning
Advisor Tutorial.
Ben Nevarez, MCDBA, OCP
Database Administrator
"D. Patrick" wrote:

> With SQL 2005 Std. I once saw there is a way to use PerfMon (I think), or
> some other logging tool, grab 15 minutes of data being executed on the liv
e
> SQL Server, and then do an index tuning analysis on that. Can someone
> please tell me how?
>
>

How to identify most executed queries?

Hi All,
is there a way to identify which are the most executed queries or stored
procedures in a Sql Server 2000? I know that there are some commercial tools
that does it but I don′t want to waste money on it. Any suggestion?
Thanks
Celio.
Run a trace and dump and import the trace files into a table and run some
queries.
Andrew J. Kelly SQL MVP
"Cmsn Brazil" <Cmsn Brazil@.discussions.microsoft.com> wrote in message
news:4E45B85B-5EE4-41A9-AF3A-C3A1FAC72DE5@.microsoft.com...
> Hi All,
> is there a way to identify which are the most executed queries or stored
> procedures in a Sql Server 2000? I know that there are some commercial
> tools
> that does it but I dont want to waste money on it. Any suggestion?
> Thanks
> Celio.

How to identify most executed queries?

Hi All,
is there a way to identify which are the most executed queries or stored
procedures in a Sql Server 2000? I know that there are some commercial tools
that does it but I don′t want to waste money on it. Any suggestion?
Thanks
Celio.Run a trace and dump and import the trace files into a table and run some
queries.
Andrew J. Kelly SQL MVP
"Cmsn Brazil" <Cmsn Brazil@.discussions.microsoft.com> wrote in message
news:4E45B85B-5EE4-41A9-AF3A-C3A1FAC72DE5@.microsoft.com...
> Hi All,
> is there a way to identify which are the most executed queries or stored
> procedures in a Sql Server 2000? I know that there are some commercial
> tools
> that does it but I dont want to waste money on it. Any suggestion?
> Thanks
> Celio.

How to identify most executed queries?

Hi All,
is there a way to identify which are the most executed queries or stored
procedures in a Sql Server 2000? I know that there are some commercial tools
that does it but I don´t want to waste money on it. Any suggestion?
Thanks
Celio.Run a trace and dump and import the trace files into a table and run some
queries.
--
Andrew J. Kelly SQL MVP
"Cmsn Brazil" <Cmsn Brazil@.discussions.microsoft.com> wrote in message
news:4E45B85B-5EE4-41A9-AF3A-C3A1FAC72DE5@.microsoft.com...
> Hi All,
> is there a way to identify which are the most executed queries or stored
> procedures in a Sql Server 2000? I know that there are some commercial
> tools
> that does it but I don´t want to waste money on it. Any suggestion?
> Thanks
> Celio.