I think this post might help you :

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/292c26f3-05b9-45fe-bd55-b35099de07e4/

Hi Guys

Thanks for those information.

On my server, default trace is enabled BUT I can't find the .trc file.

In sys.traces, path is always empty.

I Can't find any .trc file in SQL...

You can write the query as follow as well :

update [360MetaVerse].dbo.Country

set AreaInContinent = [DQMeta1].[dbo].[_Country].AreaPart,

SafeName = [DQMeta1].[dbo].[_Country].SafeName,

CountryLongName = [DQMeta1].[dbo].[_Country].CountryLongName,

OfficialLanguage = [DQMeta1].[dbo].[_Country].OfficialLanguage

from [DQMeta1].[dbo].[_Country]

WHERE [360MetaVerse].dbo.Country.ISOCountryCode = [DQMeta1].[dbo].[_Country].ISOCountryCodeID

Have a look at UPDATE...

I think you have something like :

blob_id comes from attachment.

Created_date comes from Purchase_Orders

You have 2 rows in Purchase_Orders linked to the same attachment but having different CReated_Date (different years)

When you...

Can you give the definition of the 3 tables involved ?

your problem is in the FROM part :

[DQMeta1].[dbo].[_Country].ISOCountryCodeID

SQL SErver interprets this as :

[DQMeta1] : Linked server

[dbo] : DbName

...

I guess you want do this instead :

begin tran

update [360MetaVerse].dbo.Country

set AreaInContinent =...

Hello,

You can use both read/sec and write/sec available from Physical Disk and Logical Disk counter sets.

Have a look here for extra guidance and information:

http://blogs.technet.com/cotw/archive/2009/03/18/analyzing-storage-performance.aspx

http://technet.microsoft.com/en-us/library/cc300400.aspx

http://blogs.technet.com/vipulshah/archive/2006/11/30/understanding-perfmon-counters-while-troubleshooting-sql-server-performance-issues.aspx

Note:...

It's time consuming if you do it manually.

- But you could do it using the UI for one job (adding an extra step to send email or modify if email...

Have a look at this video :

http://techsatwork.com/blog/?p=1250

It will show you how to set up database mail and then parameter job failure notification by email.

You can find a few information in DMVs (sys.dm_exec_query_stats) but there will not be that many details.

You will only know how many times it has been called since last server...

What do you mean exactly ?

Use something like this :

WHERE DatePart(minute, Your_Date_Field) % 15 = 0

yes, correct.

sql server 2008 R2 version number is 10.5

The step must have "Go to the next step" as "On failure Action".

See advanced tab in Job STep properties to set up this option.

Why don't you just try to modify the trustworthy option on your db to be sure ?

And yes, I think this could be the issue.