Yeah that totally sucks, because even if you have a process that archives off the older trace files you'd probably be missing some in this case.

Reading the link Eugene provided will definitely help get better answers but here's something that I hope will help:

Select

Count(I.investorid) as investors,

F.fundID

From

...

There's nothing that jumps out at me as incorrect with the syntax of the expression. The only thing I'd wonder about is what happens when Fields!clockStart.Value is NULL. ...

Can you successfully run a SELECT query against the linked server?

What does sp_testlinkedserver do?

In my opinion, SQL will never go away. ORM tools like Entity Framework, Linq, Hibernate/nHiberante, are getting better but in every case I've seen thus far you still get...

I believe you need to make sure you are use the 32-bit DTEXEC. Check out this article about 2/3 of the way down.

Are all the reports deploying to the same folder on the report server?

It isn't clear, at least not to me, if this is an initial deploy or if you are...

That code is a series of CTEs (Common Table Expressions) that create a virtual numbers table.

CTE's require the previous statement to be terminated by a semi-colon (;) and because this...

The only way to fix this in the SP is to check the value of the column you care about and not include that column in the update if it...

I believe that you are talking about Intellisense. You can turn it on globally in SSMS by going to Tools -> Options -> Text Editor -> Transact-SQL -> Intellisense

Sapen,

What do you want to happen if there is a batch/multi-row insert and some of the rows should be inserted but some should not?

Sean Lange (5/14/2013)

---

Sapen (5/14/2013)

---

Sean Lange (5/14/2013)

---

Seems a bit strange that you can put a trigger on a table but not a unique constraint. The constraint will perform better and is...

Sean Lange (5/14/2013)

---

Seems a bit strange that you can put a trigger on a table but not a unique constraint. The constraint will perform better and is effectively doing the...

Are the columns NVARCHAR or NCHAR data types?

Have you created the DSN on the report server?

Does the report server have the Sybase ODBC driver?