Try

dbcc opentran

to look for any open transaction. If nothing, you can try issuing a 'checkpoint' command on the database to commit data in the systems memory.

mmartin1 (7/21/2013)This issue may have more than meets the eye. Depending on the exact work that you do and the money you make, the company may be able to say...

This issue may have more than meets the eye. Depending on the exact work that you do and the money you make, the company may be able to say you...

You can create a data driven subscription for the user. Here you can define the report parameters and the report generates based on those and emails itself to the user,...

Right. It seems intuitive. I've found that has not always been the case with my queries.

I hope I dont confuse you here :

Select T1.C1, T2.C2

From T1 Left join T2

on T1.C1 =. T2.C2

is equivalent to

Select T1.C1, T2.C2

From T2 Right join T1

on T1.C1 =. T2.C2

The...

Create a date variable , assign the value of CONVERT(DATE, DateAdd(yy, - 5, GetDate())) to the variable and use the variable instead in your query. This may be more...

Just to be sure, is the config file with the user credentials stored in the same directory as...

I concur with opc.three comment above. Are the package, job on different machines? What about the target server of the ole db connection ?

Have you considered using the SSIS execute sql task? You can map parameters to it. If you need to do many somewhat independent things as a batch, add them as...

Will do Gail, appreciate your help. Thanks

A stored procedure and a view will both return you a result set. A stored procedure can accept parameters, such as start date and end date... whereas a view cannot....

Hi Gail. I hope I don't trouble you if you could post this example you mention? I have not dived deeply into the subject of execution plans and am curious...

How would using the sign function fit here? I don't think you can have a negative average of dropped calls.

thanks

I would just add that if a start date is greater than an ending data, there should be no data returned. The user will get the point sooner or later,...