Do you have sysadmin privileges on the server? I m just giving a guess in case you don't have permissions !

In the Job Properties ->Steps, Edit the step and go to advanced. You will find include step output in history, check that option.

Thanks LutZ. It works perfect

following is the right expression, I have the syntax wrong

"Select

ColA,

ColB,"

+(DT_STR,20,1252)@[User::VarA] + ","

+(DT_STR,20,1252)@[User::VarDate] + ","

ColC

From TableA"

May be you can consider updating stats only for the required tables. You don't need to update statistics for the entire database. So, you should know which tables cause the...

Born and Brought up in India

Working in BOSTON, USA

you can run the following query :

EXECUTE sp_msforeachdb 'select * from ?.information_schema.tables where table_name = ''articles'''

yep! This is what I m trying for ! Thank you

Sorry if i was not clear in my previous posts!!

Thank you all for the quick replies. I know the table which gives the output. But my concern is, I am not supposed to access the table directly, I...

You also can use a cursor in the outer proc. For each output it produces, you can call the Stored proc inside the cursor. But It is not good if...

Did you check if those logins exist in SQL Server Security? Probably, they might be existing under database logins but not under sql server security!!

If it is SQL Login, may be the login might be out of sync. you can try

EXEC sp_change_users_login 'Update_One', 'abc', 'abc'

If this doesn't work, you may have to open...

but you can use

DBCC SQLPERF("sys.dm_os_wait_stats",CLEAR); for only those 2 DMV's. it should reset those counters.

But not for all the DMV's

Thank you very much for all your add ons. Manu, I used your script , it is excellent. But I could get information of only 1 month, as We delete...

ok..This sounds good, atleast I will be able to estimate the size. Thanks a lot