executing serial dts

hi,

i am new here and interested in how to :

- execute serial dts in one single action or using vb script.

- change the status (enabled to disabled) and schedule using vb script.

Many dts make me tired when i have to change the status and schedule one by one.

regards.

You don't need to be tired. Read more here:

http://msdn.microsoft.com/msdnmag/issues/02/08/VBScriptandSQLServer2000/default.aspx

EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters

I had enabled SQL Trace and if i understand correctly SQL Trace will help us in finding slow stored procedures how ever when i click tables and traces i getthis "EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters" link.What am i suppose to do with this how do i analyze the sql trace data where is it.

I did open the load database there are lot of tables what all tables are of our concern..how do you analyze that kindly help.

I believe you can get a better response in the SQL Server Tools General forum. I moved your post.

EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters

I had enabled SQL Trace and if i understand correctly SQL Trace will help us in finding slow stored procedures how ever when i click tables and traces i getthis "EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters" link.What am i suppose to do with this how do i analyze the sql trace data where is it.

I did open the load database there are lot of tables what all tables are of our concern..how do you analyze that kindly help.

I believe you can get a better response in the SQL Server Tools General forum. I moved your post.